Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: sql question

Re: sql question

From: sach <sach_at_f17.n5025.z2.fidonet.org>
Date: 2000/08/01
Message-ID: <MSGID_mail.relex.ru_01beb91a@fidonet.org>#1/1

by example in DBMS Linter(Russia) :
 in trigger BEFORE INSERT replace incorrect date on NULL or
1 create table tst (i int, d date default NULL, c char(5), ².); 2 insert into tst(i, c, ²) values (1,ˆ111ˆ, ²) - insert correct data 3 update tst set d= to_date(ˆ01.08.2000ˆ,ˆdd.mm.yyyyˆ) where i=1 and c=ˆ111 ˆ and ².; value i, c ,² - from previos insert The correct date will replaced, incorrect date will NULL

Andreas Lommel ïèøåò â ñHHáùåíèè <194032820%398526ff.2057859_at_news.btx.dtag.de> ...
>Hi there. Ia want to load data ito a table-field. The data shall be a
>date. If the data is not a valid date there should be load value NULL
>in the field. How can I do this ?
>
Received on Tue Aug 01 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US