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 is the difference between anonymous block and named blocks?

3 Answers  

---

what is a constraint? : Sql dba

0 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

What is normalization? How many normalization forms are there?

0 Answers  

---

what is the difference between where clause and having clause? : Sql dba

0 Answers  

---

How to run sql statements with oracle sql developer?

0 Answers  

---

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

---

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?

2 Answers  

---

What is trigger price?

0 Answers  

---

What is mutating table error?

0 Answers  

---