Re: easy question...i think

Satar Naghshineh wrote:
>
> 15-SEPT-97
>
> Oracle 7.2.3
> sun OS 2.5.1
>
> Hi,
> I want to transfer current table data into two new tables, then create a
> view based on the two new tables. I would I go about doing that in 1
> 24/7 shop? Thanks in advance,
> Satar Naghshineh
> SatarNag_at_worldsite.com
>
> P.S. I will post more Oracle Worldwide Support's FAQs as soon as I can
> find the time.

Hello,

   To copy the current table data from one to another table    you can try something like this....   

   create table tab1 as select * from <your table name>    where <condition>

   create view <view name> as select * from tab1;

   To drop a view give "Drop view <view name>"

   Hope this helps you....
   Can pose any problem related to oracle... at    Somasatish_at_hotmail.com Received on Wed Sep 17 1997 - 00:00:00 CDT