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

Answer / sanjay

Create Or Replace Procedure Test(p_Var1 In Number)
As
v_Var1 Number;
Begin
v_Var1 := p_Var1;
Dbms_Output.Put_Line(v_Var1);
Exception
When Others Then
Dbms_Output.Put_Line(Sqlerrm(Sqlcode));
End Test;
/

Answer / krishna

PARAMETERS <p>[(<length>)] [TYPE <type>|LIKE <obj>]
[DECIMALS <d>]
[DEFAULT <f>]
[MEMORY ID <pid>]
[LOWER CASE]
[OBLIGATORY]
[VALUE CHECK]
[AS CHECKBOX]
[RADIOBUTTON GROUP <radi>]
[NO-DISPLAY]
[MODIF ID <key>].

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

Explain the use of record option in exp command.

0 Answers  

---

What are the execution control statements?

0 Answers  

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---

How to generate query output in html format?

0 Answers  

---

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,

---

Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?

3 Answers  

---

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,

---

What is the function of Optimizer ?

1 Answers  

---

What is oracle in java?

0 Answers  

---

What is a package ? What are the advantages of package ?

0 Answers  

---

sql query to get zero records from a table

7 Answers   CTS,

---