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  

---

What is implicit cursor in pl sql?

0 Answers  

---

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

---

What are pl/sql cursors?

0 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

---

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

what is an extent ? : Sql dba

0 Answers  

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

What is sql scripting?

0 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

what is schema? : Sql dba

0 Answers  

---