Answer / phan wai keong

select * from dba_users;

Answer / pradeep

select * from all_users;

What is the order of defining local variables and sub procedures/functions?

0 Answers  

---

How to create a table index in oracle?

0 Answers  

---

How do you find current date and time in oracle?

0 Answers  

---

What is a trigger and what are its types?

0 Answers  

---

What is Water Mark in Oracle?

7 Answers   Oracle,

---

is there a tool to trace queries, like profiler for sql server?

0 Answers  

---

What is user managed backup in Oracle?

0 Answers   MCN Solutions,

---

Explain integrity constraint?

0 Answers  

---

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

---

How to view existing locks on the database?

0 Answers  

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

0 Answers  

---

What are triggers?Where are they used?

3 Answers  

---