Toad World® Forums

session info "access" tab


#1

In trying to figure out what tables are being used by an Oracle Report when it
is running I found the “access tab” in the session browser. It would
be great if it would let me highlight-copy-paste the three columns of info from
the session browser since getting it from the multiple SQLs in the OraRpt itself
is a pita.

Any suggestions where to grab the info easily from in Toad while the OraRpt is
running?

Deborah M Flad, DBA
Delaware Children’s Department, State of Delaware
1825 Faulkland Rd, Wilmington DE 19805
Office: 302.633.2694 deborah.flad@state.de.us Emergencies: 302.528.3652 Txt:
www.vtext.com
Our website: www.kids.delaware.gov
How am I doing? Email my manager Eugene Mitchell at Eugene.Mitchell@state.de.us
with any feedback.
“Please consider your environmental responsibility before printing this e-mail”


Confidentiality Notice – This electronic mail transmission and any
attachment(s) are privileged and confidential and are intended only for the
review of the party to whom it is addressed. If you have received this
transmission in error, please immediately notify the sender and delete the
unintended message received. Unintended transmission shall not constitute waiver
of work product or any other privilege.

Picture (Device Independent Bitmap) 1.jpeg


#2

You can right-click in that Access grid and export the data out, have you tried
that?
Picture (Device Independent Bitmap) 1.jpeg


#3

Running Toad 9.7.2.5. Rt-click in access tab’s grid doesn’t offer
anything(its blank). Also found I can only highlight a cell at a time and while
rt-click offers nothing I can do Ctrl-C and copy the cell.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
Picture (Device Independent Bitmap) 1.jpeg


#4

Running Toad 9.7.2.5. Rt-click in access tab’s grid doesn’t offer
anything(its blank). Also found I can only highlight a cell at a time and while
rt-click offers nothing I can do Ctrl-C and copy the cell.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
image002.png


#5

In 9.7:

Click the grid you want to export. On the main menu, click “Grid”,
then “Save As”
Picture (Device Independent Bitmap) 1.jpeg


#6

In 9.7:

Click the grid you want to export. On the main menu, click “Grid”,
then “Save As”
image002.png


#7

That works great! Thanks.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
Picture (Device Independent Bitmap) 1.jpeg


#8

That works great! Thanks.

Deborah M Flad, DBA
Office: 302.633.2694 Emergencies: 302.528.3652
“Please consider your environmental responsibility before printing this e-mail”
image002.png