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;

what is sql.

7 Answers   Ericsson, Hewitt,

---

Can sql function call stored procedure?

0 Answers  

---

What is query syntax?

0 Answers  

---

what is explain plan?

4 Answers  

---

what is meant by tuning and tk proof?

2 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

What is sql data?

0 Answers  

---

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

0 Answers  

---

how to do backup entire database? : Transact sql

0 Answers  

---

What operators deal with null?

0 Answers  

---

What is trigger with example?

0 Answers  

---