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
- 9726 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
What is latest version of sql?
What is pls_integer in pl sql?
Why we use sql profiler?
What are different types of queries in sql?
What are the steps for performance tuning.
What is a string data type in sql?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What are the popular database management systems in the it industry?
Why do we need pl sql?
Is merge a dml statement?
what are all the different types of indexes? : Sql dba
How can triggers be used for the table auditing?
Is sql open source?
what is sp_pkeys? : Transact sql
What is difference between hql and sql?
