HI all,
I AM using ORACLE 11g.
i have below details
create table sr_ms_usp_upload_user_v(
END_DATE VARCHAR2(4000)
,START_DATE varchar2(4000)
);
insert into SR_MS_USP_UPLOAD_USER_V values('23-JAN-14','23-JUN-14');
INSERT INTO SR_MS_USP_UPLOAD_USER_V VALUES('2-JAN-14','23-JUN-14');
insert into SR_MS_USP_UPLOAD_USER_V values('23 01 14','23 2 14');
INSERT INTO SR_MS_USP_UPLOAD_USER_V VALUES('23-JAN-14','23-JUN-14');
CREATE TABLE SR_MS_USP_USERUPLOAD_STG
(
END_DATE Date
,START_DATE Date
);
BUT ABOVE values I NEED to insert in SR_MS_USP_USERUPLOAD_STG table WHICH END_DATE and START_DATE is date data type
THANKS
DAMBY