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|
What are the datatypes a available in PL/SQL ?
What is an index and types of indexes. How many number of indexes can be used per table ?
How can we overcome recursive triggers in SQL?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is the usage of NVL?
i don't want the message as 14 rows updated just it should update what it will do
3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);
write sub query for eliminating duplicate rows using analytical function?
what are %TYPE and %ROWTYPE? what is the difference?
How to call the function and Procedure in trigger?
if i perform any operation on views such as insert, delete etc will my base table get affected?????
What are the default Oracle triggers??