select 'Quarter to' ||to_char(cast('1/1/'||substr(Sr

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 / manohar

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

Answer Posted / manohar

select 'Quarter to' ||to_char(cast('1/1/'||substr(Src) as
char),'YYYY') from table

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are ddl statements in mysql? : Sql dba

1111

explain mysql aggregate functions. : Sql dba

939

What is your daily office routine?

2213

What is an emotional trigger?

928

Can you join views in sql?

896

Is sqlite thread safe?

990

What is AUTH_ID and AUTH_USER in pl/sql ?

2135

Can we delete column in sql?

1020

What is cursor and why it is required?

1105

how to get a list of all tables in a database? : Sql dba

916

what is data control language? : Sql dba

955

How to change the order of columns in Oracle SQL Plus ?

992

What is the purpose of normalization?

995

Could you please provide oca (oracle 10g) dumps for my certification ?

5069

List the different type of joins?

997