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
- 9804 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
What is the difference between instead of trigger and after trigger?
What is a sql*loader control file?
What is pl sql in dbms?
what are different types of keys in sql?
Is sql easier than java?
How do I use google cloud in sql?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
How to process query result in pl/sql?
Is sql an operating system?
What is data manipulation language?
How do I write a sql query in pgadmin 4?
What is the use of count (*) in sql?
What is %type in pl sql?
What is a variable in sql?
