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, 1377🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...