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 use of triggers?

0 Answers  

Why stored procedure is better than query?

0 Answers  

Explian rowid, rownum?

0 Answers  

How many sql databases can you have on one server?

0 Answers  

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

What are pl/sql exceptions? Tell me any three.

1 Answers  

How to return multiple rows from the stored procedure?

0 Answers  

What are the different ddl commands in sql?

0 Answers  

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

How to write html code in pl sql?

0 Answers  

What is mutating table?

11 Answers   Saama Tech,