advanced code snippet search

Posted By

geekzspot on 12/01/12


Tagged


Versions (?)

Oracle Select Multiple Rows From DUAL

 / Published in: SQL
 

Select more than 1 row from Dual - useful for creating test data perhaps?

Expand | Embed | Plain Text 
  1. SELECT * FROM DUAL CONNECT BY ROWNUM <= 42; -- Create 42 rows from DUAL;

Report this snippet  

You need to login to post a comment.