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

What is time based sql injection?

900

What is not null in sql?

984

what is an index? : Sql dba

929

what is dbms? : Sql dba

931

Do stored procedures prevent sql injection?

918

explain the difference between myisam static and myisam dynamic. : Sql dba

884

Why stored procedures are faster than query?

968

What is record type in pl sql?

935

how can we submit a form without a submit button? : Sql dba

916

Are null values same as that of zero or a blank space?

966

How to read/write files from pl/sql?

992

What is composite primary key in sql?

938

What is posting?

990

What is the use of sqlerrd 3?

889

what is the use of double ampersand (&&) in sql queries?

1115