Answer / abc

Select * from user_sys_privs;

What is RULE-based approach to optimization ?

1 Answers  

---

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

2 Answers  

---

What is an oracle data file?

0 Answers  

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

---

How to connect to the server with user account: sys?

0 Answers  

---

How to see the table columns used in an index?

0 Answers  

---

How do you find current date and time in oracle?

0 Answers  

---

What are various joins used while writing SUBQUERIES?

2 Answers  

---

Explain table?

0 Answers  

---

What does COMMIT do ?

4 Answers  

---

How to check database size in Oracle?

0 Answers   MCN Solutions,

---