Oracle SQLPLUS Editing Commands


ACTIVITY					COMMAND		ABBREVIATION


Add text at end of current line			APPEND text		A text


Change current line				Type the line number



Change text in current line			CHANGE/old/new	C/old/new


Delete all lines from buffer			CLEAR BUFFER	CL BLUFF


Delete current line				DEL



Edit the entire comman currently		EDIT			
in thebuffer using an editor such
as Notepad

Insert line following current			INPUT			I
line


List the command currently			LIST			L
in the buffer

Run the command currently			RUN			R
in the buffer

Save the sql query in the buffer	    	SAVE fname.sql