Toad World® Forums

Restrict records


#1

Hi, I didint find in settings how can I restrict the number of records in results( for example i want only 100 rows to show me).
And the second question-what is the differences between run SQL and run script?

Thanks


#2

The option is under Database general. Enter the number of rows to limit and then select “Apply to editor”. See screenshot.

Run SQL, runs only the SQL statement closest to your cursor. Run script runs all SQL in the editor.

Debbie
LimitRows.png


#3

THANXS!)