How can I execute a file which include 'create table ' statement

[Geek_Guest]

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.

Question asked by visitor joe

[debasisdas]

write the SQL statments to a file and save with the extension .SQL

then use

SQL> @filename

it will execute.