What are wait events. Describe the wait event tables.
Answer / surya
Many of these wait events are tied to the internal implementation of Oracle and therefore are subject to change or deletion without notice. Application developers should be aware of this and write their code to tolerate missing or extra wait events.
The following SQL statement displays an alphabetical list of all Oracle wait events and the wait class to which they belong:
SQL> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;
|Is This Answer Correct ?||1 Yes||0 No|
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
pl/sql testing means what ...... explain process how to find pl/sql bugs
What are Lexical Parameters.How They are used in Reports 6i
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
What are Global Temporary tables
How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).
what is a sub query?how will you calculate working days in a month using sub query?
If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)
what is oracle sql,pl/sql with interfaces
What is the Diff b/w Constraints and Trigeer
I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible
what is inline command?