Answer Posted / guest

Hi,

Basic Difference is Function must return a value and
Procedure can or cannot return a value using out parameter.



Thanks!

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1043

---

What is compound trigger?

959

---

What is sql lookup?

864

---

Explain the significance of the & and && operators in pl sql.

950

---

How many tables can a sql database have?

925

---

How do you pronounce sql?

955

---

Is sql open source?

915

---

What does t sql mean?

896

---

What is cascade in sql?

914

---

What is a temporal table?

881

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

899

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2021

---

What is primary key and foreign key?

916

---

How do I upgrade sql?

947

---

Is sql workbench free?

930

---