Collections:
Create Tables for ODBC Connection Testing in Oracle
How To Create Tables for ODBC Connection Testing in Oracle?
✍: FYIcenter.com
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);
⇒ Verify Oracle TNS Settings in Oracle
⇐ Windows Applications Connect to Oracle Servers in Oracle
2016-10-15, 1647🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...