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
Explain amp in teradata?
What is the syntax for case when statement?
How many types of joins are there in teradata?
In general, how do you optimze any sql in teradata?
What are the functions performed by bynet?
Highlight the limitations of TPUMP Utility.
Explain parsing engine in teradata?
What is real time and near real time data warehousing?
Why do you get spool space errors? How do trouble-shoot them?
List the logical and conditional operators that are used with teradata along with their meanings?
How to Extract data from multiple legacy systems?
Explain the parallel data extension in teradata?
Explain some differences between mpp and smp?
What are teradata utilities?
Highlight a few of the advantages that ETL tools have over Teradata.