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 / sovan

select supplier_name "supplier name" ,to_char
(trx_date,'mon/yy') "date",amount "amount"||'/*'||to_char(trx_date,'mon')||'
month total transactions */' from <Table_NAME>;

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

please send me forms, xml pulisher questions,answers

2101


Do you know what is applysys in oracle application database schema, what is apps?

1168


How to create a purchase order without a requisition?

1173


tell me the scenarios of the independent in reports

2490


In oracle application how do you debug or trace errors?

1091


What do you understand by concurrent programs?

1074


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3044


tell my any difficult situtation you solved in your experience in your company?

2309


pls send me out bound code of supplers,site,bankiformation code pls as soon as

2243


what is the difference between request group and request security in oracle apps?

5870


In sequence i want to 11 and 15th values how we will write?

2064


what is pay run id ?

2182


What is count(*) from po_vendors(any table)?

1074


Plz anybody send me Technical specification for AP Interface

2544


Is soa a part of oracle fusion middleware?

1074