multiple script delimeter

[birat]

I'm trying to run 2 simple Selects and I don't know the supported delimeters.

EX.

select * from employees

select * from departments

How do I accomplish this? Thanks

 

[aotte]

Assuming you mean to run both selects with one click of the button:

1) Place a semi-colon ";" in between the two statements
2) Execute it from a command window

 

[birat]

That was just a simple example. I'm trying to run migration script having at least 100 SQL statements with some conditional logic.

 

[Marco Kalter]

You mention conditional logic? That would indicate a PL/SQL block. Where are you migrating from?

Or is this an existing SQL*Plus script? In that case you would need to use the Command Window.

 

[birat]

oracle to oracle. not exactly a migration from different DBMS to another, but migrating from an old version of our app to newer one.

I just need to check if table or column already exist then if not, create the new objects. otherwise don't.

 

[Marco Kalter]

How does your old code do this?