what is difference between procedure and function,
procedure and trigger?
Answer Posted / ganesh ganjre
Diff. b/w proc. & trigger..
procedure can be called from trigger but trigger can't be
called from procedure.
Trigger(Implicitly)
Procedure(Explicitly)
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
explain the advantages and disadvantages of stored procedure? : Sql dba
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
Why triggers are used?
What is use of term?
What is right join in sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
Can a table contain multiple foreign key’s?
what are the advantages of using stored procedures? : Sql dba
what is an index? : Sql dba
How do you optimize a stored procedure in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How do I create a sql script?
What do you think about pl/sql?
what is the difference between a having clause and a where clause? : Sql dba
Do we need to create index on primary key?