Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generating numbers 1 to 10 from empty table.

DBQuestApr 1 2016 — edited Apr 1 2016

Hi,

I have a table DEPT with columns deptno number, deptname VARCHAR2(50).

This DEPT table is empty.

I want to generate numbers from 1 to 10 using DEPT table.

I have tried select level from myemp connect by level <= 10;

but its not working.

Please advise.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2016
Added on Apr 1 2016
11 comments
2,892 views