"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
- 10938 Views
- I also Faced
- E-Mail Answers
Answer Posted / kiran kumar
Sel address,index(address,' ') as r,substr(address,r+1) from tablename;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is meant by a Clique?
What is a three-tier data warehouse?
What are normalization, first normal form, second normal form and third normal form?
Is multi insert ansi standard?
What are the commands to make a new table, change a table and remove a table in teradata?
Explain the term 'database' related to relational database management system?
What is the maximum number of dml can be coded in a multiload script?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are differences between teradata and ansi session modes in teradata?
Did you write stored procedures in teradata?
Differentiate database data and data warehouse data?
What are the steps to create a data model?
What are the functions of a teradata dba?
