Forum

Can we join view wi...
 
Share:
Notifications
Clear all

Can we join view with table in oracle?

4 Posts
3 Users
0 Likes
693 Views
KV Kumar
Posts: 27
Admin
Topic starter
(@vinodkrsetty)
Eminent Member
Joined: 3 years ago

Please answer to this question

Topic Tags
3 Replies
Info User Ans
Posts: 36
 Info User Ans
Guest
(@Info User Ans)
Eminent Member
Joined: 2 years ago

Yes.  Consider view as a table and have a condition. 

The view is also a table,  it is usually derived from two or more tables.  

As long as you have a proper joining column,  you can join with any related table in the structure.  No issues. 

Reply
VK
Posts: 18
 VK
(@vinodkrsetty5895)
Active Member
Joined: 2 years ago

A view is a virtual table in the database and it can be derived from two or more tables.

Instead of writing complex queries every time we can store SQL in the view and can utilize it whenever is needed. 

We can also join view with a table when we have a proper join column. 

Views can improve the query performance. 

Reply
KV Kumar
Posts: 27
Admin
Topic starter
(@vinodkrsetty)
Eminent Member
Joined: 3 years ago

Here is an example, I have attached the image for our better understanding.

Hope this will also helful SQL Joins With Practical Examples. 

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: