Home » SQL & PL/SQL » SQL & PL/SQL » & problem need help urgent
& problem need help urgent [message #38543] Thu, 25 April 2002 12:49 Go to next message
shreya
Messages: 15
Registered: March 2001
Junior Member
Hi,
My query is like this.
SELECT a.* FROM &schema1.account@x1 a,
&schema2.account@x2 b;

The problem is as follows
It asks for the input first.

Enter value for schema1: shreya1
old 3: FROM &schema1.account@x1 a,
new 3: FROM shreya1account@x1 a,

Enter value for schema2: shreya2
old 4: &schema2.account@x2 b
new 4: shreya2account@x2 b
shreya2account@x2 b
*
ERROR at line 4:
ORA-00942: table or view does not exist
ORA-02063: preceding line from x2

It doesn't include . like shreya2.account@x2.
Does anyone have any idea why this is happening.

Thanx,

Report message to a moderator

Re: & problem need help urgent [message #38548 is a reply to message #38543] Fri, 26 April 2002 04:13 Go to previous message
Saga
Messages: 51
Registered: April 2002
Member
Try using
SELECT a.* FROM '&schema1'.account@x1 a,
'&schema2'.account@x2 b;

It will solve ur problem.

Report message to a moderator

Previous Topic: Analytic SQL
Next Topic: Converting table into control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 21:08:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.