I tried to run this code(oracle tells me that 7 records selected). It seem like its working but when I go into the scott2(table_a) i don't see any data.
insert into scott1.table_a(PIPEID,DWGNUM,DWGNUM2,ZOOMXP,PREVNUM,PREVDESC,ORGPAGE,DWGSCALE,STASTART,STAEND,STARTEQ,
,ENDEQ,ABSTATION1,ABSTATION2,TOWNSHIP,COUNTY,STATE,TOWNUM,RANGENUM,SECTIONNUM,SHEETDIR,DWGSTATUS,STATUS
,USERID,EFFECTIVE_DATE,EDIT_TRACKID,SHAREID,CROSSOVER,LINKID,RELOCATION,EDITDWG,MPSTART,MPEND,UTMZONE) SELECT PIPEID,DWGNUM,DWGNUM2,ZOOMXP,PREVNUM,PREVDESC,ORGPAGE,DWGSCALE,STASTART,STAEND,STARTEQ,
ENDEQ,ABSTATION1,ABSTATION2,TOWNSHIP,COUNTY,STATE,TOWNUM,RANGENUM,SECTIONNUM,SHEETDIR,DWGSTATUS,STATUS,
USERID,EFFECTIVE_DATE,EDIT_TRACKID,SHAREID,CROSSOVER,LINKID,RELOCATION,EDITDWG,MPSTART,MPEND,UTMZONE
FROM scott2.table_a WHERE pipeid= 14004;
Can you please tell me what's going on?