i would like to collect informations from oracle date table through select
query financial year wise
my financial year starts from01 jul and ends on 30 jun.
my task is to collect total number of entries from last ten financial years wise.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 2 &nbspReplies

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

You need to provide more details if you really want to get useful answers.
You didn't even tell us how you want to do this (using SQL ? or using some application ? something else ?)
Also, if you want to use SQL, you would have to provide some information about your database design.

Thanks for your response.
Actually i am using Oracle 7.3.1 with Devloper 2000
I want to get information from a table name 'bilmst' having column name 'a/c no.' and
'enterdate' i want to collect information as follows
fy 01-07 No of A/Cs
to 30-06
2005-06 1500
2006-07 1000
2007-08 1200
2008-09 1100
i want to get information as example given above
my financial year from 01-07 to 30-06.
can i get information with select command as above format.
please guide.
Thank
Toqeer Akbar

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy