Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change the values to fit the column size

978734Dec 14 2012 — edited Dec 14 2012
Some of the values stored in a VIEW is longer than varchar2 size. I want to create a table with a column with the data type as varchar2. When I try to create this table with that column in VIEW, I get the error that the "character string buffer too small". Is it possible to compress or truncate the values to fit the column size?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2013
Added on Dec 14 2012
#general-database-discussions, #oracle, #sql
1 comment
180 views