Re: insert a record in Oracle table

Hi,

> How to insert a record into oracle table which has default system date
> fileds and trigger sequence number field.
>
> how to escape these fileds and insert values in other fields.
>

See at syntax in your ORACLE SQL Online Documentation ! Insert Into table1 (field1, field3, file4711, ...) values (value1, value3, value4711, ...);

no cross postings, please. thx

Regards,
Falko Rotter

• Software Developer -

Rotter & Kalweit Softwaredesign GbR
Friemarer Straße 38

99867 Gotha
GERMANY mail: news_at_falko-rotter.de Received on Mon Aug 20 2001 - 09:22:07 CDT