Un-Answered Questions { SQL PLSQL }

Differentiate between syntax and runtime errors.

632


What is an intersect?

643


What is the difference between alter trigger and drop trigger statements?

596


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

552


How would you convert date into julian date format?

582


How does rowid help in running a query faster?

959


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

605


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

591


In what condition is it good to disable a trigger?

544


When is a declare statement required?

663


What are the uses of sysdate and user keywords?

614


Does sql*plus also have a pl/sql engine?

551


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

605


Explain the structure of pl/sql in brief.

613


What is a database event trigger?

579