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 view means?

977

---

What is cursor status?

1186

---

What is the difference between subquery and correlated query?

1065

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1029

---

How do you respond to dementia behavior?

969

---

What are the different datatypes available in PL/SQL?

1085

---

What is cursor and why it is required?

1183

---

How to change the order of columns in Oracle SQL Plus ?

1058

---

How many sql statements are used?

1010

---

How does cross join work in sql?

1016

---

Does sql support programming?

1070

---

Which join is like inner join?

1027

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1596

---

What are the different set operators available in sql?

1026

---

what is a composite key ? : Sql dba

1059

---