Matas Vaitkevicius
Matas Vaitkevicius

Reputation: 61391

sql server GO equivalent in oracle

I am working on migration script for Oracle, I need to change table structure and then populate it with data.

I would like to do the structure changes first and then do the data.

In SQL Server I would use GO to separate the batches.

Is there an SQL Server GO command equivalent in Oracle?

Upvotes: 11

Views: 17392

Answers (1)

Matas Vaitkevicius
Matas Vaitkevicius

Reputation: 61391

It's ; and /

select * from user_tables;
/

Upvotes: 20

Related Questions