Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Use of Stored Procedures and Views

 
anuj thite
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Hello all Forum Members,

I am new to Oracle & RDBMS (in learning phase).

Query that i wish to post here is,

I don't know where (means, in which cases) views and procedures should be used?

I don't know how they improve performance?

please explain it to me by giving some examples.

Can i use them for login, Registration purpose?

Thanks in advance.
 
JayaSiji Gopal
Ranch Hand
Posts: 303
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please refer to the following link for views:

http://www.dba-oracle.com/concepts/views.htm

http://stackoverflow.com/questions/462978/when-should-you-use-stored-procedures
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic