select substr("pravalli nagireddy",instr("pravalli nagiredd

"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

Question Posted / gvk

Answer Posted / gvk

select substr("pravalli nagireddy",instr("pravalli
nagireddy",' '),10)from <tablename>

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Name the five phases that come under MultiLoad Utility.

982

Is multi insert ansi standard?

2201

Why teradata is used?

996

Explain teradata architecture?

1083

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1159

What is the primary index in teradata?

1193

What is a dimension table?

1054

What tools would you use for that?

1103

What are the 5 phases in a multiload utility?

1029

Comment whether bottleneck is an error or not.

1147

What does Amp contain and what are all the operations that it performs?

995

Explain teradata vs. Redshift?

1009

What is TPD?

1366

What is the use of teradata system software?

1032

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2412