I am from a Teradata background and I am switching into the realm of Oracle.
Teradata has a concept of database ROLES which are sometime used in View definitions as follows :-
create view V_Cutomer
case when role = 'CRO' then cust_first_name else NULL end as cust_first_name
I am trying to find out if a similar way exists in Oracle. Please let me know how we can translate the above TD View definition to Oracle (11g).