This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes How to get the first 255 characters? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to get the first 255 characters?" Watch "How to get the first 255 characters?" New topic
Author

How to get the first 255 characters?

lu v thuan
Ranch Hand

Joined: Oct 25, 2001
Posts: 32
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

Joined: Jul 09, 2001
Posts: 1879

if column1 is 1000 characters and you only want 255:
select substr(column1, 1, 255) from table
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to get the first 255 characters?
 
Similar Threads
max length of doGet() request supported by browser
JDK TOOLS & UNICODE
JBoss/Oracle data corruption
What is the maximum limit of data can be send to the sever using GET method???
PreparedStatement.toString()