Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to generate n rows using SQL with dual?

PL SQL Advanced SQL
user-image
Question added by Ameen Hashir P N , Software Engineer , Emaratech
Date Posted: 2014/10/31
Upvote (0) Views (5) Followers (3) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
zaid ibrahim
by zaid ibrahim , IT Support , canadian medical centere

SQL> select log(2,365) x 2 from dual 3 / X

Usama Bin Sadiq
by Usama Bin Sadiq , Product Manager , OvacSol Private Limited

SELECT LEVEL  FROM DUAL CONNECT BY LEVEL <= :NUM;

Write Your Answer
More Questions Like This