在Oracle连接Sql查询中使用变量

Question

我试图在SQL查询中使用变量，但失败了。这么做是怎么回事？

 var SicilNumvber = SessionCurrentUser.EMPNO;
                    string query = "select * from crm_visible_v where ownerid in (select sicilno from personel.pkim_kutlama@netdb_1.europe.nortel.com where cikis_tarihi is null start with sicilno = :SicilNumvber   connect by prior sicilno = amir)";

问候

Answer 1

成功查询如下:谢谢您的帮助；

string query = "select * from crm_visible_v where ownerid in (select sicilno from personel.pkim_kutlama@netdb_1.europe.nortel.com where cikis_tarihi is null start with sicilno ='"+SicilNumvber+"' connect by prior sicilno = amir)";    

Answer 2

请像下面所做的那样，将固定的字符串与变量部分连接起来。

     string query := 'select * from crm_visible_v where ownerid in (select sicilno 
     from personel.pkim_kutlama@netdb_1.europe.nortel.com where cikis_tarihi is null    
     start with sicilno ='||SicilNumvber||' connect by prior sicilno = ''''amir'';