Re: Default schema...

In <34188_at_nntp_server.ems.cdc.com> btreuman_at_ems.cdc.com (Bob Treumann) writes:

>Use variables for the schema name, and set them under each connection.
 

>define default=A
 

>select * from &default.table_a

The result of the substitution wil be:

  select * from Atable_a

if you use the sql*plus defaults. The . terminates a variable. Try

  select * from &default..table_a

instead

Regards

Ian

-- 
--
Ian Dixon                       Email : idixon_at_infocom.co.uk
Reading, England