Re: Inserting a Record into a Table

From: Bambang Setiawan <Bambang.Setiawan_at_Sidola.com>
Date: Fri, 03 Aug 2001 11:38:25 -0700
Message-ID: <F001.0035EC34.20010802204610@fatcity.com>

hi,

try
INSERT INTO yournewtable
SELECT * FROM youroldtable;

if you want to modify value for particular field you can use oracle functions in SELECT clause.

in example below I use string function called SUBSTR :

SQL> insert into newdept
2 select deptno,SUBSTR(dname,1,3) ,loc from olddept;

SQL> select * from olddept;

DEPTNO DNAME LOC

-------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SQL> select * from newdept;

DEPTNO DNA LOC

-- ------------- 10 ACC NEW YORK 20 RES DALLAS 30 SAL CHICAGO 40 OPE BOSTON

hope this help : )

<> Bambang Setiawan <>

>>> kgel_at_ppoone.com 08/03/01 06:50 >>>
Can you insert an entire record into a table without having to specify each individual field ??

I need to copy multiple rows in a table after I have modified its key. I do not want to have to specify each field. Is there a way just to select the record, modify the particular field, and then insert the record... WITHOUT having to list all the fields or each individual value ??

Thanks

Kevin

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Kevin Lange
  INET: kgel_at_ppoone.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bambang Setiawan
  INET: Bambang.Setiawan_at_Sidola.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Aug 03 2001 - 13:38:25 CDT