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 would you begin to troubleshoot an ORA-3113 error?

2079

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

---

Explain how you would restore a database using RMAN to Point in Time?

2146

---

What is truncate oracle?

972

---

How to start instance with a minimal initialization parameter file?

1042

---

What is the usage of synonyms?

1143

---

How to use subqueries with the in operator using oracle?

1091

---

Describe an oracle table?

1050

---

How to retrieve the count of updated rows?

1128

---

Can we insert data in view oracle?

1039

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2257

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2186

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2180

---

Explain the use of log option in exp command.

1121

---

What is a nested table?

1062

---