OraFAQ Forum: SQL & PL/SQL » Suggest for Error

Home » SQL & PL/SQL » SQL & PL/SQL » Suggest for Error (Oracle 9i/10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Suggest for Error [message #327961]

Wed, 18 June 2008 07:51

sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India

Member

No Message Body

[Updated on: Wed, 18 June 2008 07:55]

Report message to a moderator

Re: Suggest for Error [message #327962 is a reply to message #327961]

Wed, 18 June 2008 07:56

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Next time post the error message rather than posting the sql query and making us to guess what the error is. In your case the error is you cannot use column alias as a column in the same level of the sql query.

Regards

Raj

P.S : Why did you edit your post ???

[Updated on: Wed, 18 June 2008 07:56]

Report message to a moderator

Re: Suggest for Error [message #327964 is a reply to message #327962]

Wed, 18 June 2008 07:57

sumedh7
Messages: 31
Registered: March 2007
Location: Pune,India

Member

Dear Sir,

So sorry as query was posted by mistake, i will describe with error and revert back

Thank You

Report message to a moderator

Re: Suggest for Error [message #327971 is a reply to message #327962]

Wed, 18 June 2008 08:25

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I suggest to remove the whole topic and let OP create a new one when he will have whole information.

Regards
Michel

Report message to a moderator

Previous Topic:	How Many unique constraints can be allowed for a Table?
Next Topic:	Need to remove logic for inserting multiple rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 15:04:31 CST 2024