From yesterday. From: Mark Lerch Sent: Thursday, November 19, 2009 12:56 PM To: 'toad@yahoogroups.com' Subject: RE: [toad] SQL Monitor Rewrite - My Thanks! ...
Roger, if this in one-time, it's probably not be worth getting fancy. But here are a couple of fancier approaches. But what about loading it into Oracle as a...
I've gone from XML to Relational Views of the XML... you have to really understand XML to do it tho... You'll begin to understand when you deal with the:...
You can use XML transformations (XSLT) to do this as well. From what I understand there's a learning curve there and we no longer have anyone on the team...
I'm wondering if anyone has run into this issue. I have a query that appears to be the problem in an Oracle Report that is kicked of via a procedure called by...
I was reading the Toad blogs and I came across the Script Manager. This is new to me, so I started exploring. I got script manager started, but the 'add...
Hi Ian - you probably don't have an active datafile. Click the 'new datafile' button at the top ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]...
I resemble that remark about "geeky enough" to assist with XML :-) Is this is a one time thing I would just echo what has already been written. Otherwise, the...
that worked .. thanks Mark. What is the common use for this? - dba's to run monitor / stats scripts against multiple db's? - applying db object updates across...
Hi Ian, yeah, It started out as a way to create a collection of scripts and run them all at once. Then it matured into being able to run a script on multiple...
1) Any recent change (init.ora parameter, new/droped/altered index, table structure, partition or DATABASE UPGRADE or PATCH etc)? 2) Run AWR report for that...
Good Morning; After spending a couple hours going through all the tools on my desktop that can "read and display" XML files, I decided to write the parser ...
Simoneau, Roger
rsimonea@...
Nov 20, 2009 4:54 pm
49501
It runs the query just as toad does, via OCI. There are options to handle the data differently, like retrieving all the data, or retrieving none of the data...
Is there a question in there somewhere? From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Damir Vadas Sent: Friday, November 20, 2009 11:48...
... I think he was responding to the toad vs sql optimizer thread. Or else that was intended to be a private email and not supposed to go to the list...
The right-click context menu is wonderful. Check it out. All you have to do is highlight the code you want commented/uncommented, right-click, then select...
Simoneau, Roger
rsimonea@...
Nov 20, 2009 5:32 pm
49505
... I should note for the humor impaired that I recognize writing a parser for a very specific file is trivial in comparison to doing up the code to be able to...
Simoneau, Roger
rsimonea@...
Nov 20, 2009 5:41 pm
49506
I use the NetBeans IDE for dealing with XML files. It has some great browsing and reformatting capabilities. Additionally, it's free. Mike ... From:...
McAllister, Michael A...
Michael.McAllister.ct...
Nov 20, 2009 6:54 pm
49507
... Ask, and we oblige. :) Rich -- [TeamT] Disclaimer: I can't keep up with all my Toad/ToadBeta/ToadSS/ToadSSBeta mails!...
Thanks Jeff. I wasn't aware that SQL Optimizer community has a place to ask questions like this group. I'll move this discussion it over there. Steve...
Hello. I am sure this question has come up numerous times so I apologize in advance for asking this. I have Oracle 10g installed (10.2.0.4) and TOAD 9.0. I...
On the connection screen for toad, at the bottom, you should see a dropdown control that shows your installed oracle clients/oracle homes. Guessing it's empty...
Message from: Site Administrator This is a reply to the watch from the System's Administrator Brian Nettles Communities Technical Administrator Phone: (949)...
Hi Jeff, Thanks for your reply. I tried what you suggested but when I click on this elipses I get the following error message from TOAD: "You do not have any...
mine is located at $ORACLE_HOME/BIN/oci.dll 08/29/2005 07:47 PM 344,064 oci.dll Martin Gainty ______________________________________________ ...
Martin Gainty
mgainty@...
2:06 am
49515
What windows you have 32 or 64 bit? ________________________________ From: arkelaroo <areum@...> To: toad@yahoogroups.com Sent: Sat, November 21, 2009...
Thanks for your reply. I am running 32 bit so there should be no issue in this regard. Thank you for your reply. I am at a loss of how to have TOAD recognize I...
Hi! 1) Right click on your Computer icon, Properties 2) Advanced, Environement variables In PATH ensure that your Oracle home (your client) is first in...