1

I have a DB in Oracle11g and i use Eclipse with Eclipse Data Tools Platform (DTP). I try to select all rows in one table with this

select * from <table_name>;

but it only return 500 rows. There's any way to pass this limitation? Thanks

MarcoM
  • 92
  • 1
  • 10

1 Answers1

3

Number of fetched rows can be configured from the following places in Eclipse DTP:

  • View menu (Ctrl-F10) / Preferences... / Max row count
  • Window / Preferences / Data Management / SQL Development / SQL Results View / Max row count
Eugene Kuleshov
  • 31,461
  • 5
  • 66
  • 67