Monday, December 16, 2013

Is java installed in my database?

›
Check the following views to confirm whether or not java is a part of your Oracle installation: ALL_REGISTRY_BANNERS displays the valid co...
Friday, December 13, 2013

SQL statement to list all database objects and their sizes

›
Use the WITH clause to create two different subqueries that you can reference later in the query: WITH OBJECT_COUNT AS ( SELECT OW...
Thursday, December 12, 2013

SQL statement to find all referential integrity constraints that relates to a specific table

›
Here is how to use a self-join of the view USER_CONSTRAINTS to find constraints that is referring to a specific table. Note that you can a...
Friday, December 6, 2013

Two different ways to retreive the current System Change Number

›
Use either of the following methods: SQL> col current_scn format 9999999999999 SQL> select current_scn from v$database; CURRENT...
Friday, November 29, 2013

How to create a sequence and a trigger that will emulate "autonumber" in other RDBMS systems

›
If you have been working with other RDBMS systems, such as SQL Server from Microsoft, you may be used to a datatype called AUTONUMBER, which...
Wednesday, November 27, 2013

How does the 11gR2 feature "deferred segment creation" work?

›
Starting from 11gR2 onwards, Oracle introduced a feature called deferred segment creation . This means that Oracle will not need to create a...

What is the difference between automatic segment space management and manual segment space management?

›
In a locally managed tablespace, there are two methods that Oracle Database can use to manage segment space: automatic and manual. Manual ...