write a pl/sql function if enter a value=0 then output
value=1 and vise verse with out using if and case statements.
Answer Posted / ajitnayak
create or replace function vice_versa2 (inp_no number) return number
is
a number := 0;
begin
select decode(inp_no, 1, 0,1) into a from dual;
return a;
end;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is progress software supports to ( pl/sql )?
What is full join?
Enlist the characteristics of pl/sql?
what is view? : Sql dba
How do I view an execution plan in sql?
What are primary key and foreign key and how they work?
Is it possible for a table to have more than one foreign key?
how to increment dates by 1 in mysql? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
How do we use distinct statement? What is its use?
How do I turn a list into a table?
what are local and global variables and their differences? : Sql dba
What are the qualities of 2nf?
What is pl sql block structure?