| amjad |
Posted: Apr 27, 2008 03:09:47 AM |
Total Post: 23
Joined: Feb, 2008
|
Hi friends
last time i had exported 13 records from one table acc_vacation where emp_kgl_no=17995
when i import this table rows in database a new table is created by name acc_vacation24042008 and rows had been imported there and my orignal table is showing empty rows
please help me out i will be thank full to all of you
1
how to copy my all the recods of this table and put into the orignal table
2
how to delete the 13 recods which i had imported
eager ly wating for ur reply
|
|
|
 http://shaharear.blogspot.com |
| Posted: Apr 27, 2008 04:22:05 AM |  |
|
Total Post: 79
Joined: Apr, 2008
|
TO coppy the 13 row of acc_vacation24042008 table into acc_vacation table
sql> insert into acc_vacation values (select * from acc_vacation24042008);
check whether those row are copied properly. if it is ok then
sql> commit;
now delete the unnecessary table acc_vacation24042008
sql> drop table acc_vacation24042008 purge;
hope it will work for you ...
regards
http://sharear.blogspot.com/
|
|
|
|
|
| amjad |
| Posted: Apr 27, 2008 04:29:55 AM | |
|
Total Post: 23
Joined: Feb, 2008
|
thanks for the advice i will do it and please let me know how to delete the 13 records from a table whose emp_id=17995.
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 27, 2008 06:17:03 AM | |
|
Total Post: 79
Joined: Apr, 2008
|
"thanks for the advice i will do it and please let me know how to delete the 13 records from a table whose emp_id=17995."
DELETE FROM table_name x where x.emp_id=17995
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 27, 2008 09:33:02 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
How it is related to import operation?
...my orignal table is showing empty rows ...
and did you find out why your original table is empty after export.
|
|
|
|
|
| Napster |
| Posted: Apr 28, 2008 06:15:43 AM | |
|
Total Post: 24
Joined: Apr, 2008
|
Hi,
Can you list the import command that you fired alongwith the parameters.
regards
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
