Answer / phan wai keong

select * from dba_users;

Answer / pradeep

select * from all_users;

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

9 Answers   BPO, Excel, Wipro,

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

---

What is a system tablespace and when it is created?

0 Answers  

---

how to get the second max val for every group in a table

6 Answers   Verizon,

---

Can you assign multiple query result rows to a variable?

0 Answers  

---

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---

What is a cursor variable?

0 Answers  

---

Why we use bulk collect in oracle?

0 Answers  

---

How to work with data objects interactively?

0 Answers  

---

when do u go for hash partitioning?

1 Answers  

---