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

Question:

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.

Answer:

Follow these steps:

  1. Save your notepad file with . sql extension. c:\filename.sql
  2. Run it in the command prompt
    c:>sqlplus “username/password” @”c:\filename.sql”
  3. Now you should  get the result of your script. That’s it.
Powered by Y! Answers

One thought on “What is the command-line code to load a SQL script in notepad to Oracle 10g express?”

  1. Follow this :1) Save your notepad file with . sql extension. c:filename. sql2) Run it in the command prompt c:>sqlplus “username/password” @”c:filename. sql”3) Now you can get the result of your script. Thats all.

Leave a Reply

Your email address will not be published. Required fields are marked *