Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.84K
1 Posted Topic
Hi, I am a junior dev. and I need help on some select statements on a Oracle db. First I needed to get all the months of the year in 'MON' format and I did it like this: [code=sql]SELECT distinct TO_CHAR(dt,'MON') MONTH FROM ( SELECT TRUNC(SYSDATE,'y')-1+ROWNUM dt FROM all_objects WHERE …
The End.