it results out the count of record in the table result

What does “select count(1) from tab” result?

Question Posted / guest

Answer Posted / guest

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between truncate and drop statements?

1201

Can you inner join the same table?

1000

Mention what are different methods to trace the pl/sql code?

1223

What are the various restrictions imposed on view in terms of dml?

973

What is difference between table and view?

1074

Is vs as in pl sql?

996

What is data modelling in sql?

1031

What is field delimiter?

1056

Can we use two order by clause in query?

978

How run sql*plus commands that are stored in a local file?

1071

What is view? Can we update view

1453

What is pls integer?

1054

What are the different type of joins in sql?

961

What is function and procedure in pl sql?

1058

Explain the steps needed to create the scheduled job?

1048