Answer / 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];

Answer / tulsi

FUNCTION name (argument list .....) Return datatype is
local variable declarations
Begin
executable statements
Exception
execution handlers
End;

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

Which software is used for pl sql programming?

0 Answers  

---

What are the two types of exceptions in pl/sql?

0 Answers  

---

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

---

What is a sql select statement?

0 Answers  

---

What is normalization in a database?

0 Answers  

---

What is the difference between function, procedure and package in pl/sql?

0 Answers  

---

How does sql store data?

0 Answers  

---

what is meant by tuning and tk proof?

2 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

what is a constraint? : Sql dba

0 Answers  

---