Avatar of kingno1

asked on 

SQL to get list all all schema, tables, columns in oracle

Hello, I have an oracle instance named CORPOR.
I need to get a listing of all schemas, the tables underneath it and their columns as a listing. Can you please help me generate a SQL for this?
I deally it should be like
Schema   Table   Column
TEST       USER  FirstName
Test        USER    LastName
Oracle Database

Avatar of undefined
Last Comment

8/22/2022 - Mon