how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

How to convert csv to table in oracle?

0 Answers  

---

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

2 Answers   BOB Technologies, Cap Gemini, IBM,

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

What is the usage of save points in oracle database?

0 Answers  

---

How to delete a column in an existing table?

0 Answers  

---

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,

---

What are the parameters that we can pass through a stored procedure?

0 Answers  

---

How many types of segments in Oracle?

0 Answers   MCN Solutions,

---

Explain implicit cursor.

0 Answers  

---

How to define a specific record type?

0 Answers  

---