When running a Query with an Oracle tool like PL SQL does it automatically search an entire table or just the first ten records to sample. If not how do you force the entire set of rows for each table

Trying to figure out if I can search the entire list of tables here that would allow me to find a record in this database.
Same dilemma same database for those that know me. Spent many many hours trying to find where these records are.
For an example. I have searched the 905 tables below for 15 different records. Only found one...?
My question is when a query is run I noticed that PL SQL only shows a few records like maybe ten rows.
Then it allows you to push the double green arrow seen here to in fact run the entire set of rows for the table.

When you run a small query it shows a few rows....then you can click the green double arrow to see all rows..?
I am curious, if the first" run of ten rows" is all the current query is seeing in actual records...could this explain why I am not seeing many results? See lower code set.
Could that be because the query is only showing the first 10 rows of each table and not seeing the record. If so how do I get the records to look at "Search" the full range of rows in my query. Is that the Bind Variables.

If the code below can be modified to do so then I am open to suggestions. If it is not, I either have to ask another question which I can open or maybe I can include it here. Hard to break these up when you are trying to learn realizing I know so little.  My attempt to get the code to work was the removal of a specific name of a table.
"/*and table_name like 'JOB%'*/   and my thought was that the remaining line of................ "from All_tab_cols     where owner ='JAS' ....... would help me do that? My theory did not work. Still looking myself it is just taking forever when you do not know the terms or understand the structure and function yet. Never giving up or quitting though.

Select * From JAS.ACCOUNTS  ;
Select * From JAS.ADDRESSES ;
/* and 901 other tables in between the line above and line below*/
Select * From JAS.XLSX_TEXT ;

select table_name,column_name from (
  select table_name,
        'select count(*) X from ' || table_name || ' where to_char(' || column_name || ') = ''6328'' and rownum=1'
    ) count
  from All_tab_cols
  where owner ='JAS' 
  /*and table_name like 'JOB%'*/
  order by table_name, column_name
where count=1

Open in new window

RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

under your preferences you can set "Records per Page"  

you can find the option under Window Types - SQL Window

also note the Maximum result set size - this is helpful if you have limited memory, but usually I recommend setting it to 0 (unlimited) and using the Records limit instead if you need a limit

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark GeerlingsDatabase AdministratorCommented:
I see a couple contradictions in your question, apparently because you are new to Oracle.  

First, you said : "When running a Query with an Oracle tool like PL SQL...":.  This is not accurate.  I think you mean: "When running a Query in Oracle...".  Queries in Oracle are SQL, not PL\SQL.  PL\SQL is Oracle's proprietary set of additions to SQL that are used to create stored procedures in Oracle.  Microsoft has a comparable set of additions for SQL Server called T-SQL for creating stored procedures in SQL Server databases.

Second, you included a screen shot from some kind of GUI tool.  That is certainly not PL\SQL, since PL\SQL is not GUI.  Can you tell us which tool or program that actually is?

Oracle SQL queries always query any/all records that meet the criteria that is provided in the "where" clause of the query.  This can be the entire table, or just a portion, depending on which details are provided in the "where" clause.  Oracle SQL by default does *NOT* limit the number of rows that are returned.  Some GUI tools (SQL Developer, TOAD, etc.) provide the ability to execute SQL queries and they can include the ability to limit the number of rows returned.  That will depend on the particular tool you are using and on what settings it may have by default, or what settings you may have changed.
The program is "PL/SQL Developer"  it's a common, but unfortunate abbreviation to be called "pl/sql"

The tool itself does do paged fetching, and I've provided the instructions on how to change it in my first response.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Good thank you for this information. Do you have any thoughts on maybe what might be a good setting at first to see if the records return a result. I thought about setting it to say 200 rows as another member reminding me that running all those tables over and over which I will do lightly today. I will run more briskly tonight when no one is entering or looking at data? You think setting it to 200 rows would be a good test sampling to try or another number if there are thousands of rows?
There is no "right" or "best" answer to that for everyone.

I have mine set to 500.
It works for me for most queries, on occasion I change it to something larger but not often.

If 200 is working for you, there's nothing wrong with it.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Thanks that did it. Very helpful
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.