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
What is DB Development software?
How to replace not in with not exist?
How would you design a database for an online site, which would average a million hits a day?
What are the three basic rules which are to be followed for the relational model of the database?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How to use timestamp datatypes
How to read and create .LDC data files which are used by linguatic dictionary.
How to use online Backups?
Explain about xml databases?
Explain what a database is?
How can you log an error to the server event log from a stored procedure?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
fact table and dimension table containg one to many relationship or many to one relastionship
What are the main phases of database development?
What are the three types of database design?