SQL Magic Trick: Getting Row Count Without Fetching All Rows

(Jeff Smith) So while hanging out with a bunch of co-workers last week, someone mentioned they had this trick. The challenge is knowing how many rows you have in your result set before you actually read them all. You see, Oracle has no way of telling us how many records are in our data set before we

Read More - Register for Free Membership