Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Patrick LeBlanc SELECT and WHERE without FROM RE: SELECT and WHERE without FROM

  • June 23, 2011 at 2:04 am

    #1342854

    Geoff Langdon (6/23/2011)

    Interestingly, this gives ORA-00923 error - FROM keyword not found where expected in Oracle.

    (Hence I got it wrong!)

    Geoff how about:

    1 select '123' as col1

    2 from dual

    3* where 1 =1

    orhousin@BUSO> /

    COL

    ---

    123

    I was expecting this question to have almost 100% correct answers...