SQL* Plus commands

Category

• Environment : Affect the general behavior of SQL statements for the session
• Format : Format query results
• File manipulation : Save, Load, and script files
• Execution : Send SQL statements from the SQL buffer to the Oracle  server
• Edit : Modify SQL statement in the buffer
• Interaction : Create and pass variables to SQL statements, print variable values and print messages to the screen
• Miscellaneous : Connect to the database, manipulate the SQL*Plus environment, and display column definition.
  

SQL*Plus Editing commands

• A[PPEND] text : Adds text to the end of the current line
• C[HANGE] / old / new : change old text to new in the current line
• C[HANGE] / text : Deletes text from the current line
• CL[EAR] BUFF[ER] : Delete all lines from the SQL buffer
• DEL : deletes current line
• DEL n : DElete line n
• DEL m n : deletes line m to n inclusive
• I[NPUT] : Inserts an indefinite number of lines
• I[NPUT] text : Inserts a line considering of text
• L[IST] : Lists all lines in the SQL buffer
• L[IST] n : Lists one line (specified by n)
• L[IST] m n : Lists a range of lines (m to n) inclusive
• R[UN] : Displays and runs the current SQL statement in the buffer
• n : specifies the line to make the current line
• n text : specifies line n with text
• 0 text : Inserts a line before line 1
  

** You can enter only one SQL*Plus command for each SQL prompt. SQL*Plus commands are not stored in the buffer. To continue a SQL*Plus command on the next line, end the first line with a hyphen(-).