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 Types of Commands Can Be Executed in SQL*Plus?

April 26, 2017commands executed types

0

Posted

What Types of Commands Can Be Executed in SQL*Plus?

1 Answer

0

Posted

There are 4 types of commands you can run at the SQL*Plus command line prompt: 1. SQL commands – Standard SQL statements to be executed on target database on the Oracle server. For example: “SELECT * FROM fyi_faq;” is a SQL command. 2. PL/SQL commands – PL/SQL statements to be executed by the Oracle server. For example: “EXECUTE DBMS_OUTPUT.PUT_LINE(‘Welcome to dba.fyicenter.com’)” runs a PL/SQL command. SQL*Plus commands – Commands to be executed by the local SQL*Plus program itself. For example: “SET NULL ‘NULL'” is a SQL*Plus command. OS commands – Commands to be executed by the local operating system. For example: “HOST dir” runs an operating system command on the local machine.