How do I import file with SQL commands?
You need a SQL interpreter for Oracle. The one that is bundled with every Oracle client installation is called SQL*Plus. And will do what you need to import a file with SQL commands.
You login with it to your Oracle server and then run your script. Let's say your Oracle connection is called mydb and your schema name is scott and your SQL script is stored in a file called myfile.sql. What you can do is:
$ sqlplus scott@mydbTo login to oracle (you will be prompted with your password). And then, once you are inside SQL*Plus, you can do:
> @myfile.sqlDone.
Use SQL*Plus or Oracle SQL developer.
With SQL*Plus:
sqlplus <schema>/<pw> @<your_script.sql>With SQL Developer, open your script, and then "run as script" (F5 I think).