File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
JBoss/Oracle data corruption
What is the maximum limit of data can be send to the sever using GET method???
max length of doGet() request supported by browser
JDK TOOLS & UNICODE
PreparedStatement.toString()