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;

how can you see all indexes defined for a table? : Sql dba

1002

---

Explain the difference between drop and truncate commands in sql?

1060

---

Is a view faster than a stored procedure?

976

---

What is example of database?

1062

---

How do you rank data in sql?

1009

---

Is sql developer case sensitive?

1005

---

What is an inner join sql?

1036

---

What is a join query?

970

---

How to revise and re-run the last sql command?

1169

---

how to calculate the difference between two dates? : Sql dba

1065

---

How do you optimize a stored procedure in sql?

964

---

how to get @@error and @@rowcount at the same time? : Sql dba

1033

---

How do I edit a trigger in sql developer?

1002

---

What is the default isolation level in sql server? : Transact sql

1035

---

what are the advantages of sql ? : Sql dba

1063

---