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 is an oracle and why it is used?
Explain the use of log option in exp command.
How to rollback the current transaction in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
What is the difference between PFILE and SPFILE in Oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is the relation of a user account and a schema?
How to load data from external tables to regular tables?
What is the usage of control file in oracle?
Explain a private synonyms?
What is oracle data type?
How to divide query output into groups in oracle?
What do you mean by group by clause?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to estimate disk space needed for an export job?
