Re: SQL not working in 10g Release 2

murali <bmuralir_at_gmail.com> wrote:
> I have migrated to 10g release 2 from release 1 few days back. I am
> finding a lot of issues currently in R2. One major problem is that one
> SQL is working when I login as the schema user, but when I try to run
> it by login as a different user it is not executing.
>
>
> The SQL is something like this :
>
> select column1,.....,columnx from t,(select col1 from t2 where
> t2.xyz='1234') t2
> where t.column1 = t2.col1
>
>
> Please help.

Please post useful information, that is:

• the statement that does not work as you want,
• what actually happens (including error messages),
• what you think should happen and why.

Yours,
Laurenz Albe

PS: It is not 'an SQL', but 'an SQL query', that you are complaining about. Received on Wed Jan 11 2006 - 02:05:01 CST