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

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

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight the advantages of PPI(Partition Primary Index).

559


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1614


Why managing the data is important?

588


What type of indexing mechanism do we need to use for a typical data warehouse?

612


any one answer me how they can analyzing the project using data ware housing?

2025






What is upsert statement in teradata?

609


What are the things to be considered while creating secondary index?

626


What are the uses of bynets in multi-node systems?

584


What are the scenarios in which full table scans occurs?

534


If RDBMS is halted what will you do ?

1705


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

623


Differentiate database data and data warehouse data?

583


Name the five phases that come under MultiLoad Utility.

584


what are the day to day activities of teradata DBA ?

5360


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1497