You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

How you open and close a cursor variable.Why it is required?

2 Answers  

---

what is main def between plsql/table and array?

1 Answers   Oracle,

---

Describe an oracle table?

0 Answers  

---

How many categories of data types in oracle?

0 Answers  

---

---

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

---

How to use subqueries in the from clause in oracle?

0 Answers  

---

What is integrity and what is constraint??Explain with example

0 Answers   Google,

---

What different of iner joint & outer joint with example

4 Answers  

---

How to define a procedure inside another procedure?

0 Answers  

---

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers  

---

What is a parameter file in oracle?

0 Answers  

---