Answer Posted / sakthivel

NO,we cannot use inout,out parameters in functions. so
function must return one value

Is pl sql and postgresql same?

563

---

Why do we use function in pl sql?

553

---

Is left join inner or outer by default?

521

---

How do I view tables in sql developer?

510

---

What do you understand by pl/sql records?

528

---

---

What is int identity in sql?

569

---

What is a native sql query?

488

---

Differentiate between pl/sql and sql?

613

---

What is trigger types in sql?

529

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2001

---

How many types of triggers exist in pl/sql?

561

---

Explain two easy sql optimizations.

600

---

what are the advantages and disadvantages of views in a database? : Sql dba

529

---

What is PL/SQL Records?

620

---

What is the use of function in sql?

529

---