Answer Posted / rutujagabhane

select* from tab; gives you the o/p as a table containing rows and columns. The rows contain the name of table ,select count(1) from tab returns the no or rows in tab .
Indirectly the statement returns no of tables in tab;

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2501

---

What is t sql in sql server?

1084

---

Is delete faster than truncate?

1014

---

How do I debug a stored procedure?

1124

---

Differentiate pl/sql and sql?

1071

---

What is having clause in sql?

977

---

What is sqlca in powerbuilder?

1030

---

How many rows can sqlite handle?

1130

---

What is the difference between the conventional and direct path loader? : aql loader

1157

---

How to read/write files from pl/sql?

1050

---

What is trigger explain it?

1022

---

How many indexes can be created on a table in sql?

1066

---

Explain locks? : Transact sql

1014

---

How do I add a primary key to a table?

1049

---

What are the query optimization techniques?

943

---