Get the latest!
You are here: Home / Tutorials

Category Archives: Tutorials

Quick Tip: Slicing A Long PLSQL String Into Smaller Pieces

slicing_strings

In Oracle 11g, the maximum size for a VARCHAR2 field in a table is 4,000 bytes. In PL/SQL your VARCHAR2 variables can be defined as up to 32,767 bytes. So, what if you i.e. have a log table where you would want to put all the content of your PL/SQL variable? Read More »

McAfee Total Protetion 50% Off
Scroll To Top