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;
/

What is oracle data type?

907

---

What happens if you use a wrong connect identifier?

989

---

How to define a variable of a specific record type?

1024

---

What are the arithmetic operations?

1030

---

What are the different types of synonyms?

1083

---

How to insert a record into a table?

1026

---

How to select an oracle system id (sid)?

1022

---

How to define a specific record type?

1041

---

List the various oracle database objects?

1000

---

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 ?

1971

---

What are the different editions of oracle?

1058

---

What are the database administrators utilities available?

982

---

Difference between open_form and call_form in oracle.

1100

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2071

---

What is a subquery in oracle?

1046

---