OraFAQ Forum: SQL & PL/SQL » Missing Select Keyword

Home » SQL & PL/SQL » SQL & PL/SQL » Missing Select Keyword

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

Missing Select Keyword [message #6985]

Wed, 14 May 2003 13:28

Sarah
Messages: 15
Registered: June 1999

Junior Member

Hi,

I am trying to run a select statement in Toad (Oracle) that I previously ran in MS Access. I am getting stuck with the syntax conversion between the two.

In Access part of my select statement included the creation of a new column:

[[TotalReleased]]/[[TotalEffort]] as CPUE

In Toad I get a missing expression error. When I change the [[]] to () I get a missing select keyword error.

Is there a division operator that I am missing?

Any help is appreciated!

S

Report message to a moderator

Re: Missing Select Keyword [message #6986 is a reply to message #6985]

Wed, 14 May 2003 13:33

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Any of the following are valid:

(TotalReleased) / (TotalEffort) as CPUE
((TotalReleased) / (TotalEffort)) as CPUE
TotalReleased / TotalEffort as CPUE
(TotalReleased / TotalEffort) as CPUE

If you still get an error, please post the complete SQL.

Report message to a moderator

Previous Topic:	Sequence Value Retrieval
Next Topic:	ALTER TABLE table_name MODIFY column_name VARCHAR(200)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 07:51:10 CDT 2024