Using SQL statements, remote tables can be accessed in
procedures. Database links are specifically used for this purpose. They connect
one oracle database to another....................
Read answer
Return statement in a stored procedure is not to return
values. It simply returns control to the caller before the end of the
procedure...................
Read answer
Information in subprograms is passed through parameters. If the parameter
declared in a subprogram is referenced in the subprogram body, it is called as
a formal parameter................
Read answer
Also read
Explain IN, OUT and INOUT in procedures, What are the rules of writing package?,
Explain the rules for writing a package..............
Procedure runs only when one call them manually whereas a trigger runs when
there is any activity (insert,update,delete) on table on which the trigger is
written..........
Row Level Trigger is fired each time row is affected by Insert, Update or Delete
command. If statement doesn’t affect any row, no trigger action
happens.........
Stored procedure is a set of pre-compiled SQL statements, executed when it is
called in the program..........
|
