Interested to Buy Any Domain ? << Click Here >> for more details...
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 do you mean by merge in oracle?
How to recover a dropped table in oracle?
How do we display rows from the table without duplicates?
What is blob data type in oracle?
Whats the benefit of dbms_stats over analyze?
Can we convert a date to char in oracle and if so, what would be the syntax?
What are the advantages of oracle?
What is the difference between postgresql and oracle?
What is a database table in oracle?
Is oracle the best database?
Can you drop an index associated with a unique or primary key constraint?
Give the various exception types.
What is oracle and what are its different editions?
Explain what are the characteristics of data files?
Is there a combination of "like" and "in" in sql?
