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 sql stand for?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
What are literals in sql server?
What is pl sql script?
What types of commands can be executed in sql*plus?
wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh
What is pl/sql tables?
How do I run a pl sql procedure in sql developer?
How to run sql commands in sql*plus?
what is datawarehouse? : Sql dba
What are the different dcl commands in sql?
What are sql queries used for?
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)