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
Answer Posted / megha
select
'Quarter to '||to_char((to_date('01/01/'||substr(Src,2), 'dd/mm/rrrr')),'rrrr') as "Target"
from table
Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
what are string data types? : Sql dba
How do I truncate a sql log file?
Explain what is a view?
What is difference between pls_integer and integer?
What is sql injection owasp?
What is trigger in sql?
What are the three forms of normalization?
Is pl sql useful?
What are inner outer left and right joins in sql?
What is a string data type in sql?
What makes a good primary key?
Can you sum a count in sql?
What does data normalization mean?
How can we store rows in PL/SQL using array?
What is dynamic query?