Select empno, sal from emptbl where empno < 101.By this query can we fetc

Select empno, sal from emptbl where empno < 101.By this
query can we fetch first 100 recs? where empno is primary
key.It won't throw -811 error? if it wont,then what is use
of cursor technique while fetching first 100 recs.

Please need more clarification.

Question Posted / abuzar

2 Answers
5299 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? wh..

Answer / kingmanish

Yes this query will fetch multiple records.

If tried to fetch these records in variables in a sql query
it will give -811 error.

In order to be able to handle these multiple records we
have to use cursor.

Now using cursor we can process each of these records one
at a time and thus cursors come handu here.

Is This Answer Correct ?

6 Yes

0 No

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? wh..

Answer / madhu t

If the to fetch empno and sal from emptble is written in
embedded sql then it will give sqlcode -811.
yes this query fetches first 100 records of employee table.

Is This Answer Correct ?

3 Yes

1 No

Post New Answer