Interested to Buy Any Domain ? << Click Here >> for more details...
How to count the no of records of a table without using
COUNT function?
- 11 Answers
- 29179 Views
- TCS, Tesco, I also Faced
- E-Mail Answers
Answer Posted / kart
using select command
select * from xxx; we will get the no of rows at bottom
if the feedback is unset
then use the plsql with cursor;
select rownum from table; the last value
is the number of records
| Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
Why does sql need a server?
how do you control the max size of a heap table? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How do you break a loop in pl sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is primary and foreign key?
How do you remove duplicate records from a table?
What is the starting oracle error number? What is meant by forward declaration in functions?
What is scope and visibility in PL/SQL?
What is cursor in pl sql with examples?
How to avoid using cursors?
What are all the different normalizations?
How to take user input in pl sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
