database - How to create tables in Oracle DB from the set of *.sql files -


i have set of *.sql files (>200) contains scripts of tables creation. how can apply of them automatically oracle db?

i use oracle sql developer environment

just create "driver" sql file, , call sqlplus - example, if have script1.sql, script2.sql, create file, "driver.sql" , include:

@script1.sql @script2.sql ...etc... 

Comments

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

git - How to list all releases of public repository with GitHub API V3 -

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -