Solved

new to Toad (TDA) - quest 2:  Can a query be created to list all of the TDA queries?

Posted on 2011-03-15
7
511 Views
Last Modified: 2012-05-11
Hi EE,

In Oracle Discoverer, my dba gave me access to an Oracle Discoverer Table, so that i can write a Discoverer query
that lists all the Discovere queries.

Can this be done in Toad/TDA?

pls advise, tx, sandra
0
Comment
Question by:mytfein
  • 4
  • 3
7 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 35138802
Toad queries are stored within toad configuration files, so the database won't know what they are.

But, if you have auditting turned on in Oracle you can check audit logs
or if your query was run recently it might still be in v$sql / v$sqlarea but it won't be identified as a "TDA" query
0
 

Author Comment

by:mytfein
ID: 35139165
Hi sds,

Are you familiar with Microsoft Access, and that is has pretty impressive coding capability using VBA which is a dialect of VB?

Anyway, i'm from a previous era of procedural programming, and have not (yet) gotten  into web based apps using oop.

So, i combined Access and Discoverer to create my own "product" . Below is a screen shot.
When user clicks icon on desktop, he gets this menu. This menu is created by running a .bat file
that executes a Discoverer file that dumps all the queries from the query table. Thus, i can create
a more user friendly menu. I allow the user to search queries by any word that appears in the keyword. Am even thinking of giving them a tag screen, where user can assign tags that can be
field names,  office processes, to allow user to search by tag.

Truthfully, Discover is VERY difficult to work with, and would love to try TOAD. If Toad can be run
via .bat (as you recently explained to me)  and if i could write a TOAD query that dumps all the queries,
then i could just replace all references in my .bat files from Discoverer to Access, and still keep my
Access system intact for  the user.

tx, s
2011-03-15-menu.GIF
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 35139213
I don't think I would use Toad for something like this.
It's probably possible, but I'm not convinced it's the right tool for the job.

Is your data in Access or Oracle?

If Oracle, you might want to look at using APEX.
It will take some of the work out of building a web app.

Based on your screen shot it looks like it's a menu of reports and APEX can definitely be used to do that.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:mytfein
ID: 35139298
Hi sds,

Data is in Oracle.

tried googling APEX, do you have a web link that i can read about this product?

btw, doesn't Toad allow the user to view the queries, as a menu, as well?
i'm guessing, if it does, it might not allow user to search the menu by keyword or by tag...

pls advise, tx, s
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 35139452
http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html


Nice thing about APEX is it's free (no cost) if you have an oracle license


Sorry, I'm much more familiar with Toad for Oracle than Toad for Data Analysts  there might be some menuing in TDA but I don't know what the searching capabilities are on it.
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 35139508
you might want to check out toadworld

Debbie Peabody is a Quest employee that blogs about TDA
0
 

Author Comment

by:mytfein
ID: 35139599
Hi sds,

tx soooo much,

very interesting.... will look into it....

tx again, s
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle query help 29 77
Oracle Pivot 2 44
PLSQL procedure help with decode and null input params 5 47
'G_F01' is not a procedure or is undefined 3 13
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now