Greetings, In Toad, when you press CTRL+Right, you navigate through the line of text word-by-word. However, if the word contains an underscore character,...
Hi Mike, Go to View/Options/Editor/Behavior and check "Treat undesrscore as a word character" Also works if you want to double click the word to copy and past...
Strong, Stephen
stephen.strong@...
May 2, 2008 12:50 am
42234
I am using Toad for Oracle Professional Version 9.5.0.31 when i click on Database>Import>SQL Loader wizard I get the message "Location of SQl*Loader required" ...
It should install with your Oracle Client. Quest does not provide it, just the means to create control files, call and monitor sqlldr. If you have only...
Hi All, A coworker of mine that uses Toad recenty upgraded from 8.6.1 to 9.6.1 and a script that ran fine in the older version now gives an error about a modal...
<<Thought I had visit all the options. :-)>> Hm...If you succeed in this, I think one would be eligable for an erntry in the Guinness book of records.... ...
I had downloaded the freeware version of TOAD for ORACLE, which expired within three weeks(even though I expected it to stay 60 days). I then downloaded the...
It's a hardcoded 60 days, so we put one out on April 1, it will expire on June 1. Run the installer once, then after that get the update version, which should...
Hi, I have been struggling with saving data from a table of 33 columns in excel and then making updates to one particular column and then import the table data...
Yayra de Souza
ydsouza@...
May 6, 2008 12:27 pm
42243
did the wizard tell you that it made some updates? did you do a commit afterwards? From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Yayra...
Pls. can you tell me at least ONE good reason to do this? I think your problem is that you don't use an UPDATE Statement ;-) Regards Jan Barentsen...
Jan Barentsen
jan.barentsen@...
May 6, 2008 1:52 pm
42245
I chose to commit after each record. The results show me the number of rows processed and during the process I see 70 records updated but I don't see my ...
Yayra de Souza
ydsouza@...
May 6, 2008 1:52 pm
42246
I am doing this because I have about 4732 records to deal with and I am certain making the changes in excel is faster and more convenient than using the update...
Yayra de Souza
ydsouza@...
May 6, 2008 2:55 pm
42247
Sounds good to me. What I don't understand is, does your table ONLY have the 4732 records in it? If so, truncate then run the import, and you're table will...
why not just edit the data grid? From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Jeff Smith Sent: Tuesday, May 06, 2008 9:57 AM To:...
If all you are doing is changing values manually then why not just change them in the schema browser while browsing the table. If you are using EXCEL macros or...
Good point, unless he's using search and replace in Excel...in which case an insert/update with a WHERE clause to match the search and replace should work too....
I feel a little sick to my stomach, Erwin and I agree! ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Jeff Smith Sent: Tuesday, May...
One of the DBAs I work with is trying to use TOAD to add a column to a table. When he presses "Show SQL", there is a check constraint that also get dropped &...
Actually I am using the excel VLOOKUP function to update a particular column without having to go through one by one; I mean I am dealing with 4732 rows here...
Yayra de Souza
ydsouza@...
May 6, 2008 3:32 pm
42255
sounds like the constraints are getting loaded into the alter table screen, but somehow getting lost when you click OK. Is the table in your schema or another...
Are you trying to view the updated data directly in Toad or through web page or some other system? When you perform the update back into Toad, are you 100%...
What's wrong with an update statement that uses "CASE"? Unless your excel lookup table is very large? ___________________________________ Nate West United...
Can't be more than 65k rows. Then index the table? Export to Excel, create vlookup, try to import and update back into oracle VS write update statement? or...
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.
