Hi all this will work for that one with out using if and case statement.

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 / rajesh venati

3 Answers
8139 Views
Zensar, I also Faced
E-Mail Answers

Answer Posted / rajesh venati

Hi all this will work for that one with out using if and
case statement.

create or replace function fun(a in number) return number
is
n number;
begin
n:=mod(1,a);
return n;
end;

SQL> select fun(1) from dual;

FUN(1)
----------
0

SQL> select fun(0) from dual;

FUN(0)
----------
1

Is This Answer Correct ?

18 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is full outer join same as cross join?

969

Is sql a scripting language?

1011

What is difference between left and right outer join?

987

Can we rollback truncate?

998

how can we repair a mysql table? : Sql dba

979

What version is sql?

1032

How many developers work on postgresql?

980

What does trigger mean in slang?

1055

Is sql microsoft?

1055

What is cartesian join in sql?

1128

Where the sql database files are stored?

1014

what are integrity rules?

1026

Describe types of sql statements?

1057

What is consistency?

1122

What is the use of & in pl sql?

1046