1 2 Previous Next 21 Replies Latest reply: Feb 16, 2011 9:58 AM by Peter Gjelstrup RSS

    date as column name

    AlexAnd
      hi
      i try use "DATE" as column name
      i know what this isn't good, but it's interesting moment =)
      create table t( "DATE" date);
      insert into t values (sysdate);
      sql query work fine
      select "DATE" from t
      16.02.2011 15:38:25
      but in plsql block not work
      declare
       t date; 
      begin
          select t."DATE"
             into t from ttt;
          dbms_output.put_line(t);
      end; 
      any idea why?

      alex
        1 2 Previous Next