Answer Posted / 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];

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

871

---

What is scope of pl sql developer in future?

783

---

What is sql lookup?

706

---

What is sql stand for?

781

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

728

---

Describe types of sql statements?

767

---

What is scalar function?

800

---

How many sectors are in a partition?

785

---

What is before and after trigger?

719

---

How can a pl sql block be executed?

721

---

how to start mysql server? : Sql dba

909

---

How show all rows in sql?

829

---

Explain polymorphism in pl/sql.

856

---

What are the uses of merge?

938

---

What do you understand by exception handling in pl/sql?

789

---