a procedure one in two out parameters i am waiting it in a
sql query can i get the output
Answer / 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 |
Can I create table without primary key?
How to perform a loop through all tables in pl/sql?
What is sql*loader and what is it used for?
What are the different tcl commands in sql?
Can we perform dml in function?
What is the example of procedure?
What is delimiter in pl sql?
Explain the working of foreign key?
How can I change database name in sql?
what is an alias command? : Sql dba
Can we use more than one null value for unique key?
31 Answers A1 Technology, Wipro,
i need department wise top 2 employees salary.which logic i will use
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)