A beginners tutorial for Oracle SQLPlus.
Tutorial Details:
Database Oracle Oracle SQL*Plus
At the SQL prompt, you can begin typing any SQL command. Upon hitting return (i.e., enter key) the SQL prompt will change to line number prompts. When you are finished typing a command, type / or RUN to execute the SQL command. Also, a semicolon at the end of the SQL command will execute the command immediately after hitting return.
In addition to SQL commands, /, and RUN, other commands can be issued at the SQL prompt (a semicolon does not have to follow the nonSQL commands).
DESCRIBE tablename--lists the attributes and their specifications of tablename
EDIT--Places you in an editor (Notepad). The buffer contents are put into the
editor
GET filename--Retrieves a file and places it into the buffer
SAVE filename--Saves the buffer to the name file
CLEAR BUFFER--Clears the buffer
Read
Tutorial at: Click here to view the tutorial
Rate Tutorial: Database Oracle Oracle SQL*Plus Tutorial
View Tutorial: Database Oracle Oracle SQL*Plus Tutorial
Related
Tutorials:
|
Oracle Books