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 ...
What difference does it make to a Oracle developer while using RAC ? Would/Should he realise that it is a RAC Database ?
If you have an open cursor on a table, modify the same table and commit, what would happen?
Latest Answer: The open cursor execute the query associated with the cursor, identifies the result set, and position . ...
How does a stand alone procedures differ from that of other procedures?
Latest Answer: Stand Alone Procedure is not part of an Package. ...
Which one gives better performance,
co-related subquery or inline views? Why?
Latest Answer: Inline views works better than correlated subqueries in 8i. But things have changed in 9i. This is because Oracle has changed their logic while processing a correlated subquery. ...
What is the main difference between the functions of DB_BUFFER_CACHE and LIBRARY_CACHE?
Latest Answer: DB Buffer cache: when a query is executed then server process looks for block in buffer cache. If the block is not available in buffer cache then server process reads the block from data files.Library cache:It contains the informations of most recently ...
Lets follow the following structure of granting priviledge..A -> B -> C -> D -> EIf we revoke priviledge from C, then what happens with D and E.
Latest Answer: hi, It depends upon the type of privilege you are revoking. Is it object priviledge or system priviledge. There is one major difference in the revocation of object privileges and system privileges. With objects, if you revoke a privilege from a user who ...
While creating a new user we set his password as identified globally, what does it mean?
Latest Answer: We dont set user's password as "identified globally". We write "identified globally" to decide user's scope.Details:In Oracle, we can create user in three ways:1. local user2. external user3. Global userDifferent commands to create these users:We create ...
A table which consist of atleast one primary or Unique key is called as Parent Table.
True / False (Justify)
Latest Answer: Wrong and RightDepends how you take it. If i have emp table without primary key and i search dept table through emp id. Then this would be wrong. So, depends how you take it all i say is it's not verdict but it's an concept ...
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) ...
View page [1] 2 3 4 5 6 7 8 9 Next >>
Go Top
