在运行存储在字符串变量中的sql语句时发现错误 [英] finding a error while running a sql statement stored in a string variable

问题描述

sql1 := 'select distinct l.displayname,l.Employee_Level as jobprofile from ph_mstlevelmapping l join PH_MstEmployee e
        on e.Employee_Level = l.Employee_Level   where e.Business = '|| Business ||' and e.Unit = '|| Unit ||' and e.Functions = '|| Function1 ||' and e.Department= '|| Department ||' and  e.EmployeeName <> '|| 'Admin' ||' and e.Employee_Level <> ''  order by jobprofile';

该语句中的错误会造成词素的错误....在运行时出现此错误

What''s wrong in this statement can sombody temme.... m gettin this error at runtime

ORA-00936: missing expression
ORA-06512: at "GSFINANCE.USP_GET_JOBPROFILE_4_GOALTEMP", line 40
ORA-06512: at line 15

行

请为我提供帮助.... !!!!!!

please help me with this ....!!!!!!

推荐答案

sql1 := 'select distinct l.displayname,l.Employee_Level as jobprofile from ph_mstlevelmapping l join PH_MstEmployee e
        on e.Employee_Level = l.Employee_Level
    where e.Business = '|| Business ||' and e.Unit = '|| Unit ||' and  e.Functions = '|| Function1 ||' and e.Department= '|| Department ||' and  e.EmployeeName <> '''|| 'Admin' || ''' and e.Employee_Level <> '' ''  order by jobprofile';

这篇关于在运行存储在字符串变量中的sql语句时发现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！