PL-SQL question, how to re-assign a value according to existing values
-
Hi Friends, I have to create a view using a few tables. One table has a column having four values (A,B,C,D), I want the view have a column only have two values (say for A,B,C I want the value to be "INTERNAL", and for D the value is "EXTERNAL") How can I solve this problem? Do I have to use a procedure? can anyone post a sample for me? Many thanks... ^_^
-
Hi Friends, I have to create a view using a few tables. One table has a column having four values (A,B,C,D), I want the view have a column only have two values (say for A,B,C I want the value to be "INTERNAL", and for D the value is "EXTERNAL") How can I solve this problem? Do I have to use a procedure? can anyone post a sample for me? Many thanks... ^_^
I would assume Oracle has a case statement, something like the following works in SQL Server.
case where colA = 'D' then 'External' else 'internal' end
Never underestimate the power of human stupidity RAH
-
I would assume Oracle has a case statement, something like the following works in SQL Server.
case where colA = 'D' then 'External' else 'internal' end
Never underestimate the power of human stupidity RAH