Hi,
I have a table in which i inserted a record and committed it.
but when i select the for that specific record from the table it gives count as 0.
But if i try to insert record in other table it is inserted and also gives count as 1 for that record.
SQL> ed
Wrote file afiedt.buf
1* INSERT INTO T_TRANSACTION(Transaction_Id, Transaction_Datetime, Shift_Date, Shift_Id, Terminal_Id, Lane_No, Transactionsub_Id, Direction_Id, Operatingmode_Flag, Tc_Id, Tc_Vehicleclass_Id, Tc_Paymentmethod_Id, Tc_Journeytype_Id, Tc_Exemptedtype_Id, Fareroute_Id, Vehicle_No, Vehicle_No_Manualentry_Flag, Passissue_Id, Passrecharge_Id, Referencetollplaza_Id, Referencetransaction_Id, Reference_No, Referenceno_Manualentry_Flag, Tc_Fareamount, Tc_Remark, Tc_Processingtime, Avc_Entry_Datetime, Avc_Vehicleclass_Id, Avc_Axle_Count, Vehicle_Weight, Weight_Slab, Overweight_Fareamount, Plazaserverentry_Datetime, Audit_Datetime, Audit_By_Id, Audit_Vehicleclass_Id, Audit_Journeytype_Id, Audit_Fareamount, Audit_Remark, Transactioncancelstatus_Flag, Transactioncancel_Datetime, Transactioncancel_By_Id, Vehiclephotofile_Path, Numberplatephotofile_Path, Insertupdate_Datetime, TollPlazaDB_ID, CentralDB_Insert_DateTime) VALUES ('301978545', TO_DATE('25/09/2013 10:18:51','DD/MM/YYYY HH24:MI:SS'), TO_DATE('25/09/2013 00:00:00','DD/MM/YYYY HH24:MI:SS'), '1', '3#4', '4', '301978545', '2', '0', '192', '1', '7', '11', NULL, '1', 'PB10CB0938', '1', 'S139', 'S2002', '1', NULL, '2002', '0', '0', 'No Remark', NULL, TO_DATE('25/09/2013 10:18:51','DD/MM/YYYY HH24:MI:SS'), '6', '2', '0', NULL, '0', TO_DATE('25/09/2013 10:18:51','DD/MM/YYYY HH24:MI:SS
'), NULL, NULL, '1', NULL, NULL, NULL, '0', TO_DATE('25/09/2013 10:18:51','DD/MM/YYYY HH24:MI:SS'), '192', NULL, NULL, TO_DATE('25/09/2013 10:18:51','DD/MM/YYYY HH24:MI:SS'), '2975095928', SYSDATE)
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> ed
Wrote file afiedt.buf
1 select count(1)
2* from t_transaction where transaction_id=301978545
SQL> /
COUNT(1)
----------
0
SQL> ed
Wrote file afiedt.buf
1 select count(1)
2* from t_transaction where transaction_id='301978545'
SQL> /
COUNT(1)
----------
0
SQL> Insert into t_shift values (3,'Vehicle',sysdate,sysdate);
1 row created.
SQL> commit;
Commit complete.
SQL> ed
Wrote file afiedt.buf
1 select count(1)
2* from t_shift where shift_id=3
SQL> /
COUNT(1)
----------
1
SQL>