Home » SQL & PL/SQL » SQL & PL/SQL » Select Statement
Select Statement [message #195142] Wed, 27 September 2006 03:14 Go to next message
Messages: 1
Registered: September 2006
Location: South Africa
Junior Member
When running the following code under oracle 817......

SELECT account,
COUNT(*) over(partition by trans_code)
FROM acount_info

It returns:

ORA-00923: FROM keyword not found where expected

I suppose 817 is not capable of using this.Is there any thing else I can use to do this under 817?
Re: Select Statement [message #195144 is a reply to message #195142] Wed, 27 September 2006 03:29 Go to previous message
Messages: 21123
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
My supports it; no error.

You could, however, try with something like this:
SELECT a.account, x.trans_code, x.cnt
FROM account_info a, (SELECT trans_code, COUNT(*) cnt
                      FROM account_Info
                      GROUP BY trans_code
                      ) x
WHERE a.trans_code = x.trans_code;
Previous Topic: return array through a procedure
Next Topic: Join Style Performance
Goto Forum:

Current Time: Thu Jun 29 09:24:02 CDT 2017

Total time taken to generate the page: 0.09132 seconds