--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