How can I execute a file which include 'create table ' statement? for example file.out I want to execute in a procedure. I try @file.OUT,exec file.OUT but didn't work.
[B]Question asked by visitor joe[/b]
How can I execute a file which include 'create table ' statement? for example file.out I want to execute in a procedure. I try @file.OUT,exec file.OUT but didn't work.
[B]Question asked by visitor joe[/b]
write the SQL statments to a file and save with the extension .SQL
then use
SQL> @filename
it will execute.