oracle – Seznam sloupců tabulky (pohledu) a jejich vlastností
SELECT *
FROM
ALL_TAB_COLS
WHERE
TABLE_NAME = 'jmeno_tabulky_nebo_pohledu'
AND OWNER = 'vlastnik'
ORDER BY
COLUMN_NAME
SELECT *
FROM
ALL_TAB_COLS
WHERE
TABLE_NAME = 'jmeno_tabulky_nebo_pohledu'
AND OWNER = 'vlastnik'
ORDER BY
COLUMN_NAME