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

TOP

oraclereturninginto
2015-07-24 10:40:42 À´Ô´: ×÷Õß: ¡¾´ó ÖРС¡¿ ä¯ÀÀ:1´Î
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Ù×÷ºÍ½á..

ÆÀÂÛ

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

¡¤About - Redis (2025-12-26 08:20:56)
¡¤Redis: A Comprehens (2025-12-26 08:20:53)
¡¤Redis - The Real-ti (2025-12-26 08:20:50)
¡¤Bash ½Å±¾½Ì³Ì¡ª¡ªLi (2025-12-26 07:53:35)
¡¤ÊµÕ½Æª£¡Linux shell (2025-12-26 07:53:32)