·  PLSQL – Application

 

- Info:

  - This tutorial shows how to create "PL/SQL Application" using different editors.

 

- TOAD:

  - Start TOAD – Session – New Connection – User/Schema: myUser – Password: myPassword – Connect

  - Database – Editor – Paste PL/SQL

  - Debug – Script Debuger

  - DBMS Output – Turn Output On (it is positioned below editor on Desktop Panels)

  - Debug – Run F11 (or Editor – Execute as Script F5)

  - DBMS Output (to view the output)    

 

    PL/SQL

    DECLARE

      text VARCHAR2(30);

            

    BEGIN 

      text := 'Hello World';

        

      DBMS_OUTPUT.PUT_LINE(text);

              

    END;