Answered Questions

  • Dec 16 2013
    11:15 AM
    11203
    6

    bind variabales
    • kamesh

    what are bind variables in sql? explain in detail?

    pradipta

    • Feb 8th, 2014

    The way to get Oracle to reuse the execution plans for "the statements having different hard coded value in where clause" there should use bind variables. Bind variables are «substitution» variable...

    Aarti

    • Jan 15th, 2014

    Bind variable is session specific variable. It is declared using variable keyword. Bind variable cant be used in named block. It cant have default value.

  • Nov 24 2011
    02:07 PM
    12330
    39

    Get Numeric Values only using SQL ?
    • sateesh44

    I have table with one column. type varchar.. PHONE --------------- 99samn44423m44 8034skdf3453a2 909090abc4567d i want to get numeric values.. i mean my output will be PHONE --------------- 994442344 80343453a2 9090904567 thanks in advance.. Sateesh

    Ganezh

    • Apr 20th, 2016

    Code
    1. SELECT REGEXP_REPLACE(AB12CD34EF,A|B|C|D|E|F, ) FROM DUAL;

    Krishna

    • Mar 30th, 2016

    Code
    1. SELECT REGEXP_REPLACE(<Column Name>,[A-Za-z]) FROM <Table Name>;