From: Willie S Coggins <coggins@acsu.buffalo.edu>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Create a table from query (Oracle Novice)
Date: Sat, 7 Jul 2001 19:59:42 -0400
Organization: University at Buffalo
Lines: 18
Message-ID: <9i87el$jps$1@prometheus.acsu.buffalo.edu>
References: <9i5c80$f5r$1@prometheus.acsu.buffalo.edu>
NNTP-Posting-Host: wn000405.walkway.buffalo.edu
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600


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
>
>