SyntaxFix

[oracle] Get column value length, not column max length of value

LENGTH() does return the string length (just verified). I suppose that your data is padded with blanks - try 

SELECT typ, LENGTH(TRIM(t1.typ))
FROM AUTA_VIEW t1;

instead.

As OraNob mentioned, another cause could be that CHAR is used in which case LENGTH() would also return the column width, not the string length. However, the TRIM() approach also works in this case.

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to string-length

• String field value length in mongoDB • SQL SELECT everything after a certain character • Length of string in bash • Get column value length, not column max length of value • How to get the number of characters in a string • How to find the length of a string in R • Retrieve the maximum length of a VARCHAR column in SQL Server • Measure string size in Bytes in php • How to get the size of a string in Python? • Display only 10 characters of a long string?