K Kazis Member Oct 25, 2015 #1 Hello, Can you help me? Which script should I write in my query that query results in PL/SQL Developer be fetched to show all rows automatically (without clicking on "fetch" button)?
Hello, Can you help me? Which script should I write in my query that query results in PL/SQL Developer be fetched to show all rows automatically (without clicking on "fetch" button)?
patch Member³ Oct 25, 2015 #1 Check your settings: Preferences - SQL Window - Records per Page Here you can choose to fetch all records.
Check your settings: Preferences - SQL Window - Records per Page Here you can choose to fetch all records.
C cct Member² Oct 27, 2015 #1 Alternately you can use the Records directive - see 7.10 Comment directives in the on-line help - specifically put before the query the line: -- Records=ALL Chris
Alternately you can use the Records directive - see 7.10 Comment directives in the on-line help - specifically put before the query the line: -- Records=ALL Chris