How to get array using Oracle sql query

Posted by Yashwant Chavan on Stack Overflow See other posts from Stack Overflow or by Yashwant Chavan
Published on 2010-03-17T05:29:50Z Indexed on 2010/03/17 5:31 UTC
Read the original article Hit count: 177

Filed under:

Oracle

I want to display Years between From date - To date using oracle SQL on dual table

e.g.

if pass - From date as 1/1/1900 and To Date as 1/1/2000

then it shoold display

1900

1901

-

till 2000

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and… >>> More
26 Days: Countdown to Oracle OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld! Oracle OpenWorld 2012 is just around the corner. In less than 26 days, San Francisco will be invaded by an expected 50,000 people from all over the world. Here on the Oracle WebCenter team, we’ve all been working to help make the experience a great… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012 Dear SOA partner community member To provide our community members the best of our knowledge, we want your feedback on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We… >>> More
Oracle ADF Coverage at OOW

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30. Oracle ADF and Fusion Development General Session Mon 1 Oct,… >>> More

Developer IT

How to get array using Oracle sql query - Developer IT

How to get array using Oracle sql query

Oracle

1901

-

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

26 Days: Countdown to Oracle OpenWorld 2012

OTN ???? ?????? ???????

SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

Oracle ADF Coverage at OOW

Categories cloud