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

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1686

---

material view and view disadvantages?

1057

---

How do you bind variables in oracle?

976

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2281

---

How to pass parameters to procedures in oracle?

1037

---

How to enter a new row into a table interactively?

1004

---

What is a read only transaction in oracle?

1017

---

What is the difference between I and G in Oracle?

1086

---

Explain do view contain data?

996

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2115

---

How do I limit the number of oracle database connections generated by weblogic server?

1061

---

How view is different from a table?

1026

---

How to check the server version in oracle?

1090

---

What is Undo Management Advisor in Oracle?

1091

---

How to create a new table in oracle?

1145

---