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 / ajit
select substr(src, 1,1 )||'uarter to '||to_char(to_date (substr(src, 2), 'rrrr'), 'yyyy') tgt
from <Table Name>
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is data control language? : Sql dba
What is the best partition size for windows 10?
How much does sql certification cost?
What is varchar used for?
Why we use cross join?
Who is the owner of mysql database?
What is the difference between database trigger and stored procedure?
What is a pragma statement?
What are the packages in pl sql?
What are functions in sql?
What is the execution plan in sql?
Is sql a programming?
What is the file extension for sql database?
What is trigger in sql and its types?
how to fetch alternate records from a table? : Sql dba