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

Explain the use of show option in imp command.

1044

---

How to create a new table in your schema?

1027

---

How a tablespace is related to data files?

1060

---

Give the different types of rollback segments.

978

---

What are the logical operations?

1063

---

What is the maximum number of triggers that can be applied to a single table?

953

---

How to update values on multiple rows in oracle?

971

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1982

---

Explain the different normalization forms?

1008

---

what is IDE,DMV in sql server?

2752

---

How to view existing locks on the database?

994

---

How to convert character types to numeric types?

1053

---

How to specify default values in insert statement using oracle?

1034

---

What is connection pooling in oracle?

911

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2995

---