Latest Answer : 1)Using DBMS_JOB package,we can schedule the job.There are number of built-in functions in that package to schedule a job.Ex:DBMS_JOB .SUBMITDBMS_JOB .RUN.2) Using DBMS_SCHEDULERTHIS I SYNTAX FOR CREATING JOBdbms_scheduler.create_job(ob_name ...
Latest Answer : May be it is better to trace a select statment with on logon trigger.like:CREATE OR REPLACE TRIGGER SYS.ON_LOGON_ALL AFTER LOGON ON DATABASE WHEN (USER = 'MAX') BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=TRUE'; --EXECUTE IMMEDIATE ...
Can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?
How can we find the status (enabled/disable) of the trigger and the user who changed the status in SQL-Server.Many thanks.
Latest Answer : First create a Trigger and with Procedure you insert records.The :new will take the new values.So use Triggers in Procedures. ...
Latest Answer : no difference ...
How to return multiple records from procedure?e. g. I fired a select query and I want to retun a result to ?
I have written a procedure in which the cursor is fetching 2 lakh records. I would like to pass on these 2 lakh records as an in paramter to the other procedure. How can we achieve this logic?
Help me to write a procedure for:verify a table for record if it is exists need to update or else insert that record( using cursor write a procedure )
If anyone asks in interviews, about "what are the types of triggers" then my ans is likerow level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.and can i even mention instead of triggers,database trigger and schema triggers
