Interested to Buy Any Domain ? << Click Here >> for more details...
"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
- 9 Answers
- 12409 Views
- I also Faced
- E-Mail Answers
Answer Posted / babu
Hi All,
SELECT SUBSTR('PRAVALLI NAGIREDDY',POSITION('' IN 'PRAVALLI
NAGIREDDY')+1) FROM TABLE_NAME
THIS IS THE CORRECT ANSWER.
IN TERADATA THE FUNCTION INSTR IS NOT WORK.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the teradata primary index mechanics in detail with a diagram.
Mention a few of the ETL tools that come under Teradata.
Highlight the need for Performance Tuning.
What do you mean by tpt in teradata?
What is the maximum number of dml can be coded in a multiload script?
What are default access rights in teradata?
How to run a query in teradata?
What is a sparse index?
What are the different table types that are supported by teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What is real time and near real time data warehousing?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the purpose of joins in teradata and what are the available join types?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is the purpose of upsert command?
