How to list all tables in an Oracle Database

preview_player
Показать описание
we will see how to list tables using 3 views

the dba_tables view
the all_tables view
the user_tables view
Рекомендации по теме
Комментарии
Автор

Hi, Great video.

Why is Oracle SQL so complicated? This is 2024 for heaven's sake. I only want a list of tables I created for my project. I do this in MySQL & MS sequel server. But if I try to achieve the same thing in Oracle SQL I get bombarded with over a 100 list of tables I didn't create.

Is there a way I can return a result that shows "only" the names tables I created?

obotgabriel