BigSchmuh
asked on
SQL syntax problem (offiste) / ORA-00972: identifier is too long
Dear experts,
I currently have no access to my Oracle db (offsite)...but I need the attached .sql to work.
==> Currently it returns a "ORA-00972: identifier is too long" error...which I can not fix from my "notepad"
Can you help me to solve this SQL syntax problem (or explain why a 14557 cars long SQL is "too long") ?
Best regards
Telephone-KOdeSyntaxe.sql
I currently have no access to my Oracle db (offsite)...but I need the attached .sql to work.
==> Currently it returns a "ORA-00972: identifier is too long" error...which I can not fix from my "notepad"
Can you help me to solve this SQL syntax problem (or explain why a 14557 cars long SQL is "too long") ?
Best regards
Telephone-KOdeSyntaxe.sql
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@madveds: will your
translate(numtel, '0' || translate(numtel, '_1234567890', '_'), '0')
remove all but numeric cars from numtel col ?
@angelIII: I know what "identifier too long" means...but I can find it as well...
translate(numtel, '0' || translate(numtel, '_1234567890', '_'), '0')
remove all but numeric cars from numtel col ?
@angelIII: I know what "identifier too long" means...but I can find it as well...
You can also use REGEXP_REPLACE to strip out non-numerics:
select regexp_replace('1D3$f#rf3' ,'[^[:digi t:]]*','') from dual
/
select regexp_replace('1D3$f#rf3'
/
BigSchmuh: yes it is. it's exactly remove all non-numeric characters
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
usually, it's about some quotes not being closed....
however, I cannot see the actual problem in the sql posted