A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
How to get the first 255 characters?
lu v thuan
Joined: Oct 25, 2001
Nov 28, 2001 00:46:00
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
Joined: Jul 09, 2001
Nov 28, 2001 10:03:00
if column1 is 1000 characters and you only want 255:
select substr(column1, 1, 255) from table
I agree. Here's the link:
subject: How to get the first 255 characters?
JBoss/Oracle data corruption
What is the maximum limit of data can be send to the sever using GET method???
JDK TOOLS & UNICODE
max length of doGet() request supported by browser
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014