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

Explain select statements in sql?

1058

What are the usages of sql?

1058

What is the most common sql injection tool?

1042

Why is normalization important?

1031

What is oracle pl sql developer?

984

Why is the cursor important?

1044

Why is partition used in sql?

1124

How do I kill a query in postgresql?

1130

Can we alter stored procedure?

989

How many types of normalization are there?

966

What does varchar include?

952

Is sql scripting language?

1055

What is pl sql package?

1034

Why we use pl sql?

962

What is rtm stands for?

1100