Wednesday, October 5, 2016

Find column semantics

›
When migrating from single-byte code to multi-byte code character sets, one way to move your data without data loss is to change the seman...
Monday, October 3, 2016

Use the dbms_flashback to set your session back in time

›
A convenient way to set your session back in time, is to execute the dbms_flashback.enable_at_time procedure. This way you can work with ...
1 comment:
Friday, September 30, 2016

Missing trailing slash in listener.ora caused ORA-27101 when attempting to connect

›
Not too long ago, I got an error when connecting to my database using TOAD: ORA-01034: ORACLE not available ORA-27101: shared memory realm ...
Tuesday, September 13, 2016

How to list partitions and their sizes

›
Using an inline view with a correlated subquery: set lines 200 col partition_name format a40 SELECT P.PARTITION_NAME, ( SELECT ROUND(SUM(...
Wednesday, August 31, 2016

How to list table sizes and their LOB segment sizes

›
Sometimes a quick sum of the used bytes in DBA_SEGMENTS is not enough to find the total size of a table. If you have Large Object type col...
3 comments:
Wednesday, August 24, 2016

How to add minutes, seconds, hours or days to a datetime value

›
Simply add the desired interval to your timestamp value: select current_timestamp, current_timestamp + interval '3' minute ...
Friday, August 19, 2016

Example on how to use WITH CHECK OPTION in an INSERT statement

›
The table "ALBUM" has the following columns: Name Null Type ------------ -------- ---------...