Interested to Buy Any Domain ? << Click Here >> for more details...
Write a simple Store procedure and pass parameter to it ?
- 3 Answers
- 7863 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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;
/
| Is This Answer Correct ? | 3 Yes | 1 No |
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;
/
| Is This Answer Correct ? | 0 Yes | 0 No |
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>].
| Is This Answer Correct ? | 0 Yes | 6 No |
State all possible different index configurations a table can possibly have?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
Explain the use of constraints option in exp command.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
how to find count rows in table without count function?
How to connect the oracle server as sysdba?
what is difference between where clause and having clause?
What is a cognitive schema?
What is bulk copy or bcp in oracle?
what are archived logs?
How can windows applications connect to oracle servers?
How do I uninstall oracle client from windows?
Oracle General 
