Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle string length

-- Relevant for SQL-Oracle only

-- syntax
LENGTH(<your-string>)

-- example
LENGTH('CountCharacters') -- OUTPUT: 15
        123456789012345

-- example with query 
SELECT 'CountCharacters',LENGTH('CountCharacters')
FROM DUAL;

-- OUTPUT: CountCharacters, 15
Comment

oracle string length

SELECT length('abcd') FROM DUAL;		-- Oracle
SELECT length('abcd');					-- MySql / PostGreSQL
SELECT len('abcd');						-- SQL Server
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql group by month 
Sql :: mysql convert timestamp to date 
Sql :: mysql grant all privileges to user from any host 
Sql :: mysql command line xampp ubuntu 
Sql :: postgres alter user password 
Sql :: sql query to get column names and data types in sql server 
Sql :: how to install postgresql on wsl 
Sql :: mysql first day of year 
Sql :: mysql users and privileges list 
Sql :: get table columns from sql 
Sql :: dbms_output sql developer 
Sql :: oracle find text in functions 
Sql :: ms sql rename database 
Sql :: sql query to find duplicates in column 
Sql :: mysql get last day of month 
Sql :: see all users mysql 
Sql :: dbms_scheduler stop job 
Sql :: mysql cannot delete or update a parent row 
Sql :: mysql slave status 
Sql :: oracle to date 
Sql :: list all permissions on a table in postgres 
Sql :: mysql greater thatn a week ago 
Sql :: influxdb export to csv 
Sql :: sql change table name 
Sql :: mysql date between two dates 
Sql :: tsql find foreign key references 
Sql :: postgres count distinct 
Sql :: set permanent SET GLOBAL sql_mode ubuntu 
Sql :: sql set no lmit 
Sql :: mssql get all table names 
ADD CONTENT
Topic
Content
Source link
Name
3+9 =