select substr("pravalli nagireddy",10,9) from <table

"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 / chandu

Answer Posted / chandu

select substr("pravalli nagireddy",10,9) from <table_name>

Is This Answer Correct ?

11 Yes

6 No

Please Help Members By Posting Answers For Below Questions

what is object level locking ? where do appear this type of locking ?

3462

What are the scenarios in which full table scans occurs?

973

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2128

what are the day to day activities of teradata DBA ?

5780

What is meant by Teradata Gateway?

1036

What is the purpose of joins in teradata and what are the available join types?

1036

Explain PDE.

1045

What are normalization, first normal form, second normal form and third normal form?

1020

Difference between stored procedure and macro?

1134

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1117

What is meant by a dispatcher?

979

What are types of partition primary index (ppi) in teradata?

1021

Explain the teradata primary index mechanics in detail with a diagram.

936

What can be achieved by using the teradata rdbms?

1008

What do you mean by tpt in teradata?

982