creating public synonyms for a set of tables (newbie)

Hi all,

I want to generate public synonyms for a set of tables under a schema, and I need help to build an script to do so in one time.

In pseudo-code, it would be something like:

for each table in schema.Tables do
{

    create public synonym table for schema.table; }

Thanks in advance,

Carlos Lacasa. Received on Mon Apr 17 2000 - 00:00:00 CDT