Answer Posted / roopesh kumar

(1) Procedure may or may not return value but function
should.

(2) We can't call a procedure inside a sql stmt but
function can.

Can a foreign key be null?

809

---

What is the starting oracle error number?

751

---

What are sql data types?

743

---

What are the basic sql commands?

741

---

What is the maximum number of columns in sql table?

777

---

---

Is it possible to create startup or shutdown trigger for on-schema?

777

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

812

---

What does <> sql mean?

707

---

What is pl sql package?

792

---

What view means?

730

---

How do I edit a trigger in sql developer?

703

---

how to convert dates to character strings? : Sql dba

729

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

836

---

What are records give examples?

741

---

Why commit is not used in triggers?

771

---