CTAS

Thumbnail image for How to Delete Old Data from a Database Schema

How to Delete Old Data from a Database Schema

DELETE script or CTAS DROP-RENAME script: ways to purge old data from a database schema so that it retains only the current year’s rows in all the tables in the schema, and the rest of the data is erased.

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 →
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 →