Re: SELECT Help!

kittu_at_gis.eng.hawaii.edu (Chakravarthy Nalamotu) wrote:
>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.

This script works for me.

SELECT 'CREATE PUBLIC SYNONYM ' ||table_name||

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

Hope it helps Received on Fri Jul 19 1996 - 00:00:00 CEST