Max length of String datatype in Oracle 10G

Can some one please let me know the max length that String datatype supports in Oracle 10G.
ria_19Asked:
Who is Participating?
 
DrunkenELFConnect With a Mentor Commented:
Dear Ria,
Try the below link..
http://download.oracle.com/docs/html/B10538_01/apa.htm
 Cheers!
D-ELF
0
 
SujithConnect With a Mentor Data ArchitectCommented:
On a database column 4000 bytes.
In pl/sql code : 32K bytes.

You may take a look at this link as well.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits.htm#i287876
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.