Home » SQL & PL/SQL » SQL & PL/SQL » VARCHAR2 Size
VARCHAR2 Size [message #36301] Thu, 15 November 2001 00:35 Go to next message
Rajarshi Dasgupta
Messages: 52
Registered: October 2001
Member
What is maximum size of VARCHAR2 variable in a PL/SQL block... i.e. how many characters I can define maximum while defining the variable?

----------------------------------------------------------------------
Re: VARCHAR2 Size [message #36302 is a reply to message #36301] Thu, 15 November 2001 01:11 Go to previous messageGo to next message
Malli
Messages: 10
Registered: November 2001
Junior Member
Varchar2 Variable max size is 32767.

----------------------------------------------------------------------
Re: VARCHAR2 Size [message #37032 is a reply to message #36301] Fri, 11 January 2002 00:56 Go to previous messageGo to next message
ARAVIND KUMAR
Messages: 1
Registered: January 2002
Junior Member
How many characters varchar2 data type will take maximum
Re: VARCHAR2 Size [message #37044 is a reply to message #36301] Fri, 11 January 2002 12:28 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
maximum allowed value when you define in a table or parameter to procedures is 4000.

64k is limit for varchar2 variable inside pl/sql programs.
Previous Topic: D2K
Next Topic: Re: Functions and Views
Goto Forum:
  


Current Time: Wed Apr 01 07:14:16 CDT 2020