Welcome! Log In Create A New Profile

Advanced

Some help for you

Posted by franlowe 
Announcements Last Post
Announcement : Programming Students at UNISA School of Computing 06/19/2019 02:01PM
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
Some help for you
November 18, 2009 12:25PM
Here are some commands for SQL*Plus that I found recently and hope it helps someone that, just like me, got frustrated having to retype EVERYTHING when you make a spelling error.

Just type in these commands at the SQL*Plus command prompt ( SQL> )

LIST - Displays the current buffer
DEL - Deletes the last line from the buffer
INPUT - Adds a new line to the current buffer ( Add the new line after INPUT e.g. INPUT where salary > 500 )
EDIT - Edits your current buffer in a text editor and returns it when you save and exit
RUN - Executes the current SQL statement in the buffer
Sorry, only registered users may post in this forum.

Click here to login