how do u call in & out parameters for stored procedures?

Answer Posted / mohana sundaram

create or replace procedure p_name(p_no in out number)
is begin
{
executable statement
}
end p_name;
/

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a ddl command?

720


explain mysql aggregate functions. : Sql dba

724


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

711


What are sql*plus environment variables?

772


How do I run pl sql in sql developer?

855






What is mutating trigger?

768


How many functions are there in sql?

719


What is your daily office routine?

1986


What are the basic sql commands?

743


how can we destroy the cookie? : Sql dba

742


What is a trigger in sql?

884


Where is pl sql used?

677


What is the command used to fetch the first 5 characters of a string?

922


How many indexes can be created on a table in sql?

685


What is %type in sql?

691