Answered Questions

  • Mar 30 2006
    04:49 AM
    22080
    42

    Can you explain what is DUAL table in oracle ?
    • Sundra

    Dnyaneshwar Mane

    • Apr 25th, 2018

    DUAL is a special one-row and 1-column table having value "X" by default in Oracles SYS schema. This table can be used for the purpose of : 1. Calculating mathematical expressions like: SELEC...

    shadiq

    • Jun 25th, 2015

    Insert into dual values (Y); will work i guess, only thing is you need a sufficient privilege...
    Also Dual can have 1000 columns and only one row.