Re: Create synonym

Hong Zhou wrote:
>
> I have 50 or so tables, now I want to create synonym for them,
> same name as table name. How can I do this without manully one by one?
>
> Thanks in advance.

Try This:
spool a.sql
select 'create synonym ' ||Table_name|| ' for '|| Table_Name from tab ;
spool off
_at_a

or somthing of this kind .

-- 
+++++++++++++++++++++++++++++++ |\/\/\/|
Shay shmelzer                   |      |
John Bryce Systems - Israel     OO	)
e-mail:sshmelze_at_johnbryce.co.il c      |
				/___/  |
+++++++++++++++++++++++++++++++    )   |