What object do you request to select all table names in a schema in Oracle?
To view all the tables that you have access to
select table_name from all_tables where owner='<SCHEMA>';
To select all tables for the current input schema (e.g. your tables)
select table_name from user_tables;
which you are looking for:
you can use
select tab tab from
to get the name of the tables present in the schema.
Source: https://habr.com/ru/post/1696743/More articles:Average user download speed - performanceSearch by hash? - searchApplication Testing - tddUsing strings in XML literals - xmlSQL: aggregate function and group - sqlLegacy Single Sign-On Strategy - integrationChecking the network status and monitoring PPP in the program - cHow to place licensed .Net elements in an unmanaged C ++ application? - c ++What is a managed way to store emails for extended periods of time? - backupFinding unused files in a project - c ++All Articles