what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?
- 3 Answers
- 6718 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / gavini srikanth
function can return value,procedure may or may not return
value,through procedures can store images
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What types of commands can be executed in sql*plus?
Explain the difference between 'between' & 'and' operators in sql
is it possible to pass an object or table to a procedure as an argument?
what is data manipulation language? : Sql dba
What are pl sql data types?
How to select unique records from a table?
What is the source code of a program?
Is sql dba a good career? : SQL DBA
What is the importance of sqlcode and sqlerrm?
Why do we use triggers?
what is difference between delete and truncate commands? : Sql dba
What is serial sql?
What is an exception in PL/SQL? What are the two types of exceptions?
What does bitemporal mean?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
