Each PL/SQL subprogram has a name, and may also have a parameter list. I am trying to determine what privilege is giving this user/developer access to the other schemas in 10g and not 11g as viewed through sql developer. The privileges in 11g are for the same developer and are similar to the above. This can be accomplished with a simple SELECT query on the USER_TABLES data dictionary. We will discuss PL/SQL function in the next chapter. The privileges listed above are the only privileges this developer has. See Section 13.2.10.3, UNION Clause, and. 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. SELECT is used to retrieve rows selected from one or more tables, and can include UNION statements and subqueries. 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. Oracle Show Tables SHOW TABLES SELECT tablename FROM usertables ORDER BY tablename SELECT tablename FROM alltables ORDER BY tablename SELECT FROM. When DML changes are made to master table data, Oracle Database stores rows describing those changes in the materialized view log and then uses the materialized. 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. 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. Mouse Right Click your table trees node and Select Apply Filter and check Include Synonyms. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |