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 are two statement types in sql?

1031

---

what is column? : Sql dba

960

---

What is sql and also describe types of sql statements?

994

---

What are the uses of merge?

1119

---

what is blob? : Sql dba

1055

---

What is nvarchar max in sql?

959

---

What is exit statement?

957

---

What are the dml statements?

1095

---

What is record in pl sql?

1009

---

Can we create foreign key without primary key?

931

---

what is a database lock ? : Sql dba

1092

---

what is the difference between join and union? : Sql dba

1027

---

Can we insert data in view?

888

---

How to change the order of columns in Oracle SQL Plus ?

993

---

How many joins can you have in sql?

880

---