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 column?

0 Answers  

---

Is left join faster than inner join?

0 Answers  

---

Differentiate pl/sql and sql?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

What is sql comments?

0 Answers  

---

Wat is SGA ?

3 Answers   ABB,

---

What are system versioned tables?

0 Answers  

---

Is t sql a programming language?

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

Types of joins ?

11 Answers   Polaris, TCS,

---

What are different types of joins ?

5 Answers   BirlaSoft,

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---