Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

3

How can you view the errors encountered in a trigger?

1

when MSQL8.0 is in market

982

Explain uses of cursor.

5

What are conditional predicates?

1

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

147

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

2330

Can triggers stop a dml statement from executing on a table?

1

How can the performance of a trigger be improved?

3

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1

Explain polymorphism in pl/sql.

3

How to display Row Number with Records in Oracle SQL Plus?

10

What are the uses of sysdate and user keywords?

3

Differentiate between syntax and runtime errors.

3