create or replace view DICT_MINUSCULE
as
select lower(TABLE_NAME) as TAB, lower(COMMENTS) as COMS from DICTIONARY;
grant select on DICT_MINUSCULE to public;
create or replace view DICT_COLS_MINUSCULE
as
select lower(TABLE_NAME) as TAB
, lower(COLUMN_NAME) as COL
, lower(COMMENTS) as COMS
from DICT_COLUMNS;
grant select on DICT_COLS_MINUSCULE to public;
Dienstag, 7. Juni 2016
Wrapper over the dict tables to make the content lower case
Abonnieren
Kommentare zum Post (Atom)
Keine Kommentare:
Kommentar veröffentlichen