Listar las tablas de Oracle de una base datos



--revisión de tablas
SELECT TABLE_NAME FROM USER_TABLES;

select table_name, column_name "Campo", data_type "Tipo de dato",
data_length "Tamaño", nullable "Permite nulos"
from all_tab_columns WHERE OWNER='IEPQEPQ1' ORDER BY table_name, COLUMN_ID ASC

select * from all_tab_columns WHERE OWNER='IEPQEPQ1' ORDER BY table_name, COLUMN_ID ASC
--where table_name = 'TDE_CUENTA'

No hay comentarios:

Publicar un comentario