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

Which one is better subquery or joins?

0 Answers  

in procedure how to return a value

3 Answers   Wipro,

Why do we use sql constraints? Which constraints we can use while creating database in sql?

0 Answers  

What are different types of joins ?

5 Answers   BirlaSoft,

How can I get the number of records affected by a stored procedure?

0 Answers  

what is overloading procedure or overloading function ?

3 Answers   Genpact,

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

What is type and rowtype in pl sql?

0 Answers  

What is the non-clustered index in sql?

0 Answers  

How to update salary of employees department wise?

6 Answers  

Explain two easy sql optimizations.

0 Answers  

What is autocommit sql?

0 Answers