DISTINCT ON function in toad

[camurtha]

I have the following code:

SELECT DISTINCT ON (REQUEST_ID) BATCH_ID, REQUEST_ID FROM VOLUNTEER_REQUEST

I am recieving the error 'ORA-00936: missing expression' what am I doing wrong?

Basically I have multiple rows and every column data is the same except for two columns and I can't exclude these columns. I don't want the multiple rows to be return, I just want one to return and the columns are linked with the batch_id column. Is this even possible?

Thank you.

[arunway2002]

I think you are giving wrong syntx inseated of previous query just run the
below query
SELECT DISTINCT (REQUEST_ID) BATCH_ID, REQUEST_ID FROM VOLUNTEER_REQUEST

Thanks