Home » RDBMS Server » Server Administration » Count of the records of a table!!!!
Count of the records of a table!!!! [message #374883] Mon, 09 July 2001 23:31 Go to next message
Anupam
Messages: 62
Registered: July 2001
Member
Is there a faster way of getting the total number of records in a table other than count(*) / count(1) ????
Please reply ASAP!!!!

Report message to a moderator

Re: Count of the records of a table!!!! [message #374895 is a reply to message #374883] Tue, 10 July 2001 07:44 Go to previous message
Stephen
Messages: 26
Registered: January 2000
Junior Member
Because the count-statement is not save for 100% you can also ask for the error-parameters, even when no error has occured.

fi:
SELECT column1, column2
FROM table1

We ask then for sqlerd(3). In this variable the number of records read is stored.

-> NumberOfRecords = sqlerd(3)

Remark: We work on a OpenVms-platform with Fortran-programs and I think this is a feature of Fortran (I'm not sure)

Report message to a moderator

Previous Topic: Re: SQL*PLUS default path
Next Topic: Help please! DELETE FROM
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 20:23:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.