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 left join faster than join?

0 Answers  

---

How can you view the errors encountered in a trigger?

0 Answers  

---

What is benefit of creating memory optimized table?

0 Answers  

---

What is mutating table error?

0 Answers  

---

What does an inner join do?

0 Answers  

---

How sql query is executed?

0 Answers  

---

What is execute immediate?

0 Answers  

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

what is check constraint? : Sql dba

1 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---