SQL*Plus (MOSC)

MOSC Banner

Season's greetings

Hello Community Members,

let me wish you, the Oracle way:

    SET HEA OFF
    SET COLSEP ''
    COL x FOR A1
    SELECT MAX( CASE WHEN x =  1 THEN CHR( y ) END ) x
         , MAX( CASE WHEN x =  2 THEN CHR( y ) END ) x
         , MAX( CASE WHEN x =  3 THEN CHR( y ) END ) x
         , MAX( CASE WHEN x =  4 THEN CHR( y ) END ) x
         , MAX( CASE WHEN x =  5 THEN CHR( y ) END ) x
         , MAX( CASE WHEN x =  6 THEN CHR( y ) END ) x
         , MAX( CASE WHEN x =  7 THEN CHR( y ) END ) x
         , MAX( CASE WHEN x =  8 THEN CHR( y ) END ) x
         , MAX( CASE WHEN x =  9 THEN CHR( y ) END ) x

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