Eclipse Data Tools Platform (DTP) Select * limit

1.3k Views Asked by At

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

1

There are 1 best solutions below

0
On BEST ANSWER

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