Hi,
Is is possible to use any divide function in oracle somthing like this
select case when id = 'N' then col_1/col_2 as derived from T1;
instead of using col_1/col_2 is there a way to use any divide function
or to be precise i need to use when id = 'N' i need to apply the divide logic because there are multiple columns where i need to divide from same Table T1
select case when id = 'N' then col_1/col_2 as derived, case when id = 'N' then col_2/col_2 as derived,case when id = 'N' then col_3/col_2 as derived,from T1;