ex.. GENDER => M,F,T
not working this code
select empid ,empname,gender from emp_data where gender = nvl(:P12_GENDER,gender) ?
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Below is an example:
If the colon is used to separate values then use a colon instead of a comma.
Jems007
Cursor C1
is
select EMPCD,EMPNAME,LSTSAL,ESEX,EMRTSTS,EDESGN from empmst where
EDESGN in (SELECT t.EDESGN
FROM empmst t(Apex_String.Split(:P9944_EDESGN,':')) t
WHERE t.EDESGN IS NOT NULL);
not working..
Jems007
And my gender column in same table no need to use subquery ?
Vinish Kapoor
Do not change anything in the below cursor. Use as-is:
In the above query, "table" and "column_value" are the keywords, so do not change them.
Jems007
Working Thank You...