Answer / sowmya makkena

select floor(months_between(sysdate,'22-mar-1995')) "age in months" from dual;

Answer / siddharthapenchala

select trunc(months_between(sysdate,'22-mar-1995')/12) as age from dual;

how to create a new table in mysql? : Sql dba

0 Answers  

---

Explain two easy sql optimizations.

0 Answers  

---

When should I use nosql database?

0 Answers  

---

What is blind sql injection?

0 Answers  

---

What do you understand by pl/sql packages?

0 Answers  

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---

What is character functions?

0 Answers  

---

Which are the different case manipulation functions in sql?

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

What is trigger in pl sql?

0 Answers  

---

can we update a view which is created from two tables

11 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---