Answer / pandu

Hi the above posted Querry is wrong


this is Correct

Select * from TableName
where rowid in(
Select rowid from TableName
where rownum =&upto(EX <=100,200
minus
select rowid from TableName
where rownum<=&from(EX =1,101)
)

Answer / padma

select top 100 * from <tablename>

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

what is the different between now() and current_date()? : Sql dba

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

Is left join faster than inner join?

0 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

What happens when a trigger is associated to a view?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

How do I run a pl sql program?

0 Answers  

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

What are character functions?

0 Answers  

---

How can we find duplicate records in a table?

0 Answers  

---