create or replace function vice_versa2 (inp_no number) return number is a

write a pl/sql function if enter a value=0 then output
value=1 and vise verse with out using if and case statements.

Question Posted / ajitnayak

3 Answers
8140 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

Please Help Members By Posting Answers For Below Questions

What is a memo field?

969

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7348

Is pl sql a programming language?

991

Can a primary key be a foreign key?

1022

How to assign sql query results to pl sql variables?

1079

how mysql optimizes distinct? : Sql dba

1079

What is trigger explain with example?

1039

Is pl sql and postgresql same?

1132

How to Execute a Package in PL/SQL.?

1203

What does pl sql developer do?

925

What are the different types of dbms?

1016

What is a database event trigger?

1159

Is oracle sql free?

987

What do you understand by case manipulation functions?

1034

Explain the methods used to protect source code of pl/sql.

1019