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
11712 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 is data control language? : Sql dba

1068

What is the best partition size for windows 10?

1050

How much does sql certification cost?

1142

What is varchar used for?

1139

Why we use cross join?

1002

Who is the owner of mysql database?

1108

What is the difference between database trigger and stored procedure?

1141

What is a pragma statement?

1336

What are the packages in pl sql?

1067

What are functions in sql?

997

What is the execution plan in sql?

1070

Is sql a programming?

1028

What is the file extension for sql database?

1065

What is trigger in sql and its types?

1113

how to fetch alternate records from a table? : Sql dba

1172