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.
⇒ Run SQL Commands in SQL*Plus in Oracle
⇐ Reset Lost SYSTEM Password in Oracle
2020-08-13, 2094🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...