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

Hi Frnds this que is recently asked at IBM
there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.
Can any one help

thanks in advance

Answer Posted / santosh

sel regexp_substr('aa6588fhfhf','[[:digit:]]+')
Ans:6588

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain amp in teradata?

1058


What is the syntax for case when statement?

1112


How many types of joins are there in teradata?

954


In general, how do you optimze any sql in teradata?

1023


What are the functions performed by bynet?

1030


Highlight the limitations of TPUMP Utility.

1096


Explain parsing engine in teradata?

1070


What is real time and near real time data warehousing?

1103


Why do you get spool space errors? How do trouble-shoot them?

1043


List the logical and conditional operators that are used with teradata along with their meanings?

980


How to Extract data from multiple legacy systems?

1095


Explain the parallel data extension in teradata?

1075


Explain some differences between mpp and smp?

1080


What are teradata utilities?

1095


Highlight a few of the advantages that ETL tools have over Teradata.

1073