Tried!

No luck.

Thank you for your help.

Thanks Alvin.

The erros msg I got is :ORA-00923: FROM keyword not found where expected

Thank you. here is my Query

select Orgn.cd, fund.cd,fund.nm, fund.bf_Acty_Cd

from

(

select cd,nm, bf_Acty_Cd

from bf_fund ...

Thank you very much.

It really worked out. I really appreciate of your help.

sincerely,

Kenny

Sorry for confusion.

My company is using Toad which is from Oracle.

TO_char(Appdate,'YYYY-MM-DD')) AS "EstablishedDate"

when i used this function, in database there is no quote at all. However, i...

Hi Jeff,

I need to output to text file so that another department can upload to its DB and migrate to another system.

That is the whole project about.

Thanks.

Thanks Lowell.

I just checked with my boss and the strings can be double quoted.

Thank you very much for your time.

Hope in the future, i wont post a...

Thank you Lowell.

Is there anyway i can eliminate the double quotes from my script?

thank you.

hello all,

thanks again for all your helps.

Finally i used a stupid way to retrieve all the data i want as below. it took about 8 seconds to get...

Thanks William,

in my result, it shows

SS_26300_1 - Lev5 (everything rollup to this one) greater than 5,000,000 (everything needs to show)

SS_26460_2 - $ 5,000,000 -->bf_orgn_cd (showed)

SS_26461_2 - $6,000,000 -->bf_orgn_cd...

Thank you very much for all your kind replies.

I am pretty new in SQL and if my post dosent make sense, i am sorry about this.

I need to show...

Thank you very much.

Right now, i will need to show all the data which is over 5,000,000 in lev5.

Please check if you can see the attachment.

Thank you.

thank you for your reply. i think i didnt express it clearly.

But if i removed the having sum(a.data)>5000000, i will also get all the results smaller than 5000000.

for example...