Answer Posted / ramaprasad

select rownum from emp;
select max(rownum) from emp;

declare
cursor c1(dpno emp.deptno%type)is select * from emp where
deptno=dpno;
i c1%rowtype;
begin
open c1(dpno);
loop
fetch c1 into i ;
exit when c1%notfound;
dbms_output.put_line(c1%rowcount);
end loop;
close c1;
end;

what are the different type of normalization? : Sql dba

1022

---

Which join is default?

944

---

What are database links used for?

1035

---

What is the difference between cluster and non-cluster index?

1099

---

What is function and procedure?

1023

---

explain about mysql and its features. : Sql dba

1008

---

What is multiple columns?

1054

---

What is an alias command?

1052

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2136

---

How to use sql*plus built-in timers?

1178

---

Define union, minus, union all, intersect ?

996

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

944

---

What are some emotional triggers?

972

---

discuss about myisam index statistics collection. : Sql dba

939

---

What is sql lookup?

910

---