a procedure one in two out parameters i am waiting it in a
sql query can i get the output
Answer Posted / aurobinda
yes ,we can
create or replace procedure (v_empno in emp.empno%
type,v_ename out emp.ename%type,v_sal out emp.sal%type)
is
begin
select ename,sal into v_ename,v_sal from emp
where empno =v_empno);
dbms_output.put_line(v_ename||' '||v_sal);
end;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
how to present a past time in hours, minutes and seconds? : Sql dba
What are the operators used in select statements?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
How many triggers can be applied on a table?
What is the difference between python and sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
how many values can the set function of mysql take? : Sql dba
Where can I learn sql for free?
What are the two virtual tables available at the time of database trigger execution?
what is a composite key ? : Sql dba
what is 'mysqlimport'? : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Why do we use procedures in sql?
What is the life of an sql statement?