??????.????????洢????
??????SQL*Plus ??????????????????洢???????EXECUTE????????:
????SQL> EXECUTE skeleton;
????SQL*Plus ????????????洢?????????: PL/SQL procedure successfully completed.
????????????????????PL/SQL???????????洢???????SQL*Plus??????????￡???????????
????1 SQL> BEGIN
????2 SKELETON;
????3 END;
????4 /
??????????????????????????洢????????????????????
??????.???????洢????
??????????д???????????“Hello World!”??洢???????Notepad?????skeleton.sql ???????DBMS_OUTPUT.PUT_LINE ?????????滻NULL??????????:
????CREATE OR REPLACE PROCEDURE skeleton
????IS
????BEGIN
????DBMS_OUTPUT.PUT_LINE('Hello World!');
????END;
???????浽???skeleton.sql.
??????SQL*Plus?????У? ?????skeleton.sql .
????SQL> @skeleton
????SQL>
????1 CREATE OR REPLACE PROCEDURE skeleton
????2 IS
????3 BEGIN
????4 DBMS_OUTPUT.PUT_LINE('Hello World!');
????5* END;
????SQL> /
????SQL*Plus ????洢???????????????????????Procedure created.
????SQL>
??????EXECUTE ???????????洢????:
????SQL> EXECUTE skeleton;
????SQL*Plus????洢???????г????PL/SQL procedure successfully completed.
????????????????????? "Hello World!"??г?????????????DBMS_OUTPUT.PUT_LINE ??????????????SET??????SQL*Plus ?????????????????
????SQL> SET SERVEROUTPUT ON
?????????????洢?????
????SQL> EXECUTE skeleton;
????????????????Hello World!
????PL/SQL procedure successfully completed.
??????.????????洢????
??????????????洢?????????????????裬???SQL??????????洢???????д洢????????????????????????????????????????????????????????????顣
??????????????洢????????????????У??????漰???????????????????????????????????PL/SQL????????????????????????????????????????????????Щ?????????λ??????????????????????????;
??????.????????洢????
???????????????????????????洢????????????????SQL??? DROP PROCEDURE ??????????????????洢?????DROP PROCEDURE ??SQL?б?????????????????(DDL) ???????????????????CREATE?? ALTER?? RENAME ??TRUNCATE??.
??????SQL*Plus ??????????￡????DROP PROCEDURE SQL ????????????skeleton??洢?????
????SQL> DROP PROCEDURE skeleton;
????SQL*Plus assures us the procedure has been removed:
????Procedure dropped.
???????
???????????????????????Oracle???????Oracle????洢???????衣????洢?????????п??????????????????????????????á?