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 .
Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
›
Platform as a Service (PaaS)
›
Oracle Technology
›
SQL & PL/SQL
SQL Plus Commands
SQL Plus Commands
SQL Plus Commands
|
02-18-2011, 02:21 AM,
|
|||
|
|||
SQL Plus Commands
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 |
|||
« Next Oldest | Next Newest »
|
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)
Current time: 10-04-2024, 01:28 AM
Powered By MyBB, © 2002-2024 MyBB Group.