For which DML statement can we use Explain plan?
Type: Posts; User: babi_geek; Keyword(s):
For which DML statement can we use Explain plan?
What is the difference between mutating table and constraining table?
What is difference between application server and database server?
At the time of installation of oracle 9i does it create database automatically or do we need to create and configure it seperately?
I executed Database Trigger execution order example given in HOW TO's for update statement.
Before update on table and After update on table are executed irrespective of whether update...
After installing oracle 9i server edition our engineer asked for DATABASE cd. Do we need to install database seperately after installing oracle9i in servers?
The rule for updating join views or complex view is
All updatable columns of a join view must map to columns of a key-preserved table.
This point is o.k.
If the view is defined with the WITH...
What are side effects and drawbacks of triggers?
You are saying "any of identified candidate keys can be used as primary key."
Does it mean a candidate key must always satisfy the following two conditions
1. Duplicate values are not allowed...
What is a candidate key in oracle?
What is difference between candidate key, primary key and unique key?
What is a key preserved table?
We can prevent invalid data using Triggers and Constrains?
Which one the better option? And what are advantages and disadvantages?
What is the difference between deferrable and not deferrable constraints?
So far I think return type specification is allowed only for ref cursors.
Then can we define static cursors in package specification part?
Can we specify return type for Static cursors? If yes Can any one give example?
We can overload subprograms in packages.Can't we overloade stand alone subprograms?
Can't we use where current of without using for update?
When do we use where current of statement?
I know cursor variable is a pointer of type REF CURSOR.
But what about cursor. Whether a cursor is a pointer or variable?
What is the difference between for update of columnname and for update?
select * From emp
for update of sal;
Here it locks entire table.
update emp
set job ='SALESMAN'
where empno=7369;
Stored procedure has precompiled execution Plan where as functions can't? Could anyone please clarify this point.
Why SOUNDEX('1') returns NULL value?
1. Where does sql statements processing takes place? In server or client machine?
2. Where does Pl/sql Statements processing takes place? In server or client machine?
Test for whom?
Can We use implicit cursor attributes like %rowcount in cursor for loop?
Can anyone give one example?