Answer Posted / anil kumar jampana

sorry, we can use in,inout,out parameters in functions also.
one more diff. we can use functions in normal sql queries
but we cann't use procedures in sql queries....

What is the difference between inner join and natural join?

1006

---

What are the two parts of design view?

1020

---

What is orm in sql?

1050

---

Can function return multiple values in sql?

1060

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2448

---

What is the difference between Union and Union all. Which is faster.

1403

---

What are the datatypes available in pl/sql ?

1104

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

984

---

What are inner and outer joins examples of both?

963

---

What is sql query limit?

980

---

What pl/sql package consists of?

1082

---

What is the difference between cluster and non-cluster index?

1108

---

What is an index in sql with example?

974

---

What do you mean by stored procedures? How do we use it?

996

---

Which sql statement is used to return only different values?

1004

---