<div>
SQL&gt; select level from dual 
&nbsp; 2 &nbsp;connect by level &lt;= 10; 
 
&nbsp; &nbsp; &nbsp;LEVEL 
---------- 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9 
&nbsp; &nbsp; &nbsp; &nbsp; 10
</div>

SQL> select level from dual
  2  connect by level <= 10;

     LEVEL
----------
         1
         2
         3
         4
         5
         6
         7
         8
         9
        10

<div>
<div class="content wysiwyg-content">
hi 
 
I am trying to understand what 'connect by' is. 
 
 
CREATE TABLE t ( 
rid NUMBER(12), 
col1 VARCHAR2(30), 
col2 VARCHAR2(300)); 
 
CREATE SEQUENCE seq_t_rid; 
 
INSERT INTO t 
SELECT seq_t_rid.NEXTVAL, dbms_crypto.randombytes(15), dbms_crypto.randombytes(150) 
FROM DUAL 
CONNECT BY LEVEL &lt;= 1000; &nbsp;-- what does CONNECT BY do ? 
 
thanks
</div>
</div>

hi 

I am trying to understand what 'connect by' is.


CREATE TABLE t (
rid NUMBER(12),
col1 VARCHAR2(30),
col2 VARCHAR2(300));

CREATE SEQUENCE seq_t_rid;

INSERT INTO t
SELECT seq_t_rid.NEXTVAL, dbms_crypto.randombytes(15), dbms_crypto.randombytes(150)
FROM DUAL
CONNECT BY LEVEL <= 1000; -- what does CONNECT BY do ?

thanks

connect by

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.