Collections:
Run SQL Commands in SQL*Plus in Oracle
How To Run SQL Commands in SQL*Plus in Oracle?
✍: FYIcenter.com
If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example:
SQL> SELECT 'Welcome!' FROM DUAL; 'WELCOME -------- Welcome! SQL> SELECT 'Welcome to FYIcenter.com tutorials!' 2 FROM DUAL 3 ; 'WELCOMETOFYICENTER.COMTUTORIALS!' ----------------------------------- Welcome to FYIcenter.com tutorials!
⇒ Run PL/SQL Statements in SQL*Plus in Oracle
⇐ Types of Commands Executed in SQL*Plus in Oracle
2020-08-03, 2836🔥, 1💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...