File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "Varchar2 - Size" Watch "Varchar2 - Size" New topic

Varchar2 - Size

sudha swami
Ranch Hand

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

Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1082

What else are you thinking to do ??


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
I agree. Here's the link:
subject: Varchar2 - Size
It's not a secret anymore!