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...

I have Flat file like the data, sal have 10,000. I want to
load the data in the same format as sal as 10,000. Can
anybody know the answer means please mail me.
Thanks in advance.. My mail id is chandranmca2007@gmail.com

Answer Posted / davankumar

to_char(10000,'99,999.00') from dual;

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain sessions?

1012


How we can create indexes after completing the load process?

1135


What is primary and backup node?

1102


How to configure mapping in informatica?

1143


can we override a native sql query within informatica? Where do we do it?

1087


What is data transformation manager process?

1110


How you prepared reports for OLAP?

1570


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2091


what are the Methods For Creating Reusable Transformations?

1127


What is a rank transform?

1052


What are the types of presistent cache in look up tr.

2030


What is the format of informatica objects in a repository?

994


Sequence generator, when you move from develoment to production how will you reset

1983


How many number of sessions can one group in batches?

1121


what is $$$$?

2114