SQL Language (MOSC)

MOSC Banner

select .. case ... regexp_like in sql statement

edited Sep 8, 2011 5:26AM in SQL Language (MOSC) 2 commentsAnswered
where is wrong with this statement:
select username
          case
                 when regexp_like(USERNAME, '^[0-9]')
                 then 'select ''alter user '' || username || '' identified by values '' || chr(39) || password || chr(39) || '';''
                when regexp_like(USERNAME, '^[A-Za-z]')
                then 'select ''alter user '' || username || '' identified by values '' || chr(39) || password || chr(39) || '';''
        end
from dba_users;


I get:

ora-00905 missing keyword    at  

when regexp_like(USERNAME, '^[A-Za-z]')
                                                    *

is there a way to make this better?

thanks.





Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center