There are two types of views in Oracle based upon from how many tables data are being fetched.
1. Simple view - In this view, data is coming from only one table.
2. Complex view - In this view, data comes from more than one table.
That's it.
However, Complex views have some limitations. For these follow Oracle documentation.
Copyright © 2026 eLLeNow.com All Rights Reserved.