View Vs. Stored Procedure

Differences :

  1. View does not accepts parameters while SP takes parameters.
  2. View contain only one single query while SP contain several statements like conditional , loop etc.
  3. Can not perform modification in any table (DDL Statement) while SP can do this.
  4. View is nothing but an imaginary table. It contains data at run time only not created in the database where as stored procedure can be used to store business logic.It is created at database level.Main difference is stored procedure exits in database where as view does not exits in database.
Advertisements

2 thoughts on “View Vs. Stored Procedure

  1. ketan

    Main difference is stored procedure exits in database where as view does not exits in database.

    what is that means Dhaval u talking about data dictionary?

    by using data dictionary user_views we can see it.

    I dont understand your above words.

    Thanks
    ketan

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s