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
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
Number of fetched rows can be configured from the following places in Eclipse DTP: