Give the structure of the function ?
Answers were Sorted based on User's Feedback
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];
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / tulsi
FUNCTION name (argument list .....) Return datatype is
local variable declarations
Begin
executable statements
Exception
execution handlers
End;
| Is This Answer Correct ? | 2 Yes | 2 No |
what is the difference between a web-garden and a web-farm? : Sql dba
Which software is used for pl sql programming?
What are the two types of exceptions in pl/sql?
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?
What is normalization in a database?
What is the difference between function, procedure and package in pl/sql?
How does sql store data?
what is meant by tuning and tk proof?
Name the different types of indexes in sql and define them.
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
what is a constraint? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)