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 to present a past time in hours, minutes and seconds? : Sql dba

1003

---

What are the operators used in select statements?

1051

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1051

---

How many triggers can be applied on a table?

928

---

What is the difference between python and sql?

989

---

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 ?

1020

---

how many values can the set function of mysql take? : Sql dba

977

---

Where can I learn sql for free?

980

---

What are the two virtual tables available at the time of database trigger execution?

1215

---

what is a composite key ? : Sql dba

1043

---

what is 'mysqlimport'? : Sql dba

1039

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1002

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1100

---

Why do we use procedures in sql?

1068

---

What is the life of an sql statement?

1013

---