What Types of Commands Can Be Executed in SQL*Plus
What Types of Commands Can Be Executed in SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool
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.
2007-04-29, 4432👍, 0💬
What is thread? A thread is an independent path of execution in a system.
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
What is page thrashing? Some operating systems (such as UNIX or Windows in enhanced mode) use virtua...
How can I implement a thread-safe JSP page? You can make your JSPs thread-safe by having them implem...
Can you prevent a class from overriding ? If you define a class as “Sealed” in C# and “NotInheritab...