Answer Posted / nitinsharma06

select * from tabe_name partition (partition_name );

What is the order of sql select?

1039

---

What is the use of non clustered index?

985

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1059

---

What is sp_helptext?

1057

---

How can triggers be used for the table auditing?

1065

---

What is difference between inner join and cross join?

961

---

Why do we need view in sql?

977

---

How do you use a while loop in pl sql?

1002

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

994

---

what is the different between now() and current_date()? : Sql dba

1008

---

What is primary key in db?

1001

---

How do I copy a table in sql?

975

---

Why is theta join required?

1138

---

Enlist the characteristics of pl/sql?

1791

---

Can we use delete in merge statement?

1033

---