Answer / 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

Answer / 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;

Answer / 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;

What are pl/sql cursors?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

What is cascade in sql?

0 Answers  

---

What is the difference between DELETE, TRUNCATE, and DROP?

3 Answers  

---

What is trigger in sql?

0 Answers  

---

How many types of primary keys are there?

0 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

---

How to remove duplicate rows from a table?.

3 Answers  

---

What is left join example?

0 Answers  

---

What are the different parts of a package?

0 Answers  

---