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

6. Display the client name and order date for all orders using the traditional method.

1991

---

How to use "if" statements on multiple conditions?

914

---

Explain temporal data types in oracle

794

---

What suggestions do you have to reduce the network traffic?

713

---

How to create a table in a specific tablespace?

724

---

How to assign data of the deleted row to variables?

790

---

How to apply filtering criteria at group level in oracle?

786

---

What is a system tablespace and when it is created?

722

---

What is the difference between view and materialized view in Oracle?

837

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1787

---

What is bulk load in oracle?

811

---

Can we call procedure inside function in oracle?

791

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

850

---

Explain the difference between a procedure and a function?

792

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

838

---