select 'Quarter to '||to_char(to_date('01/01/'||substr(

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 / aditya saxena @adi

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

Answer Posted / aditya saxena @adi

select 'Quarter to '||to_char(to_date('01/01/'||substr(months,2),'dd/mm/rrrr'),'RRRR') AS Src_Tgt from (
select 'Q10' months from dual
union all
select 'Q90' from dual
union all
select 'Q80' from dual
union all
select 'Q74' from dual
)
;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different set operators available in sql?

1080

What sql database should I use?

1194

What has stored procedures in sql?

1104

How can we find duplicate records in a table?

992

What is difference between stored procedures and application procedures?

1067

What is the difference between union and union all command?

1151

How to write html code in pl sql?

1160

How do you use collections in procedure to return the resultset?

2286

How do you delete duplicates in sql query using rowid?

989

Is pl sql useful?

1037

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1146

How to return multiple rows from the stored procedure?

1015

What is memory optimized?

1135

Explain normalization and what are the advantages of it?

1000

how to add a new column to an existing table in mysql? : Sql dba

1114