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 enter characters as hex numbers? : Sql dba

1025

---

What is the use of stored procedures?

1025

---

What are the advantages of sql? Explain

1083

---

What is type and rowtype in pl sql?

1008

---

Does mysql_real_escape_string prevent sql injection?

938

---

What is the difference between a procedure and a function?

1084

---

Is sql a programming?

962

---

How show all rows in sql?

998

---

What is an oracle stored procedure?

1029

---

What is substitution variable in pl sql?

1027

---

Explain normalization and what are the advantages of it?

939

---

Explain the methods used to protect source code of pl/sql.

1007

---

Are subqueries faster than joins?

995

---

Is sqlite thread safe?

1033

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3991

---