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>].

What are the different types of synonyms?

0 Answers  

---

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

---

What is a synonym? What are its various types?

0 Answers  

---

what is the difference between no rows returned and null returned?

2 Answers  

---

Explain 1st, 2nd, 3rd normalization form of data base

3 Answers   KH, Thermotech,

---

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

---

what is the syntax of CREATE command?

8 Answers  

---

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

what is Table ?

2 Answers  

---

How to create a stored function in oracle?

0 Answers  

---

How to call a trigger inside a stored procedure?Give an example.

2 Answers  

---

DBMS vs. RDBMS

2 Answers   TCS,

---