Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
- 5 Answers
- 13140 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / scorpio.mishra
1->stored procedure can not be written as a column name but
function can be written as a column name
2->result set of stored procedure can not be used in
joining tables but table return by function can be used in
joins
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / darshan shah
SP may return value or may not ,function always treturn
value.
SP cannot use in sselect statment or in sql stattment ,We
can use Function in any where in sql statment.
Packeage is set of statment,SP,Function Which run one by
one statment in that.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pratap557
In general SPs are sequential block of PL/SQL for
Transaction
Func are used for specific calculation / selection
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / bunty_18
1>Stored procedure is pre-executed block of code whereas
function is not.
2>Stored procedure may return zero,one or more than one value
whereas function always return one and only one value..
3>We can use try catch block in stored procedure whereas
function doesn't support try catch block...
4>We can't use stored procedure in select statement whereas we
use function in select statement..
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / pratap557
We cannot write DML in Function whereas in SPs we can
| Is This Answer Correct ? | 0 Yes | 3 No |
What are the advantages dts has over bcp?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What is cube dimension? : sql server analysis services, ssas
Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s
What is the difference between varchar and nvarchar datatypes?
What is an inner join?
What is meant by dirty read?
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records
how to use DTS package in 2000,2005,2008 in sql server
What is data block and how to define data block size?
What is entity data services?
Can we store videos inside the sql server table?
-
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)
