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];

What is pl sql variable?

938

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2414

---

How much does sql cost?

931

---

What is a database? Explain

1053

---

What is java sql drivermanager?

1023

---

What is the difference between inner join and natural join?

956

---

Is there a 64 bit version of ssms?

896

---

What are all ddl commands?

1015

---

What are records give examples?

954

---

Is the primary key an index?

982

---

Which is faster subquery or join?

1148

---

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..

2451

---

Explain the uses of control file.

994

---

Is left join faster than join?

985

---

Why do we need cursor in pl sql?

1080

---