 Related Questions Latest Answer : First you have to understand that Oracle is a MVCC (multiversion concurrency control) or "repeatable read" database system. Queries are returned with all rown consistent with respect to the point in time (SCN) you bagan the query (or earlier with "flashback ... Read Answers (6) | Asked by : SaratKumar Latest Answer : Raise_application_error(error number,error discription) ... How to repair the tnsnames.ora file.
File is completely corrupted and you get network adapter errors and TNS resolve error after restarting the machine. MERGE INTO SAS F USING (SELECT PRODID, PRODID+10 F, DESCRIP FROM PRODUCT) L ON (F.PRODID=L.PRODID) WHEN MATCHED THEN UPDATE SET F.PRODID=L.F WHEN NOT MATCHED THEN INSERT Latest Answer : I think Error lies in the following statement INSERT VALUES (L.F, L.DESCRIP) THE STATEMENT SHOULD BE LIKE THIS INSERT (F.PRODID,F.DESCRIP)VALUES(L.F,L.DESCRIP) ... If in PL/SQL Autonomous transaction, you get error then how will you role back the main transaction? Latest Answer : Before this Ask a Question to your Self... What are you Updating?When You Updated this?How you are updating?Then Check the Commit Point if commited not possible to rollback normally.Steps ::: Restore the Point in time Data and Import the Perticular ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
