If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here:

SQL> CONNECT system/retneclgg

Connected.

SQL> CREATE USER ggl IDENTIFIED BY retneclgg ACCOUNT UNLOCK;

User created.

SQL> GRANT CREATE SESSION TO ggl;

Grant succeeded.

SQL> GRANT CREATE TABLE TO ggl;

Grant succeeded.

SQL> ALTER USER ggl DEFAULT TABLESPACE USERS;

User altered.

SQL> ALTER USER dev QUOTA 4M ON USERS;

User altered.

SQL> connect ggl/retneclgg;

Connected.

SQL> CREATE TABLE dev_faq (id NUMBER);

SQL> INSERT INTO dev_faq VALUES (3);

SQL> INSERT INTO dev_faq VALUES (5);

SQL> INSERT INTO dev_faq VALUES (7);