"pravalli nagireddy" record is there in address column but i
want display only 'nagireddy' from the main string what is
query for that pls tell me
Answer Posted / ankal
sel substr('pravalli nagireddy', index('pravalli nagireddy','n'));
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the purpose of using case expression in teradata?
What is a sparse index?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Describe the set operators in teradata.
Explain the term 'tables' related to relational database management system?
What is meant by a Virtual Disk?
What is meant by a Clique?
Highlight the need for Performance Tuning.
How you will check the version of teradata?
What is the purpose of upsert command?
How do you do backup and recovery in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain fastload in teradata?
Highlight the advantages of PPI(Partition Primary Index).
What are the available join types in teradata?