Submitted Questions

  • bind variabales

    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.