Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What commands can be executed from SQL*Plus?

April 26, 2017commands executed

0

Posted

What commands can be executed from SQL*Plus?

3 Answers

0

Posted

One can enter three kinds of commands from the SQL*Plus command prompt: 1. SQL*Plus commands – SQL*Plus commands are used to set options for SQL*Plus, format reports, edit files, edit the command buffer, and so on. SQL*Plus commands do not interact with the database. These commands do not have to be terminated with a semicolon (;), as is the case with SQL commands. The rest of this page is dedicated to SQL*Plus commands, eg. SHOW USER 2. SQL commands – for more information see the Oracle SQL FAQ. Eg: SELECT * FROM TAB; 3. PL/SQL blocks – for more information see the Oracle PLSQL FAQ. Eg: 4. BEGIN 5. DBMS_OUTPUT.PUT_LINE(‘Hello World!’); 6. END; 7.

0

Posted

One can enter three kinds of commands from the SQL*Plus command prompt: SQL*Plus commands SQL*Plus commands are used to set options for SQL*Plus, format reports, edit files, edit the command buffer, and so on. SQL*Plus commands do not interact with the database. These commands do not have to be terminated with a semicolon (;) (as is the case with SQL commands).

0

Posted

One can enter three kinds of commands from the SQL*Plus command prompt: 1. SQL*Plus commands – SQL*Plus commands are used to set options for SQL*Plus, format reports, edit files, edit the command buffer, and so on. SQL*Plus commands do not interact with the database. These commands do not have to be terminated with a semicolon (;), as is the case with SQL commands. The rest of this page is dedicated to SQL*Plus commands, eg. SHOW USER 2. SQL commands – for more information see the Oracle SQL FAQ. Eg: SELECT * FROM TAB; 3. PL/SQL blocks – for more information see the Oracle PLSQL FAQ. Eg: BEGIN DBMS_OUTPUT.PUT_LINE(‘Hello World!