If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.4 7008
What is your daily office routine?1201
which will default fire first statement level trigger or row level trigger2 4924
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
Difference between global and parameter variables?
Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.3 5573
write a query to find 4th max salary7 3277
What are instead of triggers?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's.
You shouldn't use more than one select statement in entire the program.
Like cursor c is select * from
Explain ttitle and btitle.
How are functions and procedures called in PL/SQL?
What are the uses of merge?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is Histogram?
Can cursors be part of a trigger body?
Differentiate between syntax and runtime errors.
Differentiate between sga and pga.
How to display Row Number with Records in Oracle SQL Plus?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Explain commit, rollback and savepoint.