List of tables in an Oracle database Solved

Question

```sql
SELECT table_name FROM user_tables;
```

blux · Accepted Answer

Hi,

List the tables in the current user's schema:

SELECT table_name FROM user_tables;

List the tables accessible by the user:

SELECT table_name FROM all_tables;

List all tables (you need to be ADMIN):

SELECT table_name FROM dba_tables;

Talk to you later, Blux

 "Stupid people dare to do anything. That's even how you recognize them"

hasendan · Answer

Hi You don't have the option to install Toad (free version)   See you!

Titelle · Answer

No, I can't install what I want on my computer.

Paul-Henri · Answer

Thank you for the tip, and how can we sort them by the date of the last modification? Thank you in advance.

blux · Answer

If this is the date of data modifications, I don't know!
For the rest, I don't exactly know the structure of user_tables, but you can run select * from user_tables;

It will return an impressive number of columns; it would be surprising if you didn't have a last modification date! ;-)

See you later, Blux

 "Fools dare to do anything. That's how you recognize them"

hbo · Answer

Dear friend,

USER_TABLES, ALL_TABLES, or DBA_TABLES only provides the date of the last analysis performed on the table (LAST_ANALYZED)

ALL_OBJECTS, which references all the objects in your database, gives you that famous update date. For example: if you want the update date (the date of the last modification in terms of structure) of the table 'TABLE_1', here's how to do it:

SELECT last_ddl_time FROM all_objects where object_name = 'TABLE_1';

There you go

See you later!

siddharta · Answer

```sql
SELECT table_name, column_name, data_type 
FROM all_tab_columns 
WHERE owner = 'NOM_DU_SCHEMAC';
```

badr · Answer

Je rencontre un problème d'extraction de tableau Oracle. Que dois-je faire sachant que je suis encore débutant avec Oracle ? Merci de m'aider.

ecco · Answer

Hello  select table_name from tabs;  it works too -- love gives you a second life; the key is knowing how to seize it and making sure to keep it

christopher · Answer

Hello,  What are the names of the tables and fields in the Oracle software to create an invoice? Thank you in advance.

Sylvain · Answer

List of tables :  SELECT * from CAT;  description of a table :  DESC tablename;

List of tables in an Oracle database

11 réponses

Windows spotlight is not working.

Masked destination layer

Samsung j5 unable to answer

Scam of the suvedene highway

File name too long

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message