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;

Define implicit and explicit cursors.

0 Answers  

---

Why do we use procedures in sql?

0 Answers  

---

What is a primary key example?

0 Answers  

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

What is autocommit sql?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

What is the primary use of normalization?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

---

What are the three forms of normalization?

0 Answers  

---

What is the difference between left outer join and left join?

0 Answers  

---

Explain the significance of the & and && operators in pl sql.

0 Answers  

---