List of tables in an Oracle database

List of tables :

SELECT * from CAT;

description of a table :

DESC tablename;

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

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

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" 

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!

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

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

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

See you!

Hello,

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

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.