"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
Highlight the advantages of PPI(Partition Primary Index).
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?
Why managing the data is important?
What type of indexing mechanism do we need to use for a typical data warehouse?
any one answer me how they can analyzing the project using data ware housing?
What is upsert statement in teradata?
What are the things to be considered while creating secondary index?
What are the uses of bynets in multi-node systems?
What are the scenarios in which full table scans occurs?
If RDBMS is halted what will you do ?
What are normalization, first normal form, second normal form and third normal form?
Differentiate database data and data warehouse data?
Name the five phases that come under MultiLoad Utility.
what are the day to day activities of teradata DBA ?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?