no need.. select count(*) from the emp. it will give the total no of rows

Do we need cursor for Count(*)?

Question Posted / shravan kumar.p

4 Answers
8847 Views
iGate, I also Faced
E-Mail Answers

Answer Posted / shravan kumar.p

no need..
select count(*) from the emp.
it will give the total no of rows in a table..

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What's The Error Code For Unique Index Voilation?

1150

What is rct?

1161

What is schema in db2?

959

What is explain plan in db2?

940

What is cloudant database?

1025

What is the function of logging in the db2 database?

1066

What is check constraint. Explain with example.

1041

What is runstats utility in db2?

961

Explain about rct.

1024

How do I optimize a query in db2?

1035

Explain correlated sub-queries.

972

How do I delete a column in db2?

1048

Mention some fields that are a part of sqlca.

969

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2664

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102