Hopefully I am posting this in the right place..
I am having trouble importing data from Excel into an oracle table using the 'import data' wizard in SQL developer.
The problem is that the I want to import data into a table which all ready has data and I want the new data to be imported into the first row of the table not in a new row at the end of the table.
This is probably best shown by example:
create table todelete (
site_no varchar2(2),
data1 number,
qa number);
insert into todelete values ('w1',1,null);
insert into todelete values ('w1',2, null);
insert into todelete values ('w1',3,null);
Now I want to import the following data from excel into the QA column starting at w1:
However, when I import the QA column it goes into a new row:
| SITE_NO | DATA1 | QA |
|---|
| w1 | 1 | NULL |
| w2 | 2 | NULL |
| w3 | 3 | NULL |
| NULL | NULL | 4 |
| NULL | NULL | 4 |
| NULL | NULL | 4 |