Forum Stats

  • 3,752,166 Users
  • 2,250,466 Discussions
  • 7,867,742 Comments

Discussions

View data

User_HWQS8
User_HWQS8 Member Posts: 1 Green Ribbon

How can I view 1 million record generated upon execution of an SQL query?


Thanks,

Anitha

Tagged:

Answers

  • User_H3J7U
    User_H3J7U Member Posts: 415 Bronze Trophy

    To view million records for one second each, you need million seconds or 11+ full days.

    Billy VerreynneBEDE
  • BEDE
    BEDE Oracle Developer Member Posts: 2,276 Gold Trophy

    I think you should be filtering data so that you get at most a few thousand rows to check visually.

    Otherwise, you may spool the results to a text file and see what editor can open that...

  • Billy Verreynne
    Billy Verreynne Software Engineer Member Posts: 28,570 Red Diamond

    How can I view 1 million record generated upon execution of an SQL query?

    You don't. The human brain is awesome at recognising patterns. But even a 100 rows data grid is visually not presented in a format well enough for effective processing by the brain. Never mind a million rows.

    What are you going to do after viewing a million rows? What information are you going to obtain by that? What decisions are you going to make base on that?

    BEDEAbdulkareem Al-Badani