RE: Help

Lots
of ways
<FONT face=Arial color=#0000ff

size=2> 
CREATE
TABLE ouruser
AS
SELECT *
<FONT face=Arial color=#0000ff

size=2>      FROM myuser
<FONT face=Arial color=#0000ff

size=2>   UNION ALL
<FONT face=Arial color=#0000ff

size=2>     SELECT *
<FONT face=Arial color=#0000ff

size=2>     FROM uruser;
<FONT face=Arial color=#0000ff

size=2> 
This
will create a table ouruser with 10,000 records.
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>Rick

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Deewaker G.V.   [mailto:Deewaker_at_baazee.com]Sent: Thursday, July 26, 2001 7:47   AMTo: Multiple recipients of list ORACLE-LSubject:   Help
  Hi DBA Gurus
  Suppose I have a Table myuser which
  has 5000 records and another table uruser also 5000 records, and the structure   is same for the both... how do I put "MYUSER" AND 'URUSER" to a new table   callled "OURUSER"
  Ples help me..
  with warm regards,
  Deewaker G. V.
  Baazee.com India Pvt. Ltd.
  (<FONT face="Book Antiqua"
  color=#0000ff>: 4611323 Extn: 216 <FONT face="Book Antiqua"   color=#0000ff>Fax : 4611324
  <<Deewaker G.V..vcf>>    Received on Thu Jul 26 2001 - 05:59:40 CDT