How many types of view in oracle?

1 answer

Answer

1247548

2026-05-20 14:35

+ Follow

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.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.