Write a query to genarate target column.Please answer me.
Advance Thanks.
Src Tgt
Q10 Quarter to 2010
Q90 Quarter to 1990
Q80 Quarter to 1980
Q74 Quarter to 1974
- 5 Answers
- 9774 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / ajit
select substr(src, 1,1 )||'uarter to '||to_char(to_date (substr(src, 2), 'rrrr'), 'yyyy') tgt
from <Table Name>
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is sql sequential or random?
What is a dirty read sql?
What are the different types of constraints?
What is composite data type in pl sql?
What is sqlservr exe?
What is sql server and ase?
How many unique keys can a table have?
Is primary key always clustered index?
What is auto increment feature in sql?
Which is better join or subquery?
How do we use distinct statement? What is its use?
What are pl/sql cursors?
how can we repair a mysql table? : Sql dba
What are the usages of sql?
What is sql*loader?
