Procedure:
create or replace procedure hello is
begin
DBMS_OUTPUT.PUT_LINE('hello');
end hello;
Call:
SET SERVEROUTPUT ON;
begin
hello;
end;
/
Showing posts with label PL/SQL. Show all posts
Showing posts with label PL/SQL. Show all posts
Oct 20, 2007
Oct 19, 2007
Connect to SQL*PLUS
C\:>sqlplus
input username, password
or run
SQL commandline from Oracle menu.
Simple SQL:
SQL>select * from table;
Simple PL/SQL:
SQL>SET SERVEROUTPUT ON;
2 BEGIN
3 DBMS_OUTPUT.PUT_LINE('hello');
4 END;
5 /
input username, password
or run
SQL commandline from Oracle menu.
Simple SQL:
SQL>select * from table;
Simple PL/SQL:
SQL>SET SERVEROUTPUT ON;
2 BEGIN
3 DBMS_OUTPUT.PUT_LINE('hello');
4 END;
5 /
Subscribe to:
Posts (Atom)