Answer Posted / anuram

CREATE OR REPLACE PROCEDURE PROCEDURENAME{(PARAMETERSLIST)}
AUTHID|CURRENT_USER
IS/AS
DECLARATION OF VARIABLES;
BEGIN
STATEMENTS;
EXCEPTION
STATEMENTS;
END PROCEDURENAME;

What is DB Development software?

2113

---

How to replace not in with not exist?

2171

---

How would you design a database for an online site, which would average a million hits a day?

1050

---

What are the three basic rules which are to be followed for the relational model of the database?

1066

---

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?

2467

---

How to use timestamp datatypes

2075

---

How to read and create .LDC data files which are used by linguatic dictionary.

2580

---

How to use online Backups?

2256

---

Explain about xml databases?

1112

---

Explain what a database is?

1085

---

How can you log an error to the server event log from a stored procedure?

1170

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1069

---

fact table and dimension table containg one to many relationship or many to one relastionship

2546

---

What are the main phases of database development?

1024

---

What are the three types of database design?

1080

---