SQL> CREATE TABLE students (ID NUMBER, NAME VARCHAR2(10), surname VARCHAR2(10)) tablespace test;
Table created.
SQL> select * from students;
no rows selected
SQL> insert into students values(1,'aa','bb');
1 row created.
SQL> insert into students values(2,'cc','dd');
1 row created.
SQL> insert into students values(1,'aa','bb');
1 row created.
SQL> insert into students values(2,'cc','dd');
1 row created.
SQL> insert into students values(1,'aa','bb');
1 row created.
SQL> insert into students values(2,'cc','dd');
1 row created.
SQL> select * from students;
ID NAME SURNAME
---------- ---------- ----------