oracle Ä£ºý²é尋

Òª¸ù據兩個變Á¿V_COLUMNºÍV_VALUE來確¶¨ÏëÒª²é詢µÄ內ÈÝ

SELECT * from A WHERE  V_COLUMN LIKE V_VALUE

V_COLUMN LIKE V_VALUE

這個請問ÒªÔõ樣處Àí 謝謝

---

²»È·¶¨µÄÇé¿öÏ£¬Ê¹Óö¯Ì¬SQL

---

這樣ѽ  Äܲ»ÄÜ貼ÉÏ´ú碼  ×î½ü沒寫pl/sql  ÓÐ點²»ÊìÁË

---

¶ÔÏóÃû²»ÄÜÓñäÁ¿´úÌ棬ÐèÒª¶¯Ì¬Óï¾äÀ´´¦Àí

---

¶¯Ì¬sql°É£¡È»ºó£å£ø£å£ã£õ£ô£å¡¡£é£í£í£å£ä£é£á£ô£å£¡

---

execute immediate 'select * from a where '||v_column||' like ''%'||v_value||'%''';

---

´íÁË
open ××× for  'select * from a where '||v_column||' like ''%'||v_value||'%''';

---

ÒýÓÃ

´íÁË
open ××× for  'select * from a where '||v_column||' like ''%'||v_value||'%''';

¾ÍÕâÑù£¡

---

ʹÓö¯Ì¬SQL;
'select * from a where '||v_column||' like ''%'||v_value||'%'''

---

ºÇºÇ  ºÃ¶à熱ÐÄÈËʿѽ

¶÷  ¸ã¶¨ÁË