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, 1387🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...