| Other Oracle General Interview Questions |
|| Asked @
|What is Public Database Link ?
|Which Database is the best for the Security issue ?
1. DB2 2.SQL Server 3.MySQL 4.ORACLE
|where we have to use ON clause and where we have to use USING
clause in JOINS
|What is an Index ? How it is implemented in Oracle Database ?
|What is clusters ?
|create or replace procedure show_tab_rec ( P_tab VARCHAR2 )
cmd := 'select *
from '|| P_tab;
for int in ( execute immediate cmd )
dbms_output.put_line ( int.ename||' '||int.deptno);
when i m compling this procedure i m getting this error
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting
of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <an exponent (**)> <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member
PLZ solve this error
give this question answer asap
|What is a Schema ?
|what is foreign key?
|9)When information has to be stored w.r.t employees and
their respective departments, which of the following is the
Correct formulation of entries?
A)Employee and department would together be represented as
B)This is too less information to decide on entities.
C)An employee would be one entity and a department would be
D)Such a scenario cannot be modelled in RDBMS
|i can create a view with two columns from emp table,, later
i need to add one more emp column to existing view.. what is
similarly add one more column to existing primary key
constraint.. please give me the solutions
|what is the syntax of DROP command?
|why pl sql doesn't support retrieving multiple records
|For more Oracle General Interview Questions Click Here |