ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
how do u call in & out parameters for stored procedures?
 Question Submitted By :: Vamshi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how do u call in & out parameters for stored procedures?
Answer
# 1
procedure_name(a in number,b out varchar)
		(
			script of execution;

		)
		exec procedure_name(first_parameter,second_parameter);
 
Is This Answer Correct ?    5 Yes 2 No
Sudhir Kumar Singh
 
  Re: how do u call in & out parameters for stored procedures?
Answer
# 2
create or replace procedure p_name(p_no in out number)
is begin
{
executable statement
}
end p_name;
/
 
Is This Answer Correct ?    2 Yes 2 No
Mohana Sundaram
 
 
 
  Re: how do u call in & out parameters for stored procedures?
Answer
# 3
create or replace procedure <pocedure_name>(x in number,y 
out varchar) is begin
                {
			executable statements;

		}
end <procedure_name>;

exec <procedure_name>(first_parameter,second_parameter);
 
Is This Answer Correct ?    3 Yes 3 No
Sangeetha
 
  Re: how do u call in & out parameters for stored procedures?
Answer
# 4
<procedure_name>(in_parameter_value, 
out_parameter_variable);
 
Is This Answer Correct ?    4 Yes 2 No
Sangeetha
 
  Re: how do u call in & out parameters for stored procedures?
Answer
# 5
create or replace procedure <pocedure_name>(x in number,y 
out number) is begin
                {
			executable statements;

		}
end <procedure_name>;

exec <procedure_name>(10,y);
 
Is This Answer Correct ?    4 Yes 1 No
Susila
 
  Re: how do u call in & out parameters for stored procedures?
Answer
# 6
See the example below...

create or replace procedure addn(a in number,b in number, c 
out number)
 is
 begin
 c:=a+b;
 dbms_output.put_line(c);
 end addn;

Now we can call the in and out parameters as

declare a variable for the out parameter as

var n number;
exec addn(5,10,:n);
print n;
 
Is This Answer Correct ?    2 Yes 1 No
Soujanya
 
  Re: how do u call in & out parameters for stored procedures?
Answer
# 7
Thanks yaar !!!!!!!!
 
Is This Answer Correct ?    2 Yes 1 No
Venkat Soma
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
How One can easily select all even, odd, or Nth rows from a table using SQL queries?  3
Explain Connect by Prior?  2
Where the Pre_defined_exceptions are stored ?  1
What is the default value of CHAR type? Bosch1
What are the usage of SAVEPOINTS?  4
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day. Hexaware3
How to maintain the history of code changes of pl/sql?  2
Give the structure of the function ?  1
What is mutating table? Saama-Tech6
how can i create a user defined datatype  2
Name the tables where characteristics of Package, procedure and functions are stored ?  3
What is the usage of NVL? Infosys6
what command is used to create a table by copying the structure of another table including constraints ? eicc4
write a query to delete similar records in different tables with same structure  4
Store procedure will return a value? eMids2
how to get the third quarter of employee details from emp? CompuTech1
What is the basic structure of PL/SQL ?  5
what is meant by tuning and tk proof?  2
why sql is used as interpreter frequently rather than a compile?  1
can i call procedure in package TCS3
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com