Answer Posted / rishi anand

Stroed procedures are basically set of sql statements.User
defined stored procedures are created by users in which
they can use functions,procedures to get the desired result
from database.

What is a recursive join sql?

1114

---

How to read/write files from pl/sql?

1085

---

how to present a past time in hours, minutes and seconds? : Sql dba

1071

---

What is the purpose of a secondary key?

1017

---

What is scalar and vector?

1060

---

what is 'mysqlimport'? : Sql dba

1111

---

what is sql profiler? : Sql dba

1115

---

How do I copy a table in sql?

1037

---

What is dense_rank?

989

---

Explain the insert into statements in sql?

1053

---

How many commands are there in sql?

1086

---

What problem one might face while writing log information to a data-base table in pl/sql?

1250

---

How does join work in sql?

1052

---

What is difference between group by and partition by?

1128

---

What are the sql versions?

999

---