This can be accomplished with a simple SELECT query on the USER_TABLES data dictionary. Viewing Tables Owned by Current userĪt the most basic level, you may wish to view a list of all the tables owned by the current Oracle user. Repeat the same for other tables you wish to. In the Connections navigator in SQL Developer, navigate to the Tables node for the schema that includes the table you want to display. Show tables owned by the current user To show tables owned by the current user, you query from the usertables view. However, you can list all tables in a database by querying from various data dictionary views. The values in these stored dictionaries are updated automatically by Oracle anytime a statement is executed on the server that modifies data.įrom there, the read-only dictionaries can be read and queried just like any standard table, which as we’ll see below provides some very useful functionality. After a table is opened in a tab, pin it ( ie, click on pin ) to freeze the view of the table on that tab. Unfortunately, Oracle does not directly support the SHOW TABLES command. What are Oracle Data Dictionaries?Ī data dictionary in Oracle is a collection of read-only tables that provide useful information about the database including schemas, users, privileges, and even auditing data. Or like someone has offered, write query or use the provided SP that MSFT gives you. The best we have to offer you is, open the table from your browser, and see the Columns page. Thankfully, there are multiple ways to perform this relatively simple task in Oracle, so we’ll briefly explore each option below to find which best suits your needs. DESC is an Oracle client command - works in SQLPlus, SQLcl, and SQL Developer - WHEN connected to an Oracle Database. In the object pane, click the Data subtab. Mouse Right Click your table trees node and Select Apply Filter and check Include Synonyms. In SQL Developer, search for a table as described in Viewing Tables. As with most relational databases, there may come a situation where you need to view the the underlying metadata and look through the actual table list and ownership of your database. I wanted to provide another option to view the filtered tables.
0 Comments
Leave a Reply. |