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!
2020-08-03, 972👍, 1💬
Popular Posts:
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Concatenate Two Text Values in Oracle? There are two ways to concatenate two text values toge...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...