select substr(src, 1,1 )||'uarter to '||to_char(to

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

Question Posted / ajit

5 Answers
11526 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

Please Help Members By Posting Answers For Below Questions

what's the difference between a primary key and a unique key? : Sql dba

1040

Explain cursor types?

1018

How to run sql statements with oracle sql developer?

1057

Why we use join in sql?

957

What is primary key and unique key?

1112

how to write date and time literals? : Sql dba

956

What is the use of index in hive?

1000

How to write a query to show the details of a student from students table whose

992

What are the basic techniques of indexing?

1057

What is foreign key sql?

982

Why is the cursor important?

1035

explain about mysql and its features. : Sql dba

1013

Does sql support programming?

1064

What is the sql case statement?

987

What are the benefits of pl/sql packages?

1103