Latest Answer : Following this as an example let us see how the select execution happens in
database.
SELECT ename,sal,job FROM emp
WHERE job='clerk'
ORDER BY sal;
How does the query execution occur?
SQL*plus checks the syntax on client side.
If syntax ...
Give the count for each daemon when 150 sessions are connected to database provided only 200 concurrent sessions are allowed in that database ?
Provide names of classes that are used in database connection using Oracle,Access database, and MSDE
Design a suitable database system for a bank along with 20 possible queries to the database (the quries should be such that their solution involves subquries or joins or both). Implement the database and the queries in a commercial DBMS using SQL
How can we force the database to use the user specified rollback segment?
MERGE INTO SAS F USING (SELECT PRODID, PRODID+10 F, DESCRIP FROM PRODUCT) L ON (F.PRODID=L.PRODID) WHEN MATCHED THEN UPDATE SET F.PRODID=L.F WHEN NOT MATCHED THEN INSERT
Latest Answer : I think Error lies in the following statement INSERT VALUES (L.F, L.DESCRIP) THE STATEMENT SHOULD BE LIKE THIS INSERT (F.PRODID,F.DESCRIP)VALUES(L.F,L.DESCRIP) ...
What difference does it make to a Oracle developer while using RAC ? Would/Should he realise that it is a RAC Database ?
