Is it possible to use LONG columns in WHERE clause or ORDER BY?3 12904
Is it possible to access the current value in a session before accessing next value?1 4615
What are the data types allowed in a table?3 4818
What is an Integrity Constraint?4 5749
Explain Connect by Prior?2 9535
What are the types of SQL Statement?3 17314
What is a transaction?5 5418
How to access the current value and next value from a sequence?6 8738
What is CYCLE/NO CYCLE in a Sequence?2 7241
What is a database link?3 5319
If a View on a single base table is manipulated will the changes be reflected on the base table?5 10566
Where the integrity constrints are stored in Data Dictionary?1 4505
What is a join?Explain the different types of joins?6 25639
What is ON DELETE CASCADE?3 8180
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
How can you view the errors encountered in a trigger?
when MSQL8.0 is in market
Explain uses of cursor.
What are conditional predicates?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
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
Can triggers stop a dml statement from executing on a table?
How can the performance of a trigger be improved?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Explain polymorphism in pl/sql.
How to display Row Number with Records in Oracle SQL Plus?
What are the uses of sysdate and user keywords?
Differentiate between syntax and runtime errors.