>>>Is there any SQL command that have similiarly function like
>>>ROWNUM?, example:
>>>
>>>"SELECT ROWNUM as ORDER, TITLE FROM BOOK ORDER BY ROWNUM"

>
> No, there isn't.
>

A roundabout way:

select gen_id(ROWNUM_COUNTER, 1) as ORDER, TITLE FROM BOOK ORDER BY 1"

eMeL