Answer / parivesh sinha

yes.

create or replace function p_tst (v_p out varchar2) return
varchar as
v_g varchar2(50);
begin
select ENAME2 into v_p from emp where empno='11';
return v_p;
end;

Answer / sanket

Actual parameter:Actual parameter is a parameter which are
actually pass to the procedure or function.
Formal parameter:Formal parameter is a parameter which we
are defining while declaring procedure.

Answer / mahesh

wht is actaul and formal parameters and wht is the main
difference
can any one knows this answer kindly inform me

Answer / friend

Actual parameter:these are the parameters where we use in
exection of a procedure
Formal parameter:these are the parameters where we use as
in and out parameters

What is sql injection owasp?

0 Answers  

---

How many developers work on postgresql?

0 Answers  

---

Explain the concept of normalization.

3 Answers  

---

Can a commit statement be executed as part of a trigger?

0 Answers  

---

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

Why do we need unique key in a table?

0 Answers  

---

What is a memo field?

0 Answers  

---

Which sorts rows in sql?

0 Answers  

---

How to select unique records from a table?

0 Answers  

---

How can a pl sql block be executed?

0 Answers  

---

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---