Return defined column size of varchar and varchar2 data types [message #679329] |
Fri, 21 February 2020 15:31 |
|
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.
|
|
|
|
|
|