Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing Data To Uppercase
- Thread starter FontanaS
- Start date
Well, you could do something like this:
update table_name
set column_name = upper (column_name)
If the table is really huge, you'll need to break this up into blocks and you'll need to consider setting the log to truncate on checkpoint.
HTH,
John
J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net
update table_name
set column_name = upper (column_name)
If the table is really huge, you'll need to break this up into blocks and you'll need to consider setting the log to truncate on checkpoint.
HTH,
John
J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question