Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8091 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / dinakar
Though Procedure returns a value through OUT parameter, it
cannot be used in SELECCT statement. Whereas a function can
be called in SELECT statement.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is sqlservr exe?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Enlist the data types that can be used in pl/sql?
Can we use update in sql function?
how many values can the set function of mysql take? : Sql dba
How do you create a unique index?
Can we call dml statement in function?
Does sql support programming?
Can we insert in sql function?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Explain the difference between sql and mysql.
Can we commit in trigger?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is pivot in sql?
Can we join same table in sql?
