Answer / megha

select
'Quarter to '||to_char((to_date('01/01/'||substr(Src,2), 'dd/mm/rrrr')),'rrrr') as "Target"
from table

Answer / ajit

select substr(src, 1,1 )||'uarter to '||to_char(to_date (substr(src, 2), 'rrrr'), 'yyyy') tgt
from <Table Name>

Answer / 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

Answer / aditya saxena @adi

select 'Quarter to '||to_char(to_date('01/01/'||substr(months,2),'dd/mm/rrrr'),'RRRR') AS Src_Tgt from (
select 'Q10' months from dual
union all
select 'Q90' from dual
union all
select 'Q80' from dual
union all
select 'Q74' from dual
)
;

Answer / manohar

select 'Quarter to' ||to_char(cast('1/1/'||substr(Src) as
char),'YYYY') from table

What is sql in java?

0 Answers  

What is oracle sql developer?

0 Answers  

Can we create index on primary key?

0 Answers  

What can be a size of a pl/sql block? Is there any limit?

2 Answers  

What are the benefits of stored procedures?

0 Answers  

Is left join faster than inner join?

0 Answers  

Differentiate between syntax and runtime errors.

0 Answers  

what is sql profiler

2 Answers   Fidelity,

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

Is there any restriction on the use of union in embedded sql?

0 Answers  

What are sql commands?

0 Answers  

Write a unique difference between a function and a stored procedure.

0 Answers