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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to hardcode a column of value in SQL Loader
Hi, I'm trying to load a file using sql loader. Is there a way to create a column where I can hardcode and assign a specific value. options (rows=500) load data infile '/d04/1249.dat' badfile '/home/cdb_buslink.bad' into table cdb_buslink truncate (bus_link position(74:89) char...- boxzzz
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
Oracle error: Invalid Number Cause
hi, Can anyone figure out why I'm getting this error message after the query runs for 3 hours. ( see query below) sub_business code is numeric Thanks ERROR at line 1: ORA-12801: error signaled in parallel query server P176 ORA-01722: invalid number ORA-01722: invalid number Cause: The...- boxzzz
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
Inputting multiple values for a prompt in Access
Hi, I'm new to Access. I have a query with a prompt which users can enter only value. What function can I use so that the user can enter multiple values? I tried the "In" function but it doesn't work. This is what I have now prompting user for a single value. "WHERE reference =[Please enter...- boxzzz
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
