Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to report output like below


supplier name date amount

abc software jan/11 10000 /* jan month total transactions*/
abc software feb/12 30000 /* feb month total transactions*/
dell computers jan/13 45000 /* jan month total transactions*/

Answer Posted / ram

select supplier_name ,to_char
(sysdate,'mon/yy'),amount||'/*'||to_char(sysdate,'mon')||'
month total transactions */' from <Table_NAME>;

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a value set? List its various types.

1144


How do you register report in oracle apps?

1136


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3078


Can you differentiate between mediator and osb?

1193


Plz anybody send me Technical specification for AP Interface

2617


what are the different transaction clauses in AR?

2169


testing tools?

2303


What are the different components of soa suite?

1265


tell me the scenarios of the independent in reports

2567


Can you explain the difference between architecture followed in 10g & 11g?

1122


Can we create tables in apps schema?

1184


What does appl_top directory contain?

1168


What is oracle soa suite and what are its different components?

1281


can we get profile values in report without using user exists is it possible how?

2935


tell me the scenarios of the independent in reports

2658