Home » RDBMS Server » Server Administration » upper
upper [message #374356] Thu, 07 June 2001 12:39
nandakumar
Messages: 5
Registered: October 2000
Junior Member
hi

is there any way to enforce conversion of data to upper case at the DDL definition of table?

something like ...

create table xyz ( three_letter_code varchar2(1) 'upper(three_letter_code)');

This could help
a) ensure data gets stored in uppercase
b) get rid of the upper() function from the applications.

Thanks

Report message to a moderator

Previous Topic: getting there
Next Topic: Synonm Creation Script
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 23 19:28:23 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.