This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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
Author

Varchar2 - Size

sudha swami
Ranch Hand

Joined: Apr 24, 2007
Posts: 186
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: 1082

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
 
It's not a secret anymore!