Oracle Database import .sql file by command prompt

Question

I want to import .sql file in Oracle by command prompt so please tell me that command to import .sql file in oracle in MYSQL I am using it like this

mysql -u root -p -h localhost softpoint < D:\Nisarg\NEult\softpoint.sql 

but In Oracle I don't know how to use this utility so please help me

Thanks

Solution 1

In Oracle, to run a script (.sql) you use SQLPLUS command line utility.

c:\> sqlplus user_name/user_password@connect_string @path\your_sql.sql

Solution 2

Try to use sqlplus:

  sqlplus user/password@connect @/Nisarg/NEult/softpoint.sql

More information.

Solution 3

It's worth knowing you can have a space between @ and the input file, which enables the use of the tab key auto completion.