*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
passing arrays to oracle
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
not able to use identity attribute in oracle
unable to use identity columns
how to use rowid to update records in oracle database