Tips and Tricks in a world of Mix

Archive for the ‘sql’ Category

useful sql

Backup data

If NEW_TABLE already exists then …

insert into new_table select * from old_table
/

If you want to create NEW_TABLE based on the records in OLD_TABLE …

create table new_table as select * from old_table
/


Advertisements

Tag Cloud

%d bloggers like this: