Answer / lavanya

functions:
1.The parameters are input values and output values
2.The functions will return a value
3.The functions will be called with in sql

Procedures:
1.The parameters are input values and output values
2.The procedures will not return any value
3.The procedures will not be called with in sql

Answer / iamanocp

Proceure performs an action and function returns a value.
Both have different syntax for creation. Fucntion has
RETURN clause in its declaration.

What is the use of stored procedures?

0 Answers  

---

Can we create foreign key without primary key?

0 Answers  

---

What is pivot in sql?

0 Answers  

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

What do you understand by pl/sql packages?

0 Answers  

---

What is the use of %rowtype?

0 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

can i give user defined exception in a package

2 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---