Latest Answer: To add primary key or unique key constraint Alter table tablename add constraint constraintname primary key / unique (column name)To add check constraint Alter table tablename add constraint constraintname check (codition)To add ...
Latest Answer: Clustering is a method of storing tables that are intimately related and often joined together into the same area on disk. For example, instead of the BOOKSHELF table being in one section of the disk and the BOOKSHELF_AUTHOR table being somewhere else, ...
Why we use instead of trigger. what is the basic structure of the instead of trigger. Explain specific business reason of it's use
Latest Answer: select a.no from (tablename) t1 a where rowid notin (select (max(rowid) from t1 b where a.no=b.no) ...
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: view is created with out base table that situation we use FORCE ...
View page << Previous 3 4 5 6 [7] 8 9 10 11 12 Next >>
Go Top
