How to get short name & long name of the month or month of given date in Oracle? - Another Braket

anotherbraket is for sale!

How to get short name & long name of the month or month of given date in Oracle?

pradeepkumarjse

How to get short name & long name of the month or month of given date in Oracle?

Jansen

select to_char(inputdate,'mon') as shortname,
 to_char(inputdate,'month') as longname from
 (select
 to_date(&sa_dt,'dd-mon-yy') inputdate
 from dual);