Basic Oracle Concepts and Programming Question:
How To Run SQL Commands in SQL*Plus?
Answer:
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 globalguideline.com tutorials!'
2 FROM DUAL
3 ;
'WELCOMETOglobalguideline.COMTUTORIALS!'
-----------------------------------
Welcome to globalguideline.com tutorials!
SQL> SELECT 'Welcome!' FROM DUAL;
'WELCOME
--------
Welcome!
SQL> SELECT 'Welcome to globalguideline.com tutorials!'
2 FROM DUAL
3 ;
'WELCOMETOglobalguideline.COMTUTORIALS!'
-----------------------------------
Welcome to globalguideline.com tutorials!
| Previous Question | Next Question |
| What Types of Commands Can Be Executed in SQL*Plus? | How To Run PL/SQL Statements in SQL*Plus? |