NEWBIE: Getting the number of rows from a select

#1

How is this done in Oracle? Do I have to fetch all records and get the
count from that or is there a better way?

#2

"Lorenzo Thurman" <lorenzo (AT) diespammerhethurmans (DOT) com> wrote

Quote:

How is this done in Oracle? Do I have to fetch all records and get the
count from that or is there a better way?
Yes, fetch the records.

Jim

#3

Quote:

How is this done in Oracle? Do I have to fetch all records and get the
count from that or is there a better way?

?

select count(*) from... ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.database.oracle comp.database.oracle