Create Tables for ODBC Connection Testing in Oracle

Q

How To Create Tables for ODBC Connection Testing in Oracle?

✍: FYIcenter.com

A

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/retneciyf
Connected.

SQL> CREATE USER fyi IDENTIFIED BY retneciyf ACCOUNT UNLOCK;
User created.

SQL> GRANT CREATE SESSION TO fyi;
Grant succeeded.

SQL> GRANT CREATE TABLE TO fyi;
Grant succeeded.

SQL> ALTER USER fyi DEFAULT TABLESPACE USERS;
User altered.

SQL> ALTER USER dev QUOTA 4M ON USERS;
User altered.

SQL> connect fyi/retneciyf;
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);

 

ODBC Drivers and DSN Configuration for Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 216👍, 0💬