Friday, July 31, 2009

What is the commandline code to load a SQL script in notepad to Oracle 10g express?

I made a script using notepad but what is the command line code to load it into oracle express 10g? In MySQL it is just source C: or where ever I have it located.

What is the commandline code to load a SQL script in notepad to Oracle 10g express?
Follow this :





1) Save your notepad file with .sql extension.





c:\filename.sql





2) Run it in the command prompt





c:\%26gt;sqlplus "username/password" @"c:\filename.sql"





3) Now you can get the result of your script.





Thats all.

gladiolus

No comments:

Post a Comment