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!

Error for ORA-01722: invalid number

873006Mar 27 2012 — edited Apr 11 2012

Hi Team,

I have table called site in this i have 2 column 1 is bfg_site is number data type and 2 one is expedio_site_id is a varchar2(100) i am using there below query and getting the
error message like invalid number please help on this..

SELECT DISTINCT site_id
FROM site
where bfg_site_id = 652232
or ( to_number (trim(to_char (expedio_site_id))) =to_number (trim (to_char (652232)))
and regexp_like (expedio_site_id, '^[0-9]')
);

Thank for advance.

This post has been answered by kendenny on Apr 11 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2012

Added on Mar 27 2012

20 comments

2,462 views