Home » SQL & PL/SQL » SQL & PL/SQL » Suggest for Error (Oracle 9i/10g)
Suggest for Error [message #327961] Wed, 18 June 2008 07:51 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Suggest for Error [message #327971 is a reply to message #327962] Wed, 18 June 2008 08:25 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: How Many unique constraints can be allowed for a Table?
Next Topic: Need to remove logic for inserting multiple rows
Goto Forum:
  


Current Time: Sat Dec 03 08:06:34 CST 2016

Total time taken to generate the page: 0.08970 seconds