Re: SELECT Help!

Chakravarthy Nalamotu wrote:
>
> 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.

Try this:

SELECT 'CREATE PUBLIC SYNONYM ' ||table_name||

        ' FOR user.'||table_name||';'
        FROM user_tables;