asked on

TOAD schema browser, number of rows in the table

In TOAD with oracle database,

1. choose the schema browser
2. choose the table
3. choose data tab on the right pane
4. scroll down the data shows data in the table

Is there a way to tell total number of rows in the table without going to SQL editor and run a query

SOLUTION

GGuzdziol

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Stephen Lappin

Yes,

Click on the box in the top-left of the data grid and a pop-up menu will appear. Select Record count... and it will count the noi of rows that would be rturned

ASKER CERTIFIED SOLUTION

Stephen Lappin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Stephen Lappin

Of course, if it is the total number of rows in the table (i.e. no filter applied), then you could analyse the table (compute stats) then look at the NUM-ROWS value in the Stats/Size tab

josephsonnd

ASKER

lappins,

Thanks. Right. I wanted to know the number of rows returned

As for the "analyze table ....",
I can do this on the SQL Editor also

Does TOAD generate any scripts to look at (simlar to DDL for create table) especially for DBMS_STATS

Stephen Lappin

If you trun on SQL Monitor, you can see all the SQL that TOAD is issuing!

In v9.0, it is on the Database, Monitor menu. The menus were rearrange in v9, so it may be somwehere else in v8 etc.

josephsonnd

ASKER

lappins,

My TOAD version is 7.6.0.11. I suppose you meant oracle version, my oracle version v9.2

It seems like it that the SQL Monitor may be a special add on

Stephen Lappin

No - I mean TOAD version.
You are on quite an old version - 8.6 has been around for a while