Uncommited rows with F5 function key not showing up in TOAD same session
I use putty -sqlplus for most of the work... as i see easy to handle DML's.
I am inserting rows with insert statements and pressed F9 for execution..
I am able to see records in toad without commiting records..
whereas
I am inserting rows with multiple insert statements and pressed F5 for execution..
I am not able to see the records in both ways either running select statement with f5 and f9.. ..
Should i set any configuration option in toad when i use F5 for statements execution and to see uncommited records without committing or rollback..just to see what records are inserted or modified???
wonder how to see records which are inserted with insert statement and F5 function key??!!!!
Anyone knows how to see ???
15 years 3 months + of experience in database administration, performance engineering and software cost optimization. Expert in architecture of large scale product, service features in product developments and several POCs executions. Specialty in Database administration, Database Performance, SQL, PLSQL, Shell, Simple solutions for Designing Performance engineering solutions, actively working on Software Cost Optimization in CLOUD. Always ready for new challenges with simple solutions
Monday, January 2, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment