Interested to Buy Any Domain ? << Click Here >> for more details...
Write a simple Store procedure and pass parameter to it ?
- 3 Answers
- 7739 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 |
where we have to use ON clause and where we have to use USING clause in JOINS
What is a Garbage Collection? and what is full recursive Garbage collection?
What privilege is needed for a user to create tables in oracle?
Differentiate between pre-select and pre-query?
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
Who i will insert 1 lacks record in a Database table
How to insert a record into a table?
What is an oracle database table?
what is pragma?
Difference between varchar and varchar2 data types?
Oracle General 
