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>

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

What is sql and also describe types of sql statements?

0 Answers  

---

What are primary key and foreign key and how they work?

0 Answers  

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

---

Is sql between inclusive?

0 Answers  

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---

Is primary key is clustered index?

0 Answers  

---

what is a trigger? : Sql dba

0 Answers  

---

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---