Hi Friends,
How do I put contraints on my NAME column on EMP table so that all
the data saved are all CAPS?
Is this the correct syntax?:)
allter table EMP modify(NAME check upper(NAME));
or
allter table EMP modify(NAME default upper(trim(NAME)));
Thanks