Hi,
I am trying to have a query in excel column, so that while importing data from excel sheet to oracle data base,
I want to get the values in the column dynamically generated.
create table test(id varchar2(10), idate date);
excel data:
ID IDATE
101 select sysdate from dual;
message:
--Insert failed for row 1
--IDATE GDK-05058: non-numeric character found
--Row 1
INSERT INTO XXX (ID, IDATE) VALUES ('1',to_date('select sysdate from dual;', 'YY-MM-DD'));
What should I do to have a query get executed in place of column value in the table.