DDL

Data definition language (DDL) commands define and maintain data structures in the database. For example, commands for creating tables, modifying packages, dropping constraints.

Thumbnail image for The Difference between User and Schema in Oracle

The Difference between User and Schema in Oracle

As an Oracle developer, you have probably wondered at some point: do user and schema in Oracle really mean the same thing? And if they do, why does Oracle have two names for it? This post sheds light on the difference between user and schema in Oracle.

Read the Full Article →
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 ORA-02449: Solving the DROP TABLE Dilemma

ORA-02449: Solving the DROP TABLE Dilemma

Quick workaround to error ORA-02449. When you want to drop and recreate an Oracle table, but Oracle does not let you do so due to foreign key references.

Read the Full Article →
Thumbnail image for How to Add Table Column at Specific Position

How to Add Table Column at Specific Position

In Oracle, the ALTER TABLE command to add column appends the column to the end of all existing columns. What if you want the new column at a specific position in the table, not at the end? Here’s how to add a new column at a specific position.

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 →
Thumbnail image for What is CTAS?

What is CTAS?

When you want to base your Oracle table structure and data on an existing table, you use CTAS. Learn what that acronym means.

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 →