academy_oracle/2021_07_30_system.sql at main · holioud/academy_oracle · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
-- 2021.07.30(금)

-- DBMS_OUTPUT 패키지 확인

set SERVEROUTPUT on
begin
DBMS_OUTPUT.PUT_LINE('Hello World~!!');
end;

DBMS_OUTPUT.PUT_LINE('Hello World');
--패키지명.저장프로시저명

SELECT OBJECT_NAME FROM DBA_OBJECTS
WHERE OBJECT_TYPE='PACKAGE'
AND OBJECT_NAME LIKE 'DBMS_%'
ORDER BY OBJECT_NAME;