On Fri, Feb 25, 2000 at 05:45:48PM +0200, sinisa@stripped wrote:
> Paul Comber writes:
> > Dear All,
> >
> > This create statement below doesn't work. As a select statement it is fine.
> > The debug says that deliveryPostcode, name and tel are duplicate column
> > names. Am I right in thinking that the AS clause is ignored in create table
> > implementation of the select statement? If so how I can I get around this
> > without renaming the table column names so that attributes are unique
> > throughout the database schema?
> >
> >
> > CREATE TABLE TODAYSORDERS
> > CR.deliveryPostcode AS deliveryPostcode1
> > ,CR.deliveryPostcode AS deliveryPostcode2
> > ,PU.tel AS CollectionPhoneNo
> > ,C.tel AS deliveryPhoneNo
> > ,S.name as supplier
> > ,M.name as merchant
> > FROM etc etc etc
> > WHERE etc etc
> >
> > thanking you in advance,
> >
> > Thanks, Paul
> >
>
>
> Hi!
>
> What you need is CREATE from SELECT, available since 3.23.0.
>
> Please, do note that CREATE TABLE syntax has nothing to do with SELECT
> syntax !
>
> Regards,
>
> Sinisa
>
>
Similar sort of question: A client here is trying to run Supermall.
1) How do I grant him priveleges re: the database
2) How do I get him to set up tables?

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.