Oracle query to break one row into multiple rows in sql

There are often the requirement of writing complex queries where one row needs to be divided into multiple rows in one sql statements. The "connect by" keywords could be used in such cases.

select level from dual connect by level < 10;