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.
This view describes all directories accessible to the user.
SELECT * FROM ALL_DIRECTORIES;
This view describes all directories specified for the entire database.
SELECT * FROM DBA_DIRECTORIES;
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.