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 Varchar2 - Size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Varchar2 - Size" Watch "Varchar2 - Size" New topic
Author

Varchar2 - Size

sudha swami
Ranch Hand

Joined: Apr 24, 2007
Posts: 179
Hi,
i want to store 1000 characters in the varchar2 datatype in the oracle database, Do i need to specify the varchar2(1000)?

regards
sudha
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

What else are you thinking to do ??


Thanks,
Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Sripathi Krishnamurthy
Ranch Hand

Joined: Mar 07, 2005
Posts: 232
keep this for your reference

http://www.ss64.com/orasyntax/datatypes.html
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Varchar2 - Size
 
Similar Threads
unable to use identity columns
not able to use identity attribute in oracle
how to use rowid to update records in oracle database
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
passing arrays to oracle