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>

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

What is the purpose of a sql?

0 Answers  

---

What is parallel hint?

0 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

What is trigger in sql and its types?

0 Answers  

---

Is big data nosql?

0 Answers  

---

When the mutating error will comes? and how it will be resolved?

2 Answers  

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

How to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

How do I get sql certification?

0 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---