, case when x.trns_type = 'Basic' then round(base_salary * (cast(x.percentage as decimal)/100),2) when x.trns_type = 'Allowance' then round(base_salary * (cast(x ...
The SQL Report Template is a lightweight framework for executing SQL queries against an Oracle database and generating an Excel report with the results. Users can define SQL queries in separate .sql ...