Home » SQL & PL/SQL » SQL & PL/SQL » Re: wild card filtering
Re: wild card filtering [message #1624] Thu, 16 May 2002 08:11
John R
Messages: 156
Registered: March 2000
Senior Member
If the column is a char(n) then use
ALTER TABLE table_name MODIFY column_name VARCHAR2(n)

When you've changed all the column types, you'll need to get rid of the trailing spaces.

UPDATE table_name
SET column_name = rtrim(column_name);

Report message to a moderator

Previous Topic: sql query problem
Next Topic: Re: Need to implement this business rule for triggers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 10 07:11:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.