??java????oracle?洢???????
???????????? ???????[ 2014/5/27 11:42:02 ] ????????java oracle
????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;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11