Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are user defined stored procedures ?

Answer Posted / anbu

Stored procedures is like a simple PLSQL/instructions
programme which can perform desired operation to get the
exact output from the oracle server(if the DB is oracle).
The user defined stored proceture can be created by users
and they can use funtions,procedure and packages to get the
output from the database engine.
The next thing is they can call it at any part in the
main programme.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1393


What is recursive stored procedure?

1141


how to shutdown mysql server? : Sql dba

1144


Can we write ddl statements in functions?

1182


What is range partitioning?

1014


Does oracle use sql?

991


What is the life of an sql statement?

1074


Which are the different character-manipulation functions in sql?

1110


What is equi join in sql?

1118


Can we insert data into view?

949


How to raise user-defined exception with custom sqlerrm ?

1178


Why do we use joins?

1097


Which is better varchar or nvarchar?

1050


What is clustered and nonclustered index in sql?

985


What is dense_rank in sql?

1036