SR 4 DB

create table hr.order_test (col_num number, col_var varchar2(32), col_date date) tablespace users; insert into hr.order_test (col_num,col_var,col_date) values (3,'C',SYSDATE); insert into hr.order_test (col_num,col_var,col_date) values (NULL,'G',SYSDATE); insert into hr.order_test (col_num,col_var,col_date) values (2,'B',SYSDATE); insert into hr.order_test (col_num,col_var,col_date) values (NULL,'E',SYSDATE); insert into hr.order_test (col_num,col_var,col_date) values (1,'A', SYSDATE); insert into hr.order_test (col_num,col_var,col_date) values (NULL,'F',SYSDATE); insert into hr.order_test (col_num,col_var,col_date) values (4,'D',SYSDATE); commit; --- Non ordered. SQL> SELECT * FROM hr.order_test;    COL_NUM COL_VAR                          COL_DATE ---------- -------------------------------- ---------          3 C                                20-FEB-15            G                                20-FEB-15  

SQL> create table hr . numbers (id number ) tablespace EXAMPLE ; Table created . SQL> insert into hr . numbers (id) values( 19 ); SQL>   insert into hr . numbers (id) values( 3 ); SQL>   insert into hr . numbers (id) values( 15 ); SQL> insert into hr . numbers (id) values( 9 ); SQL>   insert into hr . numbers (id) values( 21 ); SQL>   insert into hr . numbers (id) values( 7 ); SQL>   insert into hr . numbers (id) values( 17 ); SQL>   insert into hr . numbers (id) values( 1 ); SQL> insert into hr . numbers (id) values( 11 ); SQL>   insert into hr . numbers (id) values( 5 ); SQL> commit; Commit complete. SQL> select id from hr . numbers ;         ID ----------         19          3         15          9         21          7         17          1         11          5 10 rows selected . Common Mistake.   A common mistake is  we