Re: sql

From: Marion <dont_use13_at_hotmail.com>
Date: 2000/06/15
Message-ID: <8iar8v$tv5$1@nnrp1.deja.com>#1/1

CREATE table3
AS SELECT a.name, b.age, a.salary
from table1 a, table2 b
Where a.name = b.name;

Using the "AS SELECT" clause, you don't have to specify datatype; Oracle just assumes the same datatypes as the source tables.

Marion Boulden

In article <39489838.95898574_at_news.btx.dtag.de>, him_lommel_at_t-online.de (Andreas Lommel) wrote:
> Hi there, maybe someone can help me:
> I have 2 tables
> table1
> name varchar2(10), Smith, Scott, Robinson, Miller
> salary number(5) 1000,1500,1300,1200
> table2
> name varchar2(10), Meyer, Sinclair,
> age (2) 34, 45
> Now I want to create a third table which contains these 2 tables.
> table3
> name varchar(10) Smith, Scott, Robinson, Miller,Meyer, Sinclair,
> age(2) ,,,,34, 45
> salary number(5) 1000,1500,1300,1200,,
>
> How does it work ?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jun 15 2000 - 00:00:00 CDT