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 answers

0
Eugene Kuleshov 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