Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I NEED TO LPAD (UNI_CHARGE_NO,5,0)

3863Jan 29 2002
BELOW IS MY QUERY BUT I NEED TO CHANGE IT SO THAT I CAN INCLUDE THE 3 DIGIT DEPT NO USING LPAD FUNCTION. WHEN I RUN THIS QUERY IT GIVES ME AN ERROR INVALID RELATIONAL OPERATOR. PLEASE HELP ME ORGANIZE THIS QUERY TO RETRIEVE THE DEPT NUMBERS WITH 3 DIGITS TO HAVE 5 DIGITS.
LILEE



UPDATE GEO_BIT_RAWDATA
SET INTERFACE_STATUS = INTERFACE_STATUS + 1
WHERE UNI_CHARGE_NO NOT IN (SELECT FLEX_VALUE
FROM FND_FLEX_VALUES
WHERE FLEX_VALUE_SET_ID = 20202
AND ENABLED_FLAG = 'Y'
AND SUBSTR(COMPILED_VALUE_ATTRIBUTES,3,1) = 'Y'
AND STRUCTURED_HIERARCHY_LEVEL IS NULL)
AND GEO_RUN_NUMBER = :RUN_NUMBER;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2002
Added on Jan 29 2002
11 comments
359 views