This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Use of Stored Procedures and Views Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Use of Stored Procedures and Views" Watch "Use of Stored Procedures and Views" New topic

Use of Stored Procedures and Views

anuj thite
Ranch Hand

Joined: Apr 14, 2009
Posts: 49

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

Joined: Sep 27, 2004
Posts: 303
Please refer to the following link for views:

SCJP 1.4, SCWCD 1.4<br /> <br />Thanks in advance!<br />Jayashree.
I agree. Here's the link:
subject: Use of Stored Procedures and Views
It's not a secret anymore!