Could you please explain ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Could you please explain ?

  1. #1
    Join Date
    Dec 2000
    Posts
    95

    Question 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

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Bind variables....
    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
  •  



Click Here to Expand Forum to Full Width