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 many types of literals are available in pl sql?

516

---

How can we find duplicate records in a table?

514

---

what is the difference between truncate and delete statement? : Transact sql

550

---

Can I create table without primary key?

531

---

what are dynamic queries in t-sql? : Transact sql

559

---

---

How do I debug a stored procedure?

629

---

What is rename in sql?

552

---

How to install oracle sql developer?

567

---

How to use boolean type in select statement?

583

---

What does pl sql stand for?

655

---

Explain commit, rollback and savepoint.

605

---

what is sql profiler? : Sql dba

590

---

What is the purpose of a secondary key?

508

---

How to know the last executed procedure?

589

---

How to run sql commands in sql*plus?

589

---