Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cbh35711

    SQLLDR 522 error

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

    SQLLDR 522 error

    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...
  3. cbh35711

    Date Parameters and Procedures

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

    Date Parameters and Procedures

    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...
  5. cbh35711

    Date Parameters and Procedures

    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...
  6. cbh35711

    Date Parameters and Procedures

    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...
  7. cbh35711

    Update query with 4 tables

    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...
  8. cbh35711

    update query returning multiple values but selecting from them

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

    update query returning multiple values but selecting from them

    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
  10. cbh35711

    update query returning multiple values but selecting from them

    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
  11. cbh35711

    update query returning multiple values but selecting from them

    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...
  12. cbh35711

    update query returning multiple values but selecting from them

    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...
  13. cbh35711

    update query returning multiple values but selecting from them

    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
  14. cbh35711

    update query returning multiple values but selecting from them

    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...
  15. cbh35711

    update query returning multiple values but selecting from them

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

    update query returning multiple values but selecting from them

    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
  17. cbh35711

    update query returning multiple values but selecting from them

    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...
  18. cbh35711

    update query based on query from another table

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

    update query based on query from another table

    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...
  20. cbh35711

    update query based on query from another table

    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...

Part and Inventory Search

Back
Top