#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2011
    Posts
    1
    Rep Power
    0

    Question Select statement


    I am using oracle 10g i have a table on my computer that i made for a friend when i load it on their computer the select statements say no data found
    if i use select * from table name all the data will show
    but if a column name select * from table name where duty_date = '05-JAN-11'
    no data found
    Please can you help
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    859
    Rep Power
    388

    Cool


    Originally Posted by Headworth
    I am using oracle 10g i have a table on my computer that i made for a friend when i load it on their computer the select statements say no data found
    if i use select * from table name all the data will show
    but if a column name select * from table name where duty_date = '05-JAN-11'
    no data found
    Please can you help
    Always compare DATES to DATES:
    Code:
    SELECT *
      FROM table_name
     WHERE duty_date = TO_DATE('05-JAN-11','DD-Mon-YY')

IMN logo majestic logo threadwatch logo seochat tools logo