ÉèΪÊ×Ò³ ¼ÓÈëÊÕ²Ø

TOP

oraclereturninginto
2015-07-24 10:40:42 À´Ô´: ×÷Õß: ¡¾´ó ÖРС¡¿ ä¯ÀÀ:2´Î
Tags£ºoraclereturninginto

returning into Óï¾äÓÃÓÚÖ´ÐÐÍêÓï¾äºó·µ»ØµÄÖµ£¬¾ßÌå·µ»ØÖ´ÐÐ֮ǰ»òÕßÖ®ºóµÄ½á¹û£¬ÈçÏÂËùÊö£º

deleteÓï¾äµÄreturning intoÓï¾ä·µ»ØµÄÊÇdelete֮ǰµÄ½á¹û£»
insertÓï¾äµÄreturning intoÓï¾ä·µ»ØµÄÊÇinsertÖ®ºóµÄ½á¹û¡£
updateÓï¾äµÄreturning intoÓï¾ä·µ»ØµÄÊÇupdateÖ®ºóµÄ½á¹û¡£
returning into Óï¾äÓëreturnͨÓÃ
insert into valuesÓï¾äÖ§³ÖreturningÓï¾ä£¬insert into selectÓï¾ä²»Ö§³Ö¡£
mergeÓï¾ä²»Ö§³ÖreturningÓï¾ä¡£

Àý£ºÈçϵÄÓï¾ä¶¼ÔÚ´æ´¢ÖУ¬v_ageΪÉùÃ÷µÄÒ»¸ö±äÁ¿

insert into t_test values (1, 'zhangsan','27') returning age into v_age;

update t_test set age = '28' returning age into v_age;

delete t_test returning age into v_age;


¡¾´ó ÖРС¡¿¡¾´òÓ¡¡¿ ¡¾·±Ìå¡¿¡¾Í¶¸å¡¿¡¾Êղء¿ ¡¾ÍƼö¡¿¡¾¾Ù±¨¡¿¡¾ÆÀÂÛ¡¿ ¡¾¹Ø±Õ¡¿ ¡¾·µ»Ø¶¥²¿¡¿
·ÖÏíµ½: 
ÉÏһƪ£ºORACLE¨D001£ºAlterÖ®Ôö¼Ó×ֶΣ¬Ð.. ÏÂһƪ£ºsqlplusÖÐÔõô½«ÄãËùÓеIJÙ×÷ºÍ½á..

ÆÀÂÛ

ÕÊ¡¡¡¡ºÅ: ÃÜÂë: (ÐÂÓû§×¢²á)
Ñé Ö¤ Âë:
±í¡¡¡¡Çé:
ÄÚ¡¡¡¡ÈÝ:

¡¤Ò»ÆªËµÈË»°µÄÎÄÕ£¬ (2025-12-27 07:50:09)
¡¤Python Web¿ò¼ÜÄÄ¼Ò (2025-12-27 07:50:06)
¡¤»ùÓÚPythonµÄÊý¾Ý·Ö (2025-12-27 07:50:03)
¡¤ÉîÈëÀí½â Java ¼¯ºÏ (2025-12-27 07:22:48)
¡¤Java¼¯ºÏ¿ò¼ÜÈ«Ãæ½â (2025-12-27 07:22:45)