Answer Posted / anuram

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

How can I detect whether a given connection is blocked?

1028

---

How to use timestamp datatypes

2011

---

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

984

---

What is database design and development?

988

---

What is dbms and its application?

975

---

How long can an error message be in raiseerror function?

982

---

Write short notes on manual refreshes.

2714

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2189

---

State the acid rules?

1104

---

Explain about the storage and physical database design?

894

---

Explain about post-relational databases?

995

---

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?

938

---

Explain about normal forms?

1030

---

Explain about the database management systems.

953

---

How you can make a parameterized view?

991

---