Data Dictionary

Read-only reference tables and views for Oracle database metadata. Oracle’s data dictionary includes definitions of schema objects, tablespace and auditing information, etc. Most data dictionary views come in three flavors distinguished by their prefixes: DBA, ALL and USER.

Thumbnail image for Drop and Recreate All Foreign Keys on Oracle Table

Drop and Recreate All Foreign Keys on Oracle Table

You might need to reistate a dropped table in Oracle, and in doing so, restore the foreign keys as well. Here’s how to drop and recreate all foreign keys on an Oracle table.

Read the Full Article →
Thumbnail image for The Special DUAL Table in Oracle

The Special DUAL Table in Oracle

DUAL is a special one-row, one-column table in Oracle data dictionary. Some trivia about DUAL table in Oracle and best practices for using DUAL in SQL.

Read the Full Article →
Oracle Views

20 Things You Should Know About Oracle Views

This one just might fail the Duck Test. It looks like a table, acts like a table, responds to SQLs like a table – but it is NOT a table. Learn about features and best practices for dealing with Oracle views.

Read the Full Article →
Rename Column in an Oracle Table

Rename Column in an Oracle Table

Post 9i Oracle gives you a direct command to rename column in an Oracle table. Here’s how to do it. Bonus: workaround to rename a table column in older versions of Oracle.

Read the Full Article →
Thumbnail image for Which objects depend on a given table?

Which objects depend on a given table?

A database table usually has other objects referring to it — tables linked through foreign keys, stored procedures referring to it, views created on it. This is how you can find out which objects refer to this table.

Read the Full Article →
Page 2 of 2
1
2