How to Use SQL Plus With a DOS Command Window

Save

SQL Plus is the command line interface for the Oracle relational database. It allows you to interact with the database by using a text based interface. SQL Plus is accessed through a DOS command prompt window on the Windows operating system. The DOS command prompt window is the Windows text based interface. This interface gives the user the option to use DOS commands on modern Windows systems. The commands are typed in using the computer's keyboard.

Things You'll Need

  • Windows Operating System
  • Open a \"Command Prompt\" window. The \"Command Prompt\" window will be found under the \"Accessories\" section of the \"Start\" menu.

  • Type the command \"sqlplus username/password@database\" to start SQL Plus. Replace the word \"username\" with your Oracle username. Replace the word \"password\" with your Oracle password. Replace the word \"database\" with the name of the database you want to connect to. You will be presented with an \"SQL>\" prompt when you have successfully connected to the database.

  • Type the statements and queries that you want to execute at the \"SQL>\" prompt.

  • Type the \"host\" command to execute DOS commands from within the SQL Plus program. For example, \"host dir\" will run the DOS \"dir\" command which prints the contents of your current directory.

  • Type the command \"exit\" to leave the SQL Plus program.

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!