Answer Posted / srinu

Yes u r correct Swapna,But if we want 2 get the source code
of stored procedure,function,trigger or package ten the
query is......
SELECT text
FROM USER_SOURCE
WHERE NAME='PROCEDURE_NAME/FUNCTION_NAME/TRIGGER_NAME';

How do I remove sql developer from windows 10?

1072

---

Can we enter data in a table in design view?

948

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1058

---

Explain two easy sql optimizations.

994

---

What is clause?

1124

---

What are the types of index in sql?

1048

---

What is the clause we need to add in function body to return variable?

997

---

What is a constraint?

997

---

Can a foreign key have a different name?

932

---

How many types of primary keys are there?

1017

---

What is trigger and how to use it in sql?

1006

---

What does select count (*) mean in sql?

1004

---

Could you please provide oca (oracle 10g) dumps for my certification ?

5124

---

Is sql sequential or random?

1010

---

Where can I learn sql for free?

977

---