This will work only if the two cloumns has different days but when it comes to the same day then the result will be ZERO days. any suggestion? Zubair ... ...
If you substrac two dates, the result will be in days. Multiplying by 24 gives you the result you want. ... -- Volker Siebelink | URL:...
Volker Siebelink
VSiebelink@...
Jul 1, 2004 12:36 pm
22925
Thank you. Mike Johnston ... From: Jeff Smith [mailto:jeff.smith@...] Sent: Wednesday, June 30, 2004 2:29 PM To: toad@yahoogroups.com Subject: [toad]...
Michael.Johnston
Michael.Johnston@...
Jul 1, 2004 2:10 pm
22926
Options > Startup > Check for Access to DBA Views ... From: Doug Garrett [mailto:doug.garrett@...] Sent: Wednesday, June 30, 2004 11:46 AM To:...
A developer in my group has packages in the procedure editor displaying as double spaced. I know this is a setting somewhere and I can't find it. Can someone...
John L Billings
jbillings@...
Jul 1, 2004 5:59 pm
22928
SQLMonitor.exe now supports MySQL connections. So you can now use a single tool to monitor your Oracle and MySQL connections. ...
so does that mean Toad supports Mysql then as well ? Matt ... From: Jeff Smith [mailto:jeff.smith@...] Sent: 01 July 2004 19:27 To:...
Matthew Green
matthewgreen@...
Jul 1, 2004 6:38 pm
22931
It worked. Thanks, Doug ________________________________ From: Katherine Scott [mailto:katherine.scott@...] Sent: Thursday, July 01, 2004 8:50 AM To:...
... Well, my opinion fwiw, is that if I was a code monkey, doing nothing but pl/sql development type stuff then sql*navigator would be my tool of choice. But,...
Both tools have similar features related to usage in Oracle, but TOAD has more features in its base model, and an additional module with DBA specific features...
Gary Goodwin
gary.goodwin@...
Jul 1, 2004 9:42 pm
22937
I don't have a formal list and we are right in the middle of trying to get Toad 8.0 out by end of the month so below is the rough list off the top of my...
Lisa Waugh
Lisa.Waugh@...
Jul 1, 2004 11:43 pm
22938
Let me preface the following by saying that I've been a long time Navigator users (starting before it was acquired by Quest). My Toad experience has been...
Fred, To execute just the current statement in the SQL Editor, you can use either Ctrl Enter or Shift F9. Those two key combinations execute just the ...
Bought TOAD a couple of weeks ago, and still exploring it's possibilities. As a DBA I'm very interested in the Session Browser, but my happiness is being...
I've tried this morning to download the latest version and I'm still getting the expired version. Can anyone confirm that a later version has yet been posted? ...
Don't worry - the fault was found to be our p(r)oxy server. I now have an unexpired version. Can anyone tell me the reason for the sixty day expiry? Merely...
These days with Sarbanes-Oxley Act being in-progress of its implementation many of the database test work queries are performed using TOAD. Recently, I have...
Ahsan Sheikh
asheikh@...
Jul 2, 2004 12:53 pm
22944
Try using SQL Monitor (file SQLMonitor.exe in the TOAD directory) to find out which query returns an error, and let us know, along with verstions of Toad,...
Hmmm... interesting how Lisa's list "off the top of her head" is exactly the same as the list Gary posted two hours earlier. :) ... From: Lisa Waugh...
Philippe Van Eeckhoudt will be out of the office starting 02/07/2004 and will not return until 26/07/2004. As you can see, I'm out for the moment. For any...
pvaneeckhoudt.cs@...
Jul 2, 2004 3:56 pm
22947
But I do like the possibilities of the features that are in S-Nav that could come over to TOAD. Especially - CRUD Matrix and Web Development. Curious about...
Besides being off-topic, how would we know the structure of your layout? By this I mean, for Query-1, I am positive that there are tables/views which you may...
I think you maybe are confusing the Oracle E-Business Suite (running on top of an Oracle database) with an Oracle database it self. Inside the E-Business Suite...
martin@...
Jul 5, 2004 12:37 pm
22950
Marcia Talk to your systems administration team and ask them to delete the file http://www.toadsoft.com/toadfree.zip from your proxy server/firewall. When that...
HI, Whenever I try to click on DBAtablespaces I get this message (The Space Manager tables were not found. To create...................) Can you please tell me...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
