what is the difference between implicit and explicit trigger
Answers were Sorted based on User's Feedback
Answer / slokh
when we fire any DML operation a memory is alocated. this
memory area is called context area or cursor. data is
retieved and stored in this area
implicit cursors are automatically created by the Oracle.
when you perform any DML operation a memory has been
automatically created, and when the operation is finished
it automatically release the memory space, here every thing
is controlled by the oracle itself.
explicit cursors are the cursors, where the user defined
for which select statement the cursor is being created,
when to fetch the data, and release the memory space. on
other words the control is over the programmer.
Is This Answer Correct ? | 1 Yes | 10 No |
Answer / gaurav gupta
However,queries that return more than one row you must
declare an explicit cursor or use a cursor FOR loop.
Explicit cursor is a cursor in which the cursor name is
explicitly assigned to a SELECT statement via the
CURSOR...IS statement.
An implicit cursor is used for all SQL statements Declare,
Open, Fetch, Close. An explicit cursors are used to process
multirow SELECT statements An implicit cursor is used to
process INSERT, UPDATE, DELETE and single row SELECT. .INTO
statements.
Is This Answer Correct ? | 3 Yes | 14 No |
what is an index? : Sql dba
How to run sql*plus commands in sql developer?
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
How many columns should be in an index?
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);
What is a column in a table?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
how to debugg a procedure or package using dbms_output.put_line in plsql
Difference between NVL, NVL2 and NULLIF
What are instead of triggers?
consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.
What is view explain with example?