selftest q's doubt

Helo guru's

I had small doubts, may be it's trival too.

Please remind me, How the following statements are true:

1. "Imiplicit cursors process only one row at a time" Eg. Suppose a delete statement wipe off 10 rows from a table. This case How many rows are processes?, Is't 10 rows or 1 row?
2. "When using an ORDER BY clause to sort the rows returned by a query,  the sort limit is the number of columns that exist in the tables(s) listed in the FROM clause." Eg. Assume that a table t having 2 columns c1, c2. In this case i can do the following query: sql> select c1, c2, c1||'a', 'abc' from t order by 1,2,3,4; Here the table having only 2 columns, however i can able to sort in a query upto the number of columns exists in the select list.

If so, how come quoted statement becomes true?.

Is i'm missing something?.

PS:. These hints got from the selftest.

Rgds,
Nirmal. Received on Sat Nov 17 2001 - 09:24:56 CST