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 and as keyword in pl sql?

1012

---

What is a temporal data type?

1114

---

Which table is left in left join?

1062

---

Does inner join return duplicate rows?

1039

---

Is nosql relational?

999

---

what is bcp? When is it used?

1182

---

Explain select statements in sql?

1107

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1134

---

What does a pl/sql package consist of?

1015

---

How much ram can sql express use?

1041

---

How do I create a sql database?

1055

---

What does where 1 1 mean in sql?

1077

---

Difference between truncate, delete and drop commands?

1145

---

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

1398

---

Name some usages of database trigger?

1084

---