PL/SQL (MOSC)

MOSC Banner

Improve the output on the query

edited Mar 18, 2013 4:44AM in PL/SQL (MOSC) 2 commentsAnswered
Hi, Folks.

   I am using a query below

select (CASE
  2  When substr(di.MATRICULA, 1, 2 ) = '00' then decode(t3.grupo, 'A', 'FR', 'B', 'FR', 'H', 'FC', 'I', 'FC', 'D', 'FC')||substr(di.MATRICULA, 2,5)
  3  else decode(t3.grupo, 'A', 'FR', 'B', 'FR', 'H', 'FC', 'I', 'FC', 'D', 'FC')||SUBSTR(di.MATRICULA, 1, 5)
  4  END ) as idioma_matricula,
  5  ibc.dc_idioma as idioma_nmIdioma,
  6  --di.habilidade as idioma_cdHabilidade,
  7  --DI.dominio_habilidade,
  8  --DECODE(DI.dominio_habilidade, '1', 'Basico', '2', 'Intermediario', '3', 'Avançado', '4', 'Fluente', '', '') as idioma_nv_idioma,
  9  --DECODE(DI.habilidade, '1', 'Leitura', '2', 'Escrita', '3', 'Conversação', '', '') as idioma_habilidade,

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