Most of customers have by now switched over to a Windows / SQL server environment, but we still have several customers who have stayed on Oracle for their Database needs. This mostly stems from having the Oracle skill set in-house as there is really no other advantage to staying on Oracle once you have moved over to Windows.
- Be sure to use a semicolon to end your statements. Otherwise the application doesn’t know when to run your query.
- Make sure the environment variable %ORACLE_HOME% is set correctly. ($ORACLE_HOME on Unix):
- To exit sqlplus user the “quit” command
- The SQL buffer contains the last statement you ran, and you can run the previous query again by simply typing “RUN” and hitting enter.
- User the LIST command to see a list of your most recently executed SQL commands.
- “HELP INDEX” shows a list of possible commands
- To launch a sql script simply put the “@” symbol in front of the file name and execute it. like: @script.sql or even @/path/to/script.sql