Varchar datatype limits

Bino Kochumol Varghese |   30 Nov 2024

For NVARCHAR2 and VARCHAR2 maximum size is 4000 bytes, or 32767 bytes if the MAX_STRING_SIZE initialization parameter is set to EXTENDED. This is useful you have to allocate more data to a variable.

You can run the below command to view the parameter.

show parameter MAX_STRING_SIZE;
References

Oracle Doc, Max string size

pl-sql

What are your thoughts on this post?

I’d love to hear from you! Click this link to email me—I reply to every message!

Also use the share button below if you liked this post. It makes me smile, when I see it.

Read More

PL/SQL commands to view the table details

13 Nov 2024

In Oracle PL/SQL, you can use the following commands to view table details:

Read more

Use Flashback Query

11 Nov 2024

If your Oracle database has Flashback enabled, you can query past versions of data within a specified retention period. Here’s how to use Flashback to retrieve a prior state of data:

Read more

To generate random value in PL/SQL

30 Oct 2024

To update a column with a random value in PL/SQL, you can use the DBMS_RANDOM package, which provides functions for generating random numbers or strings.

Read more