Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

TRANSFORMATION:

Function, which changes its obJect can be called a transformation, These functions are  TRANSLATE, DECODE

We want to display descriptive report name against stored report_type column. In our example 'BS', 'PL' has been stored in report-type column refers to Balance-sheet and Profit and Loss Account, Let us display report-type and report description using the function decode ( ), The parameters are To be verified

column-name, value of column, if that value is true then what to display, second value, if second value true what to display and else )

Decode( value,   ifl,  thenl,   if2,  then2,   else  ) In this case value report-type

Ifl   'BS'

Thenl 'Balance Sheet'

Else    'Profit and Loss'