How to get the first 255 characters?

Ranch Hand

Posts: 32

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi friends!
I hava a column type containning more than 1000 characters in Oracle. I would like to get the first 255 characters in this column. Could any one pls tell me the way?
Thanks in advanced

Jamie Robertson

Ranch Hand

Posts: 1879

I like...

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

if column1 is 1000 characters and you only want 255:
select substr(column1, 1, 255) from table
Jamie

It's a tiny ad. At least, that's what she said.

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders