LENGTH
This will give length of the string.
Syntax: length (string)
Ex:
SQL> select length(‘computer’) from dual;
output 8
![length in 1 SQL](https://oraclesql.in/wp-content/uploads/2020/10/length-function.png)
Ex:
SQL> select length(‘this is My home.’) from dual;
output 16
![length function in sql](https://oraclesql.in/wp-content/uploads/2020/10/length.png)
LENGTH
This will give length of the string.
Syntax: length (string)
Ex:
SQL> select length(‘computer’) from dual;
output 8
Ex:
SQL> select length(‘this is My home.’) from dual;
output 16