RE: Help

[Cale, Rick T (Richard)]

Title: Help

Lots of ways

 

CREATE TABLE ouruser

AS SELECT *

      FROM myuser

   UNION ALL

     SELECT *

     FROM uruser;

 

This will create a table ouruser with 10,000 records.

 

Rick

-----Original Message-----
From: Deewaker G.V. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 7:47 AM
To: Multiple recipients of list ORACLE-L
Subject: 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.
(: 4611323 Extn: 216
Fax : 4611324

<<Deewaker G.V..vcf>>