????1??????洢??????洢?????????????????????γ?????????????????????????SELECT?????????????????????????????????????????????????????????????????INSERT??DELETE??????????????????????????????????е???????????????洢??????????????????????ж?????
????2????????????洢????
???????????????????洢?????????????????????????洢??????洢??????????Щ???????е???????Щ?????????????????????????е?????????????д洢??????????????ó??????????????????
????.???????????????????????????????
????.???????????????????????????????????????????
???????磬?????????ó?????????????????????????????漰?????????????????洢????????????Щ????????????????????????????????????
???????????????????????????????????????????????????????????洢???????????????????????????????????貧??????????????????Ч???????????????
????3???洢????????
???????з????????洢???????????????Щ????????Щ????????????????
??????????????????????????????洢??????????
??????????????????????洢??????????????????
????????????????/????????????????????????洢?????????????????洢??????????????????
??????????????????????洢??????????????????????
??????????????????????е????????????????????????????????磬InterBase?????????????
????4??oracle ?洢??????????
????1.??????
????CREATE OR REPLACEPROCEDURE ?洢????????
????(
????????1 IN NUMBER??
????????2 IN NUMBER
????) IS
????????1 INTEGER :=0;
????????2 DATE;
????BEGIN
????END ?洢????????
????2.SELECT INTO STATEMENT
??????select????????????????У?????????????д洢????????У??????????
??????????????????(?????м?????NO_DATA_FOUND)
?????????
????BEGIN
????SELECT col1??col2 into ????1??????2 FROM typestruct where xxx;
????EXCEPTION
????WHEN NO_DATA_FOUND THEN
????xxxx;
????END;
???????????????洢????
?????洢???????
????CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2??PARA2 IN VARCHAR2) AS
????BEGIN
????INSERT INTO HYQ.B_ID (I_ID??I_NAME) S (PARA1?? PARA2);
????END TESTA;