Answer Posted / nageswararao.k
procedures and functions are subprograms but triggre is not
a subprogram.
procedure:--once we create a procedure we can use that
procedure from any pl/sql block and any front end
application like java,.net applications.no need to execute
every time.
function:----using function ,we can reuse the code and
passed values though perameteres from calling function to
declared function.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is Redo Log Buffer in Oracle?
How data locks are respected in oracle?
What is execute immediate in oracle?
How to set up autotrace for a user account?
What is key preserved table?
How to list all tables in your schema?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is oracle latest version?
What is the difference between I and G in Oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is Segment Advisor in Oracle?
How can we delete duplicate rows in a table?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is an oracle data file?
What is a parameter file in oracle?