Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

extract field error

grapes12Feb 12 2011 — edited Feb 13 2011
I have the following select to extract a date containing month and year from a varchar2 column
select to_char(sau_date,'MM') MONTH,extract(year from sau_date) YEAR, count(*) COUNT
from mac.sysaud
group by to_char(sau_date,'MM'),extract(year from sau_date)
order by extract(year from sau_date), to_char(sau_date,'MM');
when running select i receive a ora-30076:invalid extract field for extract source
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2011
Added on Feb 12 2011
10 comments
293 views