Answered Questions

  • Feb 10 2012
    12:33 PM
    19144
    28

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

    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...