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

What is the purpose of joins in teradata?

1262


What is a clique?

1152


How many types of joins are there in teradata?

1021


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2220


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4421


Explain BYNET.

1055


What is spool space?

1221


Can we collect statistics on multiple columns?

1124


How is the teradata different from oracle?

1166


What is meant by a Parsing Engine?

1235


Explain amp in teradata?

1151


How do you verify a complicated sql?

1115


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1084


Explain the term 'primary key' related to relational database management system?

1089


Why is the case expression used in teradata?

1137