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
- 5 Answers
- 9713 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
Can we create clustered index without primary key?
What is difference between stored procedure and trigger?
How can we avoid duplicating records in a query?
What are the types of subqueries?
Which join is default?
What do you mean by rowid?
What are the various restrictions imposed on view in terms of dml?
what are dynamic queries in t-sql? : Transact sql
Can we use distinct and group by together?
What is a constraint? Tell me about its various levels.
What is memory optimized table?
How do you respond to dementia behavior?
How to write html code in pl sql?
What is sqlca in powerbuilder?
What are the main features of cursor?
