What is Pragma Init Exception ? what is difference between user defined exception and init pragma exception. what is the use of it.
Latest Answer: You trap a nonpredefined Oracle server error by declaring it first, or by using the OTHERS handler. The declared exception is raised implicitly. In PL/SQL, the PRAGMA EXCEPTION_INIT tells the compiler to associate an exception name with an Oracle error ...
Suppose if i have 8 triggers declared for a table..how to disable a single trigger from a table...i don't want to disable all triggers for a table. I know we can disable all triggers by using "alter
Latest Answer: Thanks parweej, alter trigger disable worked for me.. ...
Latest Answer: Disadvantages of Triggers
It is easy to view table relationships , constraints, indexes,
stored procedure in database but triggers are difficult to view.
Triggers execute invisible to client-application. They are
not ...
if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible
Latest Answer: you can select the table for updationfor eg: select * from emp for update;no you can do the update/insert anything you want... any other user or session would be able to do any insert/update to the same table only after you release the table by commit ...
What is Force View. Why Oracle Give Facility to create force view? What is the use of force View
Latest Answer: A view can be created even if the defining query of the view cannot be executed, as long as the CREATE VIEW command has no syntax errors. We call such a view a view with errors. For example, if a view refers to a non-existent table or an invalid column ...
Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P
Latest Answer: Three types of parameter modes1) IN parameter mode- This mode is used to pass values to the calling module when invoked. The value of IN parameter can't be changed in the module.
2) OUT parameter mode -This mode is used to return a value to the main ...
Hi, can any body give me the sample program for avoiding the mutating error. we can avoid the mutating through the statement level trigger instead of using the statement leve trigger, i need one sample
Latest Answer: A mutating error comes when u r trying to do some DML operation on a table that owns the trigger.... there are a lot of options to avoid mutation .. eg, Making it autonomous transaction or making it a statement level trigger ... or using ...
Latest Answer: PL/SQL tables are temporary array like objects used in a PL/SQL Block. The size of pl/sql table is unconstrained. For varrays we need to specify upperbound.Pl/sql tables can not be stored in database where as varrays can be stored in database.We can use ...
Latest Answer: Pls try this link:http://www.databasejournal.com/features/oracle/article.php/1558021Cheers- Faizal ...
Latest Answer: Disadvantage : 1) Executing DDL statements through dbms_sql sometime can result in deadlock. example : we are trying to drop one object at the time it is being accessed by other user. ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
