-
Could you please explain ?
HI,
Could you please explain me the bold lines from the following query?
select
lms_user.userid userid,
lms_user.lastname lastname,
lms_user.firstname firstname,
lms_user.registeredname userregname,
lms_user.emailaddress useremail,
lms_user.status status,
lms_user.objectcreateddate objectcreateddate,
lms_user.objectmodifieddate objectmodifieddate,
lms_userext.column01 column01,
lms_userext.column02 column02,
lms_userext.column03 column03,
lms_listofvalues.value statusValue,
lms_subdomain.subdomainid subdomainid,
lms_subdomain.registeredname sdregname,
lms_jobcode.registeredname jobcoderegname ,
lms_jobcode.title jobcodetitle
from
lms_user,
lms_sd_user,
lms_subdomain,
lms_listofvalues,
lms_userext,
lms_jobcodeuser,
lms_jobcode
where
lms_user.status=lms_listofvalues.listofvaluesid
and
lms_listofvalues.value=:"SYS_B_00"
and
lms_userext.userid = lms_user.userid
and
lms_userext.column16 >= :"SYS_B_01"
and
lms_userext.column16 <= :"SYS_B_02"
and
( (
upper(lms_user.firstname) like :"SYS_B_03" ESCAPE :"SYS_B_04"
and
upper(lms_user.lastname) like :"SYS_B_05" ESCAPE :"SYS_B_06"
and
upper(lms_user.emailaddress) like :"SYS_B_07" ESCAPE :"SYS_B_08"
and
upper(lms_user.registeredname) like :"SYS_B_09" escape :"SYS_B_10"
)
)
and
lms_user.accountid = :"SYS_B_11"
and
lms_sd_user.userid = lms_user.userid
and
lms_sd_user.subdomainid in (:"SYS_B_12")
and
lms_subdomain.subdomainid = lms_sd_user.subdomainid
and
lms_jobcodeuser.userid(+) = lms_user.userid
and
lms_jobcode.jobcodeid (+)= lms_jobcodeuser.jobcodeid
and
rownum <= :"SYS_B_13"
Thanks in advance,
Srinivas Medukonduru
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|