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
11346 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 trigger price?

922

What are all the different types of indexes?

1090

What is duration in sql profiler trace?

1019

Explain the difference between drop and truncate commands in sql?

959

What is difference between sql and excel?

1005

Can we join two tables without common column?

928

Why do we create stored procedures & functions in pl/sql and how are they different?

887

What is trigger in sql and its types?

989

Is json a nosql?

914

What are the query optimization techniques?

885

Which tcp/ip port does sql server run?

955

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1381

What is exit statement?

955

What are properties of the transaction?

957

How do you concatenate in sql?

972