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

What are the subsets of sql?

1133


define join and explain different type of joins? : Sql dba

952


What is sql deadlock?

1138


What is the difference between left join and right join?

942


What is data profiling in sql?

1076


What is use of package in pl sql?

1013


What do we need to check in database testing?

1017


What is the difference between subquery and correlated query?

1065


What is scope of pl sql developer in future?

1018


What is the reports view in oracle sql developer?

990


Why do we go for stored procedures?

1057


What is the use of sql trace?

952


Why do we use joins in sql?

970


Is a view faster than a stored procedure?

969


What is error ora-01000: maximum open cursors exceeded

1145