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 SQL Tuning Advisor in Oracle?
What is meant by raw datatype?
How to convert a string to a date in oracle database?
Difference between cartesian join and cross join?
Is the After report trigger fired if the report execution fails ?
Can the query output be sorted by multiple columns in oracle?
How to assign a tablespace to a users in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Can we call procedure inside function in oracle?
Explain about your project and its relation to the current job position you are applying to?
What does sharding mean?
How to call a stored function in oracle?
How would you begin to troubleshoot an ORA-3113 error?
Are truncate and delete commands same? If so why?
Explain compound trigger in oracle?
