---
title: "How to Display all views on oracle database?"  
description: "How to Display all views on oracle database?"  
author: "Utpal Vishwas"  
published: 2023-07-17  
updated: 2023-07-18  
canonical: https://www.mindstick.com/forum/159129/how-to-display-all-views-on-oracle-database  
category: "oracle"  
tags: ["database", "view", "oracle"]  
reading_time: 2 minutes  

---

# How to Display all views on oracle database?

How to Display all [views](https://www.mindstick.com/forum/12838/compile-views-in-asp-dot-net-mvc) on [oracle database](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database)?

## Replies

### Reply by Aryan Kumar

Sure, here is how you can display all views on [Oracle](https://www.mindstick.com/articles/13016/alter-table-statement-or-command-in-oracle) [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax):

SQL

```plaintext
SELECT view_name
FROM user_views;
```

This query will select all views in the current user's schema. The `user_views` view is a data dictionary view that contains information about all of the views in the schema.

The `view_name` column contains the name of the view.

To run this query, you will need to connect to the Oracle database using a tool like SQL*Plus. Once you are connected, you can run the query by typing it into the SQL*Plus prompt.

For example, to run the query above, you would type the following into the SQL*Plus prompt:

SQL

```plaintext
SELECT view_name
FROM user_views;
```

This would return a list of all views in the current user's schema.

You can also use the `all_views` view to list all views in the database, including views that are owned by other users.

Here is the syntax for the `all_views` view:

SQL

```plaintext
SELECT view_name
FROM all_views;
```

To run this query, you will need to have the `DBA` role or be granted the `SELECT` privilege on the `all_views` view.


---

Original Source: https://www.mindstick.com/forum/159129/how-to-display-all-views-on-oracle-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.