PL/SQL Insert

From: <dejaron_at_my-dejanews.com>
Date: Wed, 02 Sep 1998 20:07:14 GMT
Message-ID: <6sk8hj$cu4$1@nnrp1.dejanews.com>

Is there a simple way to INSERT a row without having to list each field name? Here's a code example...

DECLARE data_record data_file%ROWTYPE;

BEGIN; data_record.fld_a := 'ABC123';
data_record.fld_b := 1234.56;

INSERT INTO data_file

{what to put here?}

END; I have a large record with over 100 fields and listing them (specifically maintaining them) is a hassle.

Your help is appreciated.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 02 1998 - 15:07:14 CDT