Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help

RE: Help

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Thu, 26 Jul 2001 03:59:40 -0700
Message-ID: <F001.00355BBE.20010726041111@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US