Answer Posted / nikhil patel

CREATE OR REPLACE PROCEDURE test_new1(p_vari1 IN NUMBER


. ,p_vari2 IN
VARCHAR2)
AS
v_vari1 table.rollno%type;
v_vari2 table.name%type;


BEGIN
v_vari1 := p_vari1;
v_vari2 := p_vari2;
INSERT INTO table (
rollno
,name
)
VALUES (
v_vari1
,v_vari2
);

END;
/
COMMIT;




-- CALL PROCEDURE IN OTHER PL-SQL BLOCK

BEGIN

test_new1(0127,'nikhil');

END;
/

How do I uninstall oracle client from windows?

1057

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1128

---

State some uses of redo log files?

1064

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2119

---

What are the most common interview questions on ETL Testing for experience?

1189

---

When do we use group by clause in a sql query?

1101

---

How to convert character types to numeric types?

1193

---

How many types of tables supported by oracle?

1118

---

How oracle handles dead locks?

1129

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1124

---

Difference between open_form and call_form in oracle.

1222

---

What is meant by an index?

1221

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2066

---

Can you have more than one content canvas view attached with a window ?

2370

---

What's dateware house and what's clustor with practicle example

2233

---