write a pl/sql function if enter a value=0 then output
value=1 and vise verse with out using if and case statements.
- 3 Answers
- 7348 Views
- Zensar, I also Faced
- E-Mail Answers
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
What is the difference between delete and truncate statement in sql?
Difference between truncate, delete and drop commands?
What are the types of variable use in pl sql?
What are sql injection vulnerabilities?
What information is needed to connect sql*plus an oracle server?
Can you have more than one trigger on a table?
What is the maximum rows in csv?
what is the difference between a web-garden and a web-farm? : Sql dba
Is it important to partition hard disk?
Is there a 64 bit version of ssms?
What are two statement types in sql?
What is microsoft t sql?
What are the advantages of normalization?
Can we commit in trigger?
Does sqlite need a server?
