Collections:
Types of Commands Executed in SQL*Plus in Oracle
What Types of Commands Can Be Executed in SQL*Plus in Oracle?
✍: FYIcenter.com
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.
2020-08-13, 871👍, 0💬
Popular Posts:
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic...
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...