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
- 10640 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / abhiraj
with data as (select 'Q10' as src from dual)
select
'Quarter to '||to_char((to_date('01/01/'||substr(Src,2), 'dd/mm/rrrr')),'rrrr') as "Target"
from data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of triggers exist in pl/sql?
What is optimistic concurrency control? : Transact sql
How do I install microsoft sql?
What is the difference between an inner join and an outer join?
How many sql are there?
How do I view a view in sql?
what is meant by nl2br()? : Sql dba
Can we use the cursor's to create the collection in PL/SQL?
Write the command to remove all players named sachin from the players table.
What are different types of functions in sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is cartesian join in sql?
Can we create table in function?
How to Declare Fixed Length String Value In PL SQL
How can use stored procedures in sql?
