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

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -