New column or add one more column

Toad for Oracle
1

hello,
It is possible from an existing table to create another similar table with one more field and with records. Without occupying alter.
Thank a lot
:slight_smile:

2

Sure. In the editor, run this:

Create new_table_name as select * from old_table_name;

then alter new_table_name and add whatever columns you want.

Or you can change the select however you want to include additional columns.