SELECT Help!
From: Chakravarthy Nalamotu <kittu_at_gis.eng.hawaii.edu>
Date: 1996/07/16
Message-ID: <DunJp1.BpA_at_news.hawaii.edu>#1/1
Date: 1996/07/16
Message-ID: <DunJp1.BpA_at_news.hawaii.edu>#1/1
Hi,
SELECT 'CREATE PUBLIC SYNONYM ' ||table_name||
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.
Can some one let me know what's wrong with this SELECT
statemnet.
' FOR user.' ||table_name||
FROM user_tables;