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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are user defined stored procedures ?

Question Posted / anbu

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 different parts of a package?

1117

Is record in oracle pl sql?

970

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1007

Why do we use set serveroutput on?

973

What do you mean by rowid?

983

tell me about various levels of constraint. : Sql dba

1035

how to use case expression? : Sql dba

1031

how to show all tables with 'mysql'? : Sql dba

1120

What is recursive join in sql?

1031

What is sql catalog?

1028

Can sql developer connect to db2?

1056

Is foreign key mandatory?

1011

How do you write a complex sql query?

1092

What is the purpose of the partition table?

1049

What is view explain with example?

937