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
11555 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 are character functions in sql?

944

How do you declare a constant?

968

What's the difference between a primary key and a clustered index?

994

Is ms sql traffic encrypted?

930

how many tables will create when we create table, what are they? : Sql dba

1086

How do I access sql anywhere database?

976

Can you skip header records while loading? : aql loader

1060

What is a sql statement?

975

What is break?

1203

Whis is not false in primary key?

1465

what is a cursor? : Sql dba

1031

How do you select unique values in sql?

1006

what are numeric data types? : Sql dba

1065

what is bcp? When is it used?

1124

What is a .db file?

992