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 sql used for?

0 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

What is scope of pl sql developer in future?

0 Answers  

---

What is primary key and foreign key with example?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

---

What are different types of sql?

0 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

Explain the rollback statement?

0 Answers  

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

..........refers to the disk mirroring

2 Answers   iFlex,

---

How do I find duplicates in a single column in sql?

0 Answers  

---

Can we use loop in sql?

0 Answers  

---