Carlos, You should post this question on the Oracle_L list. You have posted this non-PL/SQL question on a PL/SQL group list. Oracle_l is for all oracle related questions.
Mike On Mon, Jul 2, 2012 at 7: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. > > -- > 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
