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, 2932🔥, 1💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...