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

what is the difference difference between procedure and packages

10528

---

What is error ora-01000: maximum open cursors exceeded

1204

---

How many joins in sql?

1053

---

Is coalesce faster than isnull?

1011

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1888

---

what are integrity rules?

1083

---

How to check if a column is nullable before setting to nullable?

1173

---

Explain foreign key in sql?

1077

---

Is sql sequential or random?

1081

---

What is function and procedure?

1072

---

can sql servers linked to other servers like oracle? : Sql dba

1046

---

how to shut down the server with 'mysqladmin'? : Sql dba

1046

---

what is the bond code in materialized view?

3051

---

What does count (*) mean?

981

---

Is left join and outer join same?

1111

---