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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- cbh35711
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
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...- cbh35711
- Thread
- Replies: 8
- Forum: Oracle: All versions
-
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...- cbh35711
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
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...- cbh35711
- Thread
- Replies: 17
- Forum: Oracle: All versions
-
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...- cbh35711
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
An update based on a query
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...- cbh35711
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
Pattern Matching road block
I'm trying to get a report i run from our system into a tab delimited format. I've pretty much got the pattern down save one part. The system puts tabs between fields that aren't too long, but the ones that are it puts spaces. MIDWEST BENEFIT PHARMACY\t\t\t\t then spaces CORNERSTONE PHARMACY... -
open(OUT, ($_[$count + 6]) not working
And i guess perl thinks it shouldn't work, but i do! i want it to choose between like ">$file" and ">>$file" which are located within the array that i passed to it. But it's giving me a comp error, this is the whole function: sub save { $file = ($_[$count + 3]).$dateMod. ".txt"; open(OUT... -
Using perl to click a button in a frameset
I need to interact with a secure webpage in order to upload some data. I've got to the first secured page as it were by just passing my password and username as normal $browser = $browser->get('https://user:pass@url/'); Everything i've found on cpan.org is specifically geared towards forms in...
