Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 32 Vote(s) - 2.72 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Plus Commands
02-18-2011, 02:21 AM,
#1
SQL Plus Commands
SQL*Plus commands allow a user to manipulate and submit SQL statements. Specifically, they enable a user to:

Enter, edit, store, retrieve, and run SQL statements
List the column definitions for any table
Format, perform calculations on, store, and print query results in the form of reports
Access and copy data between SQL databases
The following is a list of SQL*Plus commands and their functions. The most commonly used commands are emphasized in italics:

/ - Execute the current SQL statement in the buffer - same as RUN ACCEPT - Accept a value from the user and place it into a variable
APPEND - Add text to the end of the current line of the SQL statement in the buffer
AUTOTRACE - Trace the execution plan of the SQL statement and gather statistics
BREAK - Set the formatting behavior for the output of SQL statements
BTITLE - Place a title on the bottom of each page in the printout from a SQL statement
CHANGE - Replace text on the current line of the SQL statement with new text
CLEAR - Clear the buffer
COLUMN - Change the appearance of an output column from a query
COMPUTE - Does calculations on rows returned from a SQL statement
CONNECT - Connect to another Oracle database or to the same Oracle database under a different user name
COPY - Copy data from one table to another in the same or different databases
DEL - Delete the current line in the buffer
DESCRIBE - List the columns with datatypes of a table
EDIT - Edit the current SQL statement in the buffer using an external editor such as vi or emacs
EXIT - Exit the SQL*Plus program
GET - Load a SQL statement into the buffer but do not execute it
HELP - Obtain help for a SQL*Plus command (In some installations)
HOST - Drop to the operating system shell
INPUT - Add one or more lines to the SQL statement in the buffer
LIST - List the current SQL statement in the buffer
QUIT - Exit the SQL*Plus program
REMARK - Place a comment following the REMARK keyword
RUN - Execute the current SQL statement in the buffer
SAVE - Save the current SQL statement to a script file
SET - Set a variable to a new value
SHOW - Show the current value of a variable
SPOOL - Send the output from a SQL statement to a file
START - Load a SQL statement located in a script file and then run that SQL statement
TIMING - Used to time the execution of SQL statements for performance analysis
TTITLE - Place a title on the top of each page in the printout from a SQL statement
UNDEFINE - Delete a user defined variable
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  IO Error 17002 in Oracle SQL Developer Saleem Akhtar 1 12,140 12-17-2014, 07:51 PM
Last Post: Shoaib Ali
  Oracle SQL Developer not able to find Java Virtual Machine Justen Kegan 1 3,765 11-05-2014, 04:14 PM
Last Post: Balin Chakra



Users browsing this thread: 1 Guest(s)