ORACLE date values

[Aci Polajnar]

Hi there!

Does anybody know, what is going on, when I just press enter on a date
field while entering dates to an ORACLE 7.3 table. If I recall this
row, my date field is shown as blanck on a QUICK screen and '00000000 1200' if
I select this date from the table with

select to_char(mydate,'ddmmyyyy hhmiss') from mytable

Table, I am working on looks like this:

CREATE TABLE XOCTEST ( 
  ID      CHAR (10)     NOT NULL, 
  DATOTV  DATE          NOT NULL ) ; 

My problem is, that I should write an PL/SQL procedure to insert such a dates
to the table which will not be seen on an QUICK screen.
Also I can't remove NOT NULL option from the table because it is an index
field.

Thank you


 
-- 
                  _\\///_
                 (' o-o ')
_______________ooOo_( )_oOoo_____________________________________

Aci Polajnar                  Tel   : +386(0)3 4274174
IS Consultant                 Fax   : +386(0)3 4274198
Razvojni Center Celje         e-mail: acip@rcc-irc.si
3000 Celje, Slovenia          URL   : http://www.rcc-irc.si  
_______________oooO____Oooo______________________________________
              (   )    (   )
               \ (      ) /
                \_)    (_/