From: nick <nick-love@juno.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Create a table from query (Oracle Novice)
Date: Sun, 08 Jul 2001 03:30:10 -0000
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <tkfku2tnrvt7b6@corp.supernews.com>
Content-Type: text/plain
Content-Disposition: inline
Mime-Version: 1.0
X-Mailer: MIME-tools 4.104 (Entity 4.117)
References: <9i5c80$f5r$1@prometheus.acsu.buffalo.edu> <9i87el$jps$1@prometheus.acsu.buffalo.edu>
X-Complaints-To: newsabuse@supernews.com
Lines: 46



Willie S Coggins wrote:
> 
> 
> I discovered afte some reading how to apply SELECT INTO and CREATE TABLE 
 AS
> to create a table from an existing table via a query.  However, I still 
 need
> help to find out how to solicit user input to retrieve sorted information
> from a table.  Can someone offer some assistance?
> Will
> 
> 
> "Willie S Coggins" <coggins@acsu.buffalo.edu> wrote in message
> news:9i5c80$f5r$1@prometheus.acsu.buffalo.edu...
> > I have two questions.
> > How can one create a table from an Oracle SQL query?
> > How can I get users to enter parameters in a query?
> >
> > Will
> >
> >
>  

    Create table Emp2 
    As
    Select Empno,Name,Job,Salary
    from EMP1
    Where Deptno IN (100,200)

    The example above create a table EMP2, which contain the Employee 
Number(Empno), Employees' Name(Name), Employee's Job(Job), and Employees' 
Salary whose is working in either Department Number(Deptno) 100 or 200.
The data for EMP2 table is coming form EMP1.

   Select *
   From EMP2; (This will bring up all the data from the EMP2 table)
 

> 



--
Posted via CNET Help.com
http://www.help.com/