Problem: Data got committed in another/same session, cannot update row. 

Env: Oracle Sql Developer

How to Solve:

Uncheck below option

Continue reading →

Importing into Oracle Database Table using Sqlplus command

 sqlplus sys/oracle as sysdba

run this command at sqlplus prompt->

SQL>@"/mnt/hgfs/temp/QUERY.sql"; 

and dont forget to commit it at the end.

Continue reading →