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
11546 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 triggers stop a dml statement from executing on a table?

1102

How do we accept inputs from user during runtime?

1071

List different type of expressions with the example.

935

Why should I use postgresql?

1022

How do you declare a user-defined exception?

1029

What is a sql profiler?

1030

Why self join is used in sql?

980

What do you mean by query optimization?

1005

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

1033

How does index help in query performance?

1031

Is delete faster than truncate?

1003

Can we use threading in pl/sql?

1043

What is natural join in sql?

992

Is mariadb a nosql database?

1056

How do you optimize a stored procedure in sql?

960