Answer Posted / anuram

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

Explain the role of indexing in databases?

1132

---

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

2207

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

969

---

Explain about network model?

1004

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2857

---

How to customize error conditions.

2150

---

Who are end users in dbms?

990

---

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?

2429

---

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

1106

---

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

2497

---

In which table collections errors are stored.

2411

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2028

---

How long can an error message be in raiseerror function?

1002

---

Explain the rollup operator?

1076

---

How to generate OIDS

2254

---