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

Does truncate remove indexes?

1020

What is sql engine in oracle?

982

How run sql*plus commands that are stored in a local file?

1052

How to get list of all tables from a database?

1147

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1049

How do I add a database to sql?

1119

What are the datatypes available in pl/sql ?

1095

Is primary key a clustered index?

963

Why is stored procedure faster than query?

948

How to sort the rows in sql.

1060

Why do we use joins?

1029

What is cte?

968

How do you write an index?

962

How do sql triggers work?

1031

How do you delete duplicates in sql query using rowid?

937