Search code examples
eclipseoracle-databaseeclipse-dtp

Eclipse Data Tools Platform (DTP) Select * limit

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

Solution

  • 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