• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2527
  • Last Modified:

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
0
josephsonnd
Asked:
josephsonnd
  • 5
  • 2
2 Solutions
 
GGuzdziolCommented:
navigate to the last row (ctrl + end)...but this will take a lot of time & resources for big tables...
0
 
Stephen LappinSenior TechnologistCommented:
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
0
 
Stephen LappinSenior TechnologistCommented:
It's the 'book' icon, left of the column headings - and you should right-click to get the context-sensitive popup menu
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Stephen LappinSenior TechnologistCommented:
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
0
 
josephsonndAuthor Commented:
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
0
 
Stephen LappinSenior TechnologistCommented:
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.
0
 
josephsonndAuthor Commented:
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
0
 
Stephen LappinSenior TechnologistCommented:
No - I mean TOAD version.
You are on quite an old version - 8.6 has been around for a while
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now