create or replace function myfun(a in number) return number is n number;

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 / sachin sapkal

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

Answer Posted / sachin sapkal

create or replace function myfun(a in number) return number
is
n number;
begin
if (n = 1)
return 0;
else if(n = 0)
return 1;
else
dbms_output.put_line('enter 0 or 1 only...');
end if;
end;

SQL> select myfun(1) from dual;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is faster view or stored procedure?

946

When can we use the where clause and the having clause?

1020

Why self join is used in sql?

977

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

What is the difference between unique and primary key constraints?

1071

How does a covering index work?

961

what is the difference between delete and truncate commands? : Sql dba

1070

Why is sql better than hql?

993

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1024

Is sqlite free?

975

Explain the purpose of %type and %rowtype data types with the example?

995

What is procedure and function in sql?

1001

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1047

What is hibernate and its relation to sql?

1124

What is the command used to fetch the first 5 characters of a string?

1209