Re: SELECT Help!

In article <DunJp1.BpA_at_news.hawaii.edu>, kittu_at_gis.eng.hawaii.edu (Chakravarthy Nalamotu) writes:

>Hi,
>Can some one let me know what's wrong with this SELECT
>statemnet.
>
>SELECT 'CREATE PUBLIC SYNONYM ' ||table_name||
> ' FOR user.' ||table_name||
> FROM user_tables;
>
>I am trying to create public synonyms on the tables
>in a schma with the same name as the table name.
>I was trying to use the above select statement
>to generate the script, but was getting a missing expression
>error.
>
>Thank you for your replies.
> Kittu.
>

You have added a '||' after table_name (!)... ...
> ' FOR user.' ||table_name||

                                  ^^

remove it:

SELECT 'CREATE PUBLIC SYNONYM ' ||table_name||

        ' FOR user.' ||table_name
        FROM user_tables;

Ciao. Received on Wed Jul 17 1996 - 00:00:00 CEST