select 'Quarter 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 / megha

5 Answers
11706 Views
Infosys, I also Faced
E-Mail Answers

Answer Posted / megha

select
'Quarter to '||to_char((to_date('01/01/'||substr(Src,2), 'dd/mm/rrrr')),'rrrr') as "Target"
from table

Is This Answer Correct ?

9 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Difference between truncate, delete and drop commands?

1145

what are the authentication modes in sql server? : Sql dba

1121

What is the main reason behind using an index?

1059

Can instead of triggers be used to fire once for each statement on a view?

1006

how to get help information from the server? : Sql dba

989

What pl/sql package consists of?

1135

Inline the values in PL/SQL, what does it mean.?

1275

How many sql databases can you have on one server?

1153

What are the different types of constraints?

1277

How many sql statements are used?

1072

What is the life of an sql statement?

1076

What is the execution plan in sql?

1070

How can one get sql*loader to commit only at the end of the load file? : aql loader

1117

Can we call procedure in select statement?

1110

What is sql procedures and functions?

1073