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

can sql servers linked to other servers like oracle? : Sql dba

1054

what is the stuff function and how does it differ from the replace function? : Sql dba

1109

What is full join?

1022

Why do we use procedures?

1007

How to call shell script from pl sql procedure?

1359

What is rtm in testing?

1175

What is a scalar value in sql?

1126

What is a dynamic query?

1073

What are the types of join and explain each?

1103

What is restrict in sql?

1179

What is dense_rank?

989

How to load data with sql*loader?

1112

Are sql database names case sensitive?

1053

How many commands are in sql?

1121

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

1081