fetching all rows at once

Kazis

Member
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)?
 
Check your settings:
Preferences - SQL Window - Records per Page
Here you can choose to fetch all records.
 
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
 
Back
Top