pl/sql dbms_lob package
length() will return integer but not more than 4000 characters if parameter is of type VARCHAR
2000 characters if parameter is of type CAHR.
For finding the length of the LOB Objects we can use DBMS_LOB.GETLENGTH( LOB ) which will return INTEGER
2000 characters if parameter is of type CAHR.
For finding the length of the LOB Objects we can use DBMS_LOB.GETLENGTH( LOB ) which will return INTEGER
posted by Krishna Rajendra | 3:10 AM
0 Comments:
Post a Comment
<< Home