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
