Collections:
Other Resources:
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);
2016-10-15, 289👍, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...