How you Run PL/SQL Statements in SQL*Plus?
Submitted by: AdministratorIf you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example:
SQL> SET SERVEROUTPUT ON
SQL> EXECUTE DBMS_OUTPUT.PUT_LINE('Welcome to globalguideline!')
Welcome to globalguideline!
PL/SQL procedure successfully completed.
Submitted by:
SQL> SET SERVEROUTPUT ON
SQL> EXECUTE DBMS_OUTPUT.PUT_LINE('Welcome to globalguideline!')
Welcome to globalguideline!
PL/SQL procedure successfully completed.
Submitted by:
Read Online Oracle Database Developer Job Interview Questions And Answers
Top Oracle Database Developer Questions
| ☺ | How you can Download Oracle Database 10g XE? |
| ☺ | Explain Oracle Server Autotrace in Oracle? |
| ☺ | Explain Parameter File in Oracle? |
| ☺ | Explain System Global Area (SGA) in Oracle? |
| ☺ | Explain Initialization Parameter File in Oracle? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
