What are the modes of parameters that can be passed to a
procedure ?
Answer Posted / suman
IN- The parameter can be referenced by the procedure or
function. The value of the parameter can not be overwritten
by the procedure or function.
OUT- The parameter cannot be referenced by the procedure or
function. The value of the parameter can be overwritten by
the procedure or function.
INOUT- The parameter can be referenced by the procedure or
function. The value of the parameter can be overwritten by
the procedure or function.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can a commit statement be executed as part of a trigger?
How to display the current date in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Can we perform dml in function?
define sql delete statement ? : Sql dba
Are left and right joins the same?
what is primary key? : Sql dba
How many sql commands are there?
What is coalesce in sql?
What is the process of debugging?
what is 'mysqldump'? : Sql dba
how to enter characters as hex numbers? : Sql dba
What is raid? How does it help storage of databases?
what are the advantages and disadvantages of views in a database? : Sql dba
What are the types of operators available in sql?