Interested to Buy Any Domain ? << Click Here >> for more details...
List the differences between plsql - function & procedures
- 2 Answers
- 7417 Views
- TCS, Verizon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / iamanocp
Proceure performs an action and function returns a value.
Both have different syntax for creation. Fucntion has
RETURN clause in its declaration.
| Is This Answer Correct ? | 2 Yes | 1 No |
Can we insert delete data in view?
How do you run a query?
what is bcp? When is it used?
How to update salary of employees department wise?
what are the performance and scalability characteristics of mysql? : Sql dba
What type of database is sql?
What are the different dcl commands in sql?
What are different types of indexes?
What is the difference between microsoft access and sql?
what is the use of double ampersand (&&) in sql queries?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is a sql statement?
-
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)
