I want to delete duplicates. But in Oracle Sql developer, when I use the following with CTE, it shows me error. If I use Select it only works then but I want to delete from the table using the view. 

```
WITH PECCTE AS ( 
SELECT QT_PEC_RATE.*, ROW_NUMBER() OVER(PARTITION BY QT_PEC_RATE.UWC_CODE, AGE ORDER BY QT_PEC_RATE.UWC_CODE) AS ROWNUMBER 
FROM QT_PEC_RATE WHERE NLG_OPTION='STD' AND GENDER='M' AND CNTRY_RATING='C' AND GMCR_RATE=2
)
DELETE FROM PECCTE WHERE ROWNUMBER>1;

```

it shows error that missing select statement.
it only works with the following

```
WITH PECCTE AS ( 
SELECT QT_PEC_RATE.*, ROW_NUMBER() OVER(PARTITION BY QT_PEC_RATE.UWC_CODE, AGE ORDER BY QT_PEC_RATE.UWC_CODE) AS ROWNUMBER 
FROM QT_PEC_RATE WHERE NLG_OPTION='STD' AND GENDER='M' AND CNTRY_RATING='C' AND GMCR_RATE=2
)
SELECT * FROM PECCTE;

```

How can I delete from the table using this view.