Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Create Tables for ODBC Connection Testing

By: FYIcenter.com

(Continued from previous topic...)

How To Create Tables for ODBC Connection Testing?

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);

(Continued on next topic...)

  1. What Is Open Database Communication (ODBC)?
  2. How To Install Oracle ODBC Drivers?
  3. How To Find Out What Oracle ODBC Drivers Are Installed?
  4. How Can Windows Applications Connect to Oracle Servers?
  5. How To Create Tables for ODBC Connection Testing?
  6. How To Verify Oracle TNS Settings?
  7. How To Define a Data Source Name (DSN) in ODBC Manager?
  8. How To Connect MS Access to Oracle Servers?
  9. How To Connect ASP Pages to Oracle Servers?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...