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
How to delete an existing row from a table in oracle?
What is columnar storage what is the advantage?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How can I get column names from a table in oracle?
How to best split csv strings in oracle 9i?
What is enter substitution variable in oracle?
What is the quickest way to export a table to a flat file?
What are the different pseudo commands? Explain in general?
How do I learn what codesets are available in oracle?
What happens if variable names collide with table/column names?
How to create a new view in oracle?
How to export data to a csv file?
What are the predefined tablespaces in a database?
How does one get the view definition of fixed views/tables?
What to do if dba lost the system password?