Answer Posted / anuram
CREATE OR REPLACE PROCEDURE PROCEDURENAME{(PARAMETERSLIST)}
AUTHID|CURRENT_USER
IS/AS
DECLARATION OF VARIABLES;
BEGIN
STATEMENTS;
EXCEPTION
STATEMENTS;
END PROCEDURENAME;
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain about query and reporting.
Explain about network model?
Write short notes on manual refreshes.
Who are end users in dbms?
What are the 18 schemas?
What is the maximum length of an extended property?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
How to combine two function together?
What are the three types of database design?
How to use online Backups?
What is DB Development software?
Can an extended stored procedure be called from inside a user-defined function?