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

how to load data files into tables with 'mysqlimport'? : Sql dba

1089

What is user defined functions?

960

how to use myisamchk to check or repair myisam tables? : Sql dba

965

how to show all tables with 'mysql'? : Sql dba

1106

How exception handling is done in advance pl/sql?

974

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1823

Write an sql query to select all records from the table?

1012

Why schema is used in sql?

1041

What are the types of join in sql?

1089

What is a database? Explain

1103

how to analyze tables with 'mysqlcheck'? : Sql dba

1004

What is compute?

1080

What is serial sql?

966

Can we use joins in subquery?

1155

What is #table in sql?

1082