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
11558 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

how to check server status with 'mysqladmin'? : Sql dba

1086

What does subquery mean in sql?

1061

Why are indexes and views important to an organization?

966

what is the stuff function and how does it differ from the replace function? : Sql dba

1062

Which is faster joins or subqueries?

995

What are sql constraints?

1183

Is grant a ddl statement?

905

How can you fetch common records from two tables?

1066

Why does sql need a server?

1048

Why use subqueries instead of joins?

1087

How do I start pl sql?

955

what is schema? : Sql dba

1054

Is drop table faster than truncate?

999

How many commands are there in sql?

1042

what is a composite key ? : Sql dba

1069