without using count(*) and rownum how can we count total
record in a table

Answer Posted / sanrai

Select max(rownum) From dual

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is oracle database so popular?

566


How to create a table index?

570


What is a dynamic performance view in oracle?

609


Explain mutating triggers.

577


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1751






How to connect asp pages to oracle servers?

579


What is blob datatype?

571


Whether any commands are used for months calculation? If so, what are they?

598


How to use windows user to connect to the server?

536


What is SQL access advisor in Oracle?

634


Can multiple cursors being opened at the same time?

618


master table and child table performances and comparisons in Oracle ?

1668


What is the sql query to concatenate column values from multiple rows in oracle?

567


How to display employee records who gets more salary than the average salary in the department?

601


How do we represent comments in oracle?

631