3 Replies Latest reply: Jul 8, 2013 4:31 PM by Barbara Boehmer RSS

    Upload .Sql file using sqlloader

    986570

      Hi ,

       

      Having a sql file

       

      insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )

        Values (:"ID" ,9818764535,9899875643,'IN',to_date('2013-05-24 02:10:43','YYYY-MM-DD HH24:MI:SS') ,10) ;

      insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )

        Values (:"ID" ,9899453215,9215478213,'OUT',to_date('2013-05-24 08:11:13','YYYY-MM-DD HH24:MI:SS') ,20) ;

      insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )

        Values (:"ID" ,9999050217,9899875643,'IN',to_date('2013-05-25 18:07:02','YYYY-MM-DD HH24:MI:SS') ,30) ;

      insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )

        Values (:"ID" ,9818764535,9012451785,'IN',to_date('2013-05-26 02:11:13','YYYY-MM-DD HH24:MI:SS') ,40) ;

      insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )

        Values (:"ID" ,9818764535,9215478213,'IN',to_date('2013-05-26 08:17:02','YYYY-MM-DD HH24:MI:SS') ,25) ;

      insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )

        Values (:"ID" ,9818764535,9899875643,'OUT',to_date('2013-05-26 20:21:04','YYYY-MM-DD HH24:MI:SS') ,67) ;

      insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )

        Values (:"ID" ,9818764535,9899875643,'IN',to_date('2012-05-25 22:07:02','YYYY-MM-DD HH24:MI:SS') ,30) ;

      insert into dpcdr.CALLID ("ID" ,MOBILE_NUMBER ,OTHER_PARTY ,CALL_TYPE ,CALL_DATE_TIME ,DURATION )

        Values (:"ID" ,9818764535,9899875643,'IN',to_date('2013-05-25 22:07:02','YYYY-MM-DD HH24:MI:SS') ,30) ;

       

       

      Loading this using sql loader (sqlldr)

       

      Plz help