Latest Answer: Oracle9i introduced Flashback Query to provide a simple, powerful and completely non-disruptive mechanism for recovering from human errors. It allows users to view the state of data at a point in time in the past without requiring any structural changes ...
Hi,Can anyone tell me the difference between instead of trigger, database trigger, and schema trigger?Thanks.
sir,pls send me some more oftanily asked oracle interview questions iam an one year exprience person...i need one year oracle interview questions.....
Suppose, I've created a new database DB1 n i've created a table DB1.T1.Now, DESC T1 --> desplaying the table structure butselect * from DB1.T1 ---->giving--> table or view does not exist.. Can any one explain possible reason behind this.
Latest Answer: Hi.. We can change the elements of listitems at runtime with the help of Record Group ...
> Select Count(*) from T1 where a=10 3> Select count(*) from T1 where b=20 11Now, What will b the O/P of the following..select count(*) from T1 where a=10 or b=20..............................
Suppose I have 2 triggers on table T, tr1- a before insert trigger & tr2- a before update trigger.tr1 has update (T) statement inside body of tr1andtr2 has insert (T) statement inside body of tr2Now, I'm tring to insert a row into T.What will hppn??
Latest Answer: %Rowtype : It associated with entire row of the table%Type : Associated with single row of the table.E.gv_emp emp%rorwtypev_ename ename%type ...
Latest Answer: Cursor is a structure which points to a memory locationswhile Ref-cursor is a datastructure which point to a object which inturn points to Memory locations..the advantage of having Ref-cursor is that we can pass dynamically the Ref-cursor as a parameter ...
Latest Answer: We can do as shown below... in the same way we can drop the table..
DECLARE
BEGIN
EXECUTE IMMEDIATE 'create table employee(empno number(3),ename varchar2(10))';
END;
...
View page << Previous 8 9 10 11 [12] 13 14 15 16 17 Next >>
Go Top
