Search results for query: *

Yeah nevermind...i was being stupid. It could have told me i put in the wrong path... Thanks, Chris

So I've been using sqlldr for some time. I recently created a new bat and clt file for something new. But when i run it it's giving me the 522 error, says it can't create the log file. When i run one of my other batches everything works fine. I've read that it can be a permission issue, but...

Excellent, thanks carp that worked. MMM!=MON sigh. Thanks again everyone, Chris

Thanks guys. Sadly, I'm still getting the same problem. if statement if rbt_rec.PaidDate between start_date and end_date then pl/sql block START_DATE := TO_DATE('10-01-2006','mm-dd-yyyy'); END_DATE := TO_DATE('12-31-2006','mm-dd-yyyy'); Same exact error. I tried changing the IN dates...

Thanks Tharg. I'm still getting an error, a different one now though...progression. Changed the block to START_DATE := TO_DATE('10-01-2006','mm-dd-yyyy'); END_DATE := TO_DATE('12-31-2006','mm-dd-yyyy'); Error Message: ORA-01861: literal does not match format string ORA-06512: at...

I've got a procedure that pulls data from a table based on a date within the table. I put in two parameters when running the procedure, a start and end date(my first procedure with parameters). I can't figure out how to get the format right on the date. here's the if statement if...

I've gotten help on a similar query from SantaMufasa before on this forum. For some reason I seem otherwise inept to change that query to fit what I want to do now. So, I've got a table I want to update(indirect_customer_copy). It has DEA and COT, I want to update the unknown COT based on...

Wow that rocks. I think this should be my last post...on this thread anyway. :) Thanks for all your help, Chris

After writing a long message post it finished the query. I just never let it finish, figured something was going wrong. But it went fine, worked perfectly. Thank you very much for your assistance. One follow up question, what exactly does indexing do? Thanks Dave, Chris

Thanks for the vote of confidence. Well...I stopped getting errors when i ran it...but it's still running :-/ about 2 minutes now... Gpo_memberships has about 42000 rows, and indirect_customer has 14000 rows. Should it being running for this long...about 4 minutes now :) Thanks Dave, Chris

Thanks for the explanation Dave, very helpful. Now i can stop making tables with just the data i'm looking to update from...I knew there had to be an easier way but couldn't find it. Thanks! And I apologize for my continue incompetence... It's saying that a single row subquery is returning more...

So I've tried the code. I added a right parenthesis on the fourth line before a. That's where it should go right? Sadly, as opposed to missing right parenthesis, it's telling me that it's not ended properly. :-/ Any ideas? Question...the ending where clause, why foo? Am i supposed to replace...

Thanks very much for your help Dave. I'm about to head home for the day, but I'll use it tomorrow. Thanks for the not updating to null, I've been trying to figure that one out for awhile. Have a good evening Dave, Chris

Thanks for your help Dave. The Subquery will return multiple values because the dea is listed multiple times and each of those may or may not have different classoftrade values(Y00,W00). I've weight those in the table I showed you. So, if there are two different COTs from the subquery, then...

Oh sure. COT_importance is the table's name. Name, Importance are the two columns in the table. Thanks Dave, Chris

The table I showed has values to the right of the Y00. Y00 is first in that list W00 is second. Does that make more sense? Thanks, Chris

So i've got a query... update indirect_customerb b set (b.class_of_trade) = (select a.classoftrade from gpo_memberships a where a.dea = b.industry_id) whose subquery returns multiple values, which it should. But what i would like it to do is pick from those returned values based on this...

Ahhhh....that makes things much better. Thanks for your help Dave, Chris

So I've written a different query... update indirect_customer b set (b.name, b.address1, b.address2, b.city, b.state, b.zipcode) = (select a.name, a.address1, a.address2, a.city, a.state, a.zip from unknown_names a where a.dea = b.industry_id) It updates the values from second table to the...

I'm fairly new to sql, recently took some classes and putting the knowledge to use for my work. I've got two tables with a common id. One table is missing some values, name and address, that are in the second table. Right now I've got a query that lists the common id and the correct names and...