filmov
tv
Just Know How Ltrim() Function in oracle - Cool Videos #stringfunction #oraclesql

Показать описание
LTRIM(trim_source,set)
Set is the optional.
trim source is the whatever you can type there!
SELECT LTRIM( ' abcd' ) FROM dual;
SELECT LTRIM( 'abcd' ) FROM dual;
SELECT LTRIM( 'abcd', 'cd' ) FROM dual;
SELECT LTRIM( 'abcd', 'ab' ) FROM dual;
Set is the optional.
trim source is the whatever you can type there!
SELECT LTRIM( ' abcd' ) FROM dual;
SELECT LTRIM( 'abcd' ) FROM dual;
SELECT LTRIM( 'abcd', 'cd' ) FROM dual;
SELECT LTRIM( 'abcd', 'ab' ) FROM dual;