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 pl sql block structure?

1034

---

How do I install sql?

987

---

describe mysql connection using mysql binary. : Sql dba

1062

---

Is sql a microsoft product?

944

---

Is drop table faster than truncate?

985

---

What is a heap in sql?

1065

---

What are all the common sql functions?

1012

---

how to calculate expressions with sql statements? : Sql dba

1032

---

What is primary key and foreign key?

958

---

What are types of indexes in sql?

1076

---

What is full join in sql?

987

---

What is a system versioned table?

978

---

Can we use views in stored procedure?

1029

---

what is timestamp in mysql? : Sql dba

1071

---

What are the sql versions?

939

---