| Inserting data in multiple table [message #128100] |
Fri, 15 July 2005 01:33  |
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
|
Member |
|
|
Hi Group,
Hopw everyone doing fine.
How can we insert a data from datafile into multiple tables depending upon the number of rows in the datafile.
Let me explain you with small example,
suppose we have datafile (values are in fixed format) like
1,accounts,puneet sachar,sec1
2,abc,sec2
3,accounts,Jos,sec2,
4,Dave,sec4
5,computers,John,sec4
Depending upon number of columsn the data will go to table
incase in row 1 the value should go to departments table as it has departname (column 2)
while row 2, 4 shold go to emp table as they don't have department associated with them.
Please help!
Cheers
Puneet sachar
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
