Sorry. I aready dit what i wanted. The question was how to add fields to the .ctl that where "not in the file to parse", and how to assign values to those new fields added to the .ctl.
I used 'Constants' Ex: Course_Name. Constant 'pl/sql', Teacher Constant 'John wood'.... Thank you for your help. Enviado desde mi móvil BlackBerry Orange. -----Original Message----- From: ddf <orat...@msn.com> Sender: oracle-plsql@googlegroups.com Date: Fri, 6 Jul 2012 07:01:59 To: Oracle PL/SQL<oracle-plsql@googlegroups.com> Reply-To: oracle-plsql@googlegroups.com Subject: [PL/SQL] Re: SQLLOADER - LOOP INTO .CTL FILE On Jul 2, 8:17 am, carlos augusto adames jimenez <augustoada...@gmail.com> wrote: > Hi to everyone. I'm a newby in oracle. I'm working with sqlloader and i > need to load data. My table is transaccional. It's going to be updated > every week. I need a guide because i want to do the following: > > load data > infile* example.txt* > into table *target_table * > fields terminated by "|" > (name, > last_name, > salary, > *status1*, > register_date DATE "DD-MM-YYYY", > *status2* (depending on the value of *estatus1*, i need to load data in the > *status2*. I need to know how to loop in the .ctl, get the value of *status1 > * and load data in *status2*.) > Updated_date DATE "DD-MM-YYYY", > ) > > I hope you can help me guys. I[ll wait for your answers. What is the question here? David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
