Answer / gourvendra singh

select count(1) from tab will give the total number of
tables,views and synonms present in the current schema.

Answer / vishnu

SELECT COUNT(1) FROM TAB

ANS:It gives the total number of tables,views,synonyms
present in that schema.

Answer / prerna

If tab is table name then it gives total no of rows present
in that table.

Answer / sunil

Tab is system view which will provide you the list of
table,view,cluster,synonym in the current schema .

Answer / guest

it results out the count of record in the table result

Answer / 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;

Answer / phani

It returns the count of all tables for that user.

Answer / indrajeet kumar

SELECT COUNT(1) FROM TAB

RESULT IS 91

Answer / ali

A column function does not use any column name.

Answer / mahi

It will give the latest row of the table.

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

Enlist the advantages of sql.

0 Answers  

what does it mean to have quoted_identifier on? : Sql dba

0 Answers  

What is sql mysql pl sql oracle?

0 Answers  

what is the sql query to display current date? : Sql dba

1 Answers  

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

how to do backup entire database? : Transact sql

0 Answers  

What is a cursor for loop ?

4 Answers  

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

what is 'mysqlshow'? : Sql dba

0 Answers  

What is function and procedure in pl sql?

0 Answers