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