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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Case separated by Semicolon error

sdfsdf sdfsdfsdfOct 29 2024

Hi,

I need to separate columns by semicolumn but when I add a case it gives me an error:

select distinct b.ty ||';'||
case when st = 456 then 'good'
    when st = 32423 then 'NOTgood'
    else to_char(st)
    END AS SALIDA ||';'|| a.group
                   from hist a INNER JOIN def_job b
                                               on a.tab=b.parent_table
                                               inner join def_tables dt
                                               on a.center = dt.center
                                               and a.tab = dt.tab
                                               and a.center = dt.center
                                               and dt.ta = b.ta
                                               and a.job_mem_name=b.jjjj
                                               WHERE
                 to_char(start_time,'YYYYMMDD') = to_char(current_date-1,'YYYYMMDD')
                 and a.center in ('CAR')
SQL Error [923] [42000]: ORA-00923:

Any help please? Thanks

This post has been answered by James Su on Oct 29 2024
Jump to Answer
Comments
Post Details
Added on Oct 29 2024
5 comments
93 views