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

Does sql between include endpoints?

952

What are the operators in sql?

970

What are the two types of exceptions in pl/sql?

965

Can we write dml inside a function in sql server?

899

How to take user input in pl sql?

1106

How do we use distinct statement? What is its use?

976

What is trigger explain it?

960

How to select unique records from a table?

999

How do I run a script in sql developer?

899

How do you change a value in sql?

965

What is materialized view. What are different methods of refresh?

1330

What are the two virtual tables available at the time of database trigger execution?

1157

What operating systems are supported by oracle sql developer?

903

How to connect a sql*plus session to an oracle server?

1080

how to get a list of columns in an existing table? : Sql dba

914