Answer Posted / 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
)
;

how to concatenate two character strings? : Sql dba

1110

---

How do you update sql?

994

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1003

---

what is index? : Sql dba

1010

---

What is difference between joins and union?

1136

---

How do I upgrade sql?

1008

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1140

---

How many rows can sqlite handle?

1124

---

How many developers work on postgresql?

989

---

What are the properties of a transaction?

1131

---

how to see the create table statement of an existing table? : Sql dba

1026

---

How many joins can you have in sql?

947

---

Which join is like an inner join?

1033

---

Show how functions and procedures are called in a pl/sql block.

1136

---

How to execute a stored procedure?

1100

---