Working With Oracle

Working With Oracle - Babbage& Oracle Access to Babbage...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Babbage & Oracle Access to Babbage c Oracle credentials are in oracle-details.txt r In the same location as your MySQL credentials (mysql- details.txt) CS 3380 c Connecting to Oracle r Use sqlplus from the Unix command line OR r Use SQL*Plus client software from Windows r Use SQL*Plus Worksheet client software from Windows sqlplus from Babbage [[email protected] ~]$ sqlplus jmg00d SQL*Plus: Release 10.1.0.2.0 - Production on Thu Apr 10 17:11:46 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. nter password: CS 3380 Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64-bit Production With the Partitioning, OLAP and Data Mining options SQL> Connecting with Windows Client Need a proper TNSNames.ora file: DBASE1. = (DESCRIPTION = (ADDRESS_LIST = DBASE1. = (DESCRIPTION = (ADDRESS_LIST = DBASE1. = (DESCRIPTION = (ADDRESS_LIST = DBASE1. = (DESCRIPTION = (ADDRESS_LIST = CS 3380 (ADDRESS = (PROTOCOL = TCP)(HOST = (ADDRESS = (PROTOCOL = TCP)(HOST = (ADDRESS = (PROTOCOL = TCP)(HOST = (ADDRESS = (PROTOCOL = TCP)(HOST = babbage.cs.missouri.edu)(PORT = 1521)) ) babbage.cs.missouri.edu)(PORT = 1521)) ) babbage.cs.missouri.edu)(PORT = 1521)) ) babbage.cs.missouri.edu)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = (CONNECT_DATA = (SERVICE_NAME = (CONNECT_DATA = (SERVICE_NAME = (CONNECT_DATA = (SERVICE_NAME = DBASE1) ) ) DBASE1) ) ) DBASE1) ) ) DBASE1) ) ) Or from the babbage webpage Oracle Connection Information c Server: babbage.cs.missouri.edu c Port: 1521 c Service Name: dbase1 CS 3380 c Connecting from other unix/linux systems $ sqlplus your_sso/[email protected]:1521/dbase1 Other methods exists c Download and install Oracle 9i client packages from OTN c Use third party application, i.e. TOAD c Set up ODBC driver connection and data source in CS 3380 windows and use MS Excel or Access Oracle Data Types c Similar to what we saw in MySQL r CHAR – Fixed Length string, 2000 max r VARCHAR 2 – Variable length string, 4000 max CS 3380 r LONG – Very long strings, up to 2 GB r NUMBER – Used for both integer and float r DATE – Data and Time Stamp r LOB – Large Object (CLOB/BLOB) Creating Tables c Same as MySQL except r Slightly different data types r Can name CONSTRAINTS when defining attributes...
View Full Document

{[ snackBarMessage ]}

Page1 / 28

Working With Oracle - Babbage& Oracle Access to Babbage...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online