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
11419 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 are the types of subquery? : Sql dba

1066

What is the starting oracle error number? What is meant by forward declaration in functions?

956

Explain the the delete statements in sql?

1006

What is query optimization in sql?

950

What is sap sql?

942

Can we commit in trigger?

937

What is sqlcommand?

979

What is pl sql quora?

1093

How do I view a sql trace file?

974

What are the types of records?

967

what are the different type of normalization? : Sql dba

982

Explain what is an index?

1012

How do you modify a column in sql?

962

Differentiate between pl/sql and sql?

1091

how to run 'mysql' commands from a batch file? : Sql dba

1082