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, 2823🔥, 1💬
Popular Posts:
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...