Answer / kiran

CREATE [OR REPLACE] FUNCTION function_name
[(parameter_name [IN | OUT | IN OUT] type [, ...])]
RETURN return_datatype
{IS | AS}
BEGIN
< function_body >
Return value()
END [function_name];

Answer / tulsi

FUNCTION name (argument list .....) Return datatype is
local variable declarations
Begin
executable statements
Exception
execution handlers
End;

What is oracle sql called?

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

Enlist some predefined exceptions?

0 Answers  

---

What pl/sql package consists of?

0 Answers  

---

How to remove duplicate rows from a table?.

3 Answers  

---

---

How do I truncate a word?

0 Answers  

---

what is row? : Sql dba

0 Answers  

---

how would you get the current date in mysql? : Sql dba

0 Answers  

---

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

---

Is left join and outer join same?

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---