with data as (select 'Q10' as src from dual) select 'Qua

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 / abhiraj

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

Answer Posted / abhiraj

with data as (select 'Q10' as src from dual)
select
'Quarter to '||to_char((to_date('01/01/'||substr(Src,2), 'dd/mm/rrrr')),'rrrr') as "Target"
from data

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What normalization means?

982

What are the types of subqueries?

1057

What is user in sql?

1027

Can we use pl sql in mysql?

1019

Why is pl sql used?

990

What are reports usually used for?

1032

Can we join tables without foreign key?

966

What are views in sql?

995

What is cost in sql execution plan?

990

What is restrict in sql?

1122

Explain the uses of control file.

1051

What pl/sql package consists of?

1090

what are the disadvantages of mysql? : Sql dba

1149

Can we update views in sql?

942

Can a foreign key be null?

1093