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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Finubar
-
Hi there i an trying to load data
BilliaUK unfortunately i can't use the APPEND INTO TABLE etc... ( COL_NAME SEQUENCE(MAX,1) ) The Cust_id gets the next sequence number which then has a modulus function run on it e.g. sequence number 6251 6*6 = 36 2*5 = 10 5*4 = 20 1*3 = 1...- Finubar
- Post #5
- Forum: Oracle: All versions
-
Hi there i an trying to load data
ThomVF when i tried your solution i got the following error Record 1: Rejected - Error on table TDCO_CUSTOMERS. ORA-01461: can bind a LONG value only for insert into a LONG column Any other suggestions gratefully recieved !!!!- Finubar
- Post #4
- Forum: Oracle: All versions
-
Hi there i an trying to load data
Hi there i an trying to load data from a text file into 3 different tables. This would be pretty staight forward except for that on the main table there is a Primary key. the Primary key is a sequence with a check character which is worked out using a modulus. i can't get the call to the...- Finubar
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
Decoding in SQL Loader
Hi from the Emerald Isle I am trying to load data from a flat file into 3 seperate tables. The tables contain numerous different columns and for the purpose of this job most can be filled with constants. my problem lies in the that the flat file contains a county name description but 2 of the...- Finubar
- Thread
- Replies: 1
- Forum: Oracle: All versions
