??????????????????????У???????дORACLE?洢?????????????????????????????Щ??????CALLABLE???????洢???????飬?????????????????????Щ????????????????дORACLE?洢?????????????????????????·???????????????鷳?????????Oracle?洢??????洢??Oracle??????е????????
?????. ????
????Oracle?洢???????????????
???????Notepad???????????Oracle PL/SQL???????д????洢????;
??????Oracle??????д???????洢????;
??????Oracle??????????SQL*Plus???????д洢????;
??????Oracle??????????洢????;
?????????????????洢????;
????????洢????;
??????.????????
?????????????????
??????????????Notepad;
????Oracle SQL*Plus???????Oracle SQL??PL/SQL ???Oracle database??
????Oracle 10g express????????????????汾;
?????????????
????SQL?????????????????????????
???????Oracle's SQL*Plus????????????;
???????Oracle's PL/SQL ???????????????;
??????.д????洢????
?????洢???????Oracle's PL/SQL ?????????д????????д?????????????????洢??????????????????????????????????????????κ?????
??????Notepad?? д?￡?
????CREATE OR REPLACE PROCEDURE skeleton
????IS
????BEGIN
????NULL;
????END;
????????????skeleton.sql.
??????????????б???????洢????:
????1 CREATE OR REPLACE PROCEDURE skeleton
????2 IS
????3 BEGIN
????4 NULL;
????5 END;
??????1:CREATE OR REPLACE PROCEDURE ?????SQL?????Oracle?????????????????skeleton?洢????? ????????????;
??????2:IS???????????潫???????PL/SQL?塣
??????3:BEGIN????????PL/SQL???????
??????4:NULL PL/SQL?????????????????????????????PL/SQL????????????????;
??????5:END????????PL/SQL??????
??????.????????洢????
????SQL???CREATE OR REPLACE PROCEDURE??Oracle??????д?????????????????洢?????
??????Window??SQL*Plus?????SQL*Plus?????????????;??skeleton.sql???.
??????SQL>???????????????????????
????SQL>@skeleton
????SQL>/
????SQL*Plus???skeleton.sql??????????SQL*Plus?????????????SQL*Plus???;SQL*Plus ??????洢???????????????????
???????????洢????????????????????????Oracle????????????????????