Return defined column size of varchar and varchar2 data types [message #679329] |
Fri, 21 February 2020 15:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/fdc726a530d250d2dc7bf57b53391069?s=64&d=mm&r=g) |
jdbeyler
Messages: 1 Registered: February 2020
|
Junior Member |
|
|
I want to write a query that returns the defined size of a varchar and/or varchr2 data type. Example: I defined a varchar2 column as column_name1 varchar2(40)
I insert 'abcde' into that column, I want to write a query that returns the defined length of 40. I then want to evaluate that returned result against a defined integer variable that is set to a value of 40.
What is the best way to write this query. Note: I am most familiar with SQL Server and not sure how to accomplish this in PL/SQL in an Oracle environment.
|
|
|
|
|
|