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.
Follow these steps:
- Save your notepad file with . sql extension. c:\filename.sql
- Run it in the command prompt
c:>sqlplus “username/password” @”c:\filename.sql”
- Now you should Â get the result of your script. That’s it.