Expand the table tab in PL/SQL Developer & Right click the table you want to edit the data (Insert or Update)... Click Edit Data ---> this will open as a new window....Go and Edit ur data and Commit ....now your data has been edited without write any Insert or Update query.. Keep follow us...... ru-vid.com/show-UCMNSEyNGRJL6KLcxfp38-0Qvideos
Hi Bro.. Dont think too much bro.. We can not handle each case in a exception.. Even Oracle Knows this.. because of this only oracle have introduced "EXCEPTION WHEN OTHERS" , If you know the exception you can handle ...If you dont now what type of exceptions are possible in ur code ... Just add "Exception WHEN OTHERS".. this exception will capture the all unknown run time errors. ::)) Oracle PL/SQL World
First you should understand compile time error And Run time error ...Compile time error occurred when u have syntax error in ur code ... But what I have shown is Run time error ..When u call the program it may happens...U can't find it easy way when u have big procedure... So we are using step by step debugging