Re: Help Please

From: Scott Urman <surman_at_dlsun338.us.oracle.com>
Date: 1996/08/28
Message-ID: <50242n$n71_at_inet-nntp-gw-1.us.oracle.com>#1/1

In article <32248617.207_at_orcinus.ksc.nasa.gov>, Zhangshi Yin <yinz_at_orcinus.ksc.nasa.gov> writes:
|> Greeting:
|>
|> Does anybody know how to append a table to another table. The two
|> tables have the absolutely same columns. Any helps will be highly
|> appreciated.

How about INSERT INTO table1 SELECT * FROM table2;

|>
|> Please reply to my account: yinz_at_dugong.ksc.nasa.gov
|>
|> Zhangshi

---

Scott Urman Oracle Corporation surman_at_us.oracle.com

---

Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm

---

"The opinions expressed here are my own, and are not necessarily that of  Oracle Corporation"

---

Received on Wed Aug 28 1996 - 00:00:00 CEST