Submitted Questions

  • How can you retrieve the numeric values from varchar2 type column?

    Hi Friends, One table is there. It is having varchar2 type column and this column having both numeric and alphanumeric values but I want to retrieve only numeric related values from that table. If it is possible then say the answer plz... I will wait for ur tremendous answer...

    Sayantan

    • Jun 1st, 2017

    Select length(trim(translate(string, +-.0123456789,) from table; if the value is null then its numeric

    Atish

    • Sep 13th, 2015

    "oracle8 SELECT * FROM TABLE_NAME WHERE UPPER(COLUMN_NAME)=LOWER(COLUMN_NAME);Above query will give numeric values only. Matching is done on the basis of ASCII character...