Custom query in Oracle SQL -
i have integer field in table.
i want read first digit of field, digit read next digits.
for example consider field: 355560
- i read first digit (3)
- then read 3 digits after 3 : (555)
how write select query?
select substr (355560, 2, substr (355560, 1, 1)) dual;
Comments
Post a Comment