-
PL/SQL Autonomous Transaction
If in PL/SQL Autonomous transaction, you get error then how will you role back the main transaction?
Mohammad Jarwan
- Apr 9th, 2012
Used in table trigger to execute update statement for same table.
dhiren21
- Sep 20th, 2009
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 :::? Restor...
-
Size of Oracle package
“Bigger the size of a Oracle package, the better”. Do you agree? Justify.
dhiren21
- Sep 20th, 2009
No - I do not agreeFunctionality depends..What are you trying to do in a package depends a lot...A Package can call Views, Functions and Triggers, Update, Insert, Delete.. Purpose of a Package, For...
-
SQL Loader
How does Export/Import feature differ from that of SQL Loader?
Sheraz Baig
- Nov 21st, 2013
Totally different Export/Import are oracle utilities to export data in the oracle format and to import the data which is been exported so the format will be the oracle one. While SQL Loader is the u...
dhiren21
- Sep 20th, 2009
Its Different.. For Export we are exporing the data from the Database to a Dump file..i.e EXP from user datafile buffer rows compress etcfor Imprting we are importing the data from a dump file to a da...
