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

/ Home / Computer & Internet / Oracle SQL, PLSQL, APEX How To's

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

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'