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
- 5 Answers
- 9277 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / santosh
sel regexp_substr('aa6588fhfhf','[[:digit:]]+')
Ans:6588
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between fastload and multiload?
Explain the most common data types used in teradata?
What is the difference between fastload and multiload? Which one is faster?
List the logical and conditional operators that are used with teradata along with their meanings?
What is a sparse index?
What is the use of having index on table?
What is the maximum number of dml can be coded in a multiload script?
What are the steps to create a data model?
Explain the meaning of Amp?
What is the use of fallback?
What do you mean by fastexport in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is spool space? Why do you get spool space errors?
What are the functions of a Parser?
How do you do backup and recovery in teradata?
