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

111111111111ravi11111111kumar11111111111?
i want display ravi kumar using sql?

Answer Posted / rathnakumar

select replace('111111111111ravi11111111kumar11111111111','1','') from dual;

Is This Answer Correct ?    17 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is stop and abort are same in informatica?

984


What is incremental aggregation?

1057


How do you remove duplicate records in informatica? And how many ways are there to do it?

1151


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2263


how we can load rejected record's at run time?(not through bad files)

2355


What do you understand by SOA of Informatica?

961


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1909


Enlist some properties of sessions.

1053


Is it possible to create multiple domains on a single Informatica server?

1217


Is there any way to read the ms excel datas directly into informatica?

1011


tell me 5 session failure in real time how can you solve that in your project?

2261


Scheduling properties,whats the default (sequential)

1942


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1748


What is target load order?

1225


What you know about transaction control transformation?

979