If you want to remove leading zero’s or any other character from a string, or really do the SQL opposite of LPAD then use LTRIM. SELECT ltrim(text_string,’0′) FROM <tablename>
Oracle Home
For Everything Oracle and more
For Everything Oracle and more
If you want to remove leading zero’s or any other character from a string, or really do the SQL opposite of LPAD then use LTRIM. SELECT ltrim(text_string,’0′) FROM <tablename>