Here is what happens - I am on schema browser looking at table data. I click other table and get a pop-up with error - Can not focus on disabled or invisible...
ok .. tks ... De: Lenka Vanek <lenka.vanek@...> Para: "toad@yahoogroups.com" <toad@yahoogroups.com> Enviadas: Sexta-feira, 1 de Agosto de 2008 16:59:48 ...
Hi all, we are implementing SAP ECC4. As a dba I want to connect the SAP oracle database with the schema "sys" as sysdba. But I can not connect. You can find...
Init.ora or spfile parameter REMOTE_LOGIN_PASSWORDFILE must be set to either SHARED or EXCLUSIVE. From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On...
All, I was wondering if one can define the order in which the tables are listed in the schema browser. Too often the developers like to see related tables...
Sorry, you can only sort by clicking column headers (Img, Table, etc) One idea is to make private synonyms in some schema, named the way you want for grouping...
Hi John, ... Sort of! In the SB, right click on the 'tables' heading (I use the tree view format) then select Filter Tables from the list. In the dialogue, you...
Hi Norm, Yep, what you mentioned will work for the treeview, but if the OP uses one of the other styles (tabbed or dropdown), then that method won't work, as...
I'm wondering if the Project Manager might not provide some relief for your developers. You can create one or many projects for your applications/programs and...
Very cool! Thanks for the tip! I really must find proper time to explore Toad fully. RAS ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]On Behalf...
Simoneau, Roger
rsimonea@...
Aug 5, 2008 3:37 pm
43158
... Now that does sound like fun. One could use the primary key as the seed for a pretty good randomizer... End users can expect the excitement of never...
Simoneau, Roger
rsimonea@...
Aug 5, 2008 3:49 pm
43159
Huh? Dan -- Dan Madvig Northwestern College & Radio, St. Paul, MN 651.631.5323 From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of udhaya0987...
Madvig, Daniel B
DBMadvig@...
Aug 5, 2008 8:02 pm
43160
unabashed proselytising has reached a new low (or new high if you're standing on your head)can we get back to SQL questions???Martin...
Martin Gainty
mgainty@...
Aug 5, 2008 8:02 pm
43161
select trunc(months_between(sysdate,birthday)/12) as AgeNow from mpi_person I am trying to convert the Birthday field to show in Age, however in the database...
Answer: Convert your birthday to a date from a number. You may have to convert it to a character first so you can be sure to strip the leading space that...
Simoneau, Roger
rsimonea@...
Aug 5, 2008 8:24 pm
43163
If you can explain how the value birthday is determined in your database, it will be helpful. JS Huang X 68309 ________________________________ From:...
In this case try the following: select trunc(months_between(sysdate, TO_DATE(TO_CHAR(birthday), 'YYYYMMDD'))/12) as AgeNow from mpi_person JS Huang X 68309 ...
... You might want to drop in a case structure to handle the zero/null values (if you're on at least Oracle 8i): SELECT CASE WHEN birthday = 0 or birthday IS...
Simoneau, Roger
rsimonea@...
Aug 5, 2008 9:15 pm
43168
... did not use the To_Date function and the To_Char at the same time! Thanks So Much!! ... Of ... Behalf ... (or ... or ... telephone ... and ... should...
Not sure this is a bug, but certainly a difference between 9.6.1.1 and 9.5. If I do a simple: select * from emp e where e. I use to get the list of column...
There's a performance hit involved when we query the synonyms to see if it belongs to the object your doing the look up on. You can turn this on here - Toad...
If the synonym is private then support for private synonyms has been added for Toad 9.7. Michael ... From: Jeff Smith To: TOAD GA List ReplyTo: TOAD GA List ...
Morning Logle, ... First of all you need to know what format the number is. Is it days since some particular point in time, or a Julian date etc etc, or is it ...
Morning again Logle, Ok, sorry I have only just noticed the other replies to your problem where the birthday problem is 'solved'. I must learn to use the ...
Morning John, ... Dash it all! This is what happens when you always use the tree view - it's just so much better (to my mind) as I have a small screen and lots...
Hi John, it helps if I actually spot errors when I proof-read! ... That should be the tabs.table_name of course. Cheers, Norm. [TeamT] Information in this...
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.
