--Developing Oracle Applications with Developer/2000
--@C:\DEV2000\SQL\CREATSYN.SQL

spool C:\DEV2000\SQL\CREATSYN.TXT

Prompt Developing Oracle Applications with Developer/2000
connect system/manager
Prompt Creating Public Synonyms as...

select substr (user,1,20) User_Id,
sysdate Sys_Date,
substr (to_char(sysdate, 'HH:MIAM'),1,10) Sys_Time from dual;

create public synonym contact		for SCOTT.contact;
create public synonym customer		for SCOTT.customer;
create public synonym dept		for SCOTT.dept;
create public synonym emp		for SCOTT.emp;
create public synonym emp_audit		for SCOTT.emp_audit;
create public synonym rpt_audit		for SCOTT.rpt_audit;
create public synonym state		for SCOTT.state;
create public synonym contacts		for SCOTT.contact;
create public synonym customers		for SCOTT.customer;
create public synonym departments	for SCOTT.dept;
create public synonym employees		for SCOTT.emp;
create public synonym employee_audits	for SCOTT.emp_audit;
create public synonym report_audits	for SCOTT.rpt_audit;
create public synonym states		for SCOTT.state;

Prompt Done Creating Public Synonyms.

spool off;
