T11 Oracle

44 %
56 %
Information about T11 Oracle

Published on February 24, 2008

Author: rmonago

Source: slideshare.net

Description

Introducción al sistema gestor de base de datos Oracle

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Sistemas Gestores de Bases de Datos SGBD: ORACLE 9i ORACLE Básico ORACLE Avanzado Rmonago - SGBD T ORACLE -D1

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 SGBD: ORACLE básico ● Instalación ● Introducción y ejemplos de BD ● Sentencias básicas ● Funciones ● Totales y grupos ● Multitablas ● Subconsultas ● Modificación Rmonago - SGBD T ORACLE -D2

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Instalación ORACLE 9i ● Requisitos ● Pasos – Carpeta destino – Productos disponibles – Tipo de instalación – Configuración – Identificación – Ubicación ● Testear instalación Rmonago - SGBD T ORACLE -D3

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Introducción ● Arquitectura ● Instancia ● Conexión ● Almacenamiento: – TableSpace – DataFile ● Esquemas de bases de datos: – Scott – HR Rmonago - SGBD T ORACLE -D4

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Sentencias Básicas ● Select ● Operadores de comparación =,>,<,<>,<=,>=, any, some, all ● Operadores lógicos not,and,or, ● Otros Operadores In, not in, between, exists, is null. Like ● Expresiones case Rmonago - SGBD T ORACLE -D5

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Funciones ● Carácter: instr, length, replace, upper, lower,... ● Numéricas: abs, cos, sin, round, trunc,... ● Fecha: sysdate, current_date, extract,... ● Conversión: to_char,to_number, to_date,... Rmonago - SGBD T ORACLE -D6

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Totales y grupos ● Funciones de grupo: avg, count, max, ... Select count(*) From emp; ● Group by Select count(*) From emp Group by deptno; ● Having Select count(*) From emp Group by deptno Having count(*)>10; Rmonago - SGBD T ORACLE -D7

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Totales y grupos WHERE GROUP BY HAVING BASE DE M filas N filas P filas DATOS M > N > P Rmonago - SGBD T ORACLE -D8

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Multitablas ● Simples ● Complejas ● Producto cartesiano ● Join Natural, join on, ... (Con un campo en común) ● Conjuntos Union, intersect, minus,... (Sobre el mismo cjto de datos) Rmonago - SGBD T ORACLE -D9

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Subconsultas ● Una fila Select * From emp Where sal=(Select max(sal) From emp); ● Multiples filas Select * From emp Where detpno in (Select detpno From emp Where ename='John'); ● Correlacionadas ● Escalares Rmonago - SGBD T ORACLE -D10

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Modificación ● Insertar: filas,valores, copiar, actualizar,... Insert into ... values ... Insert into ... select ... ● Modificar:Actualizar, con selección, ... Update ... set ... [where ...] ● Eliminar:Filas, con subconsultas,.. Delete from... [where ...] ● Transacciones: operaciones, inicio, fin,.. Rmonago - SGBD T ORACLE -D11

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 Transacciones ● Transacciones: – Operaciones: ● Insert ... ● Update ... ● Delete ... – Confirmar: commit – Cancelar: rollback Rmonago - SGBD T ORACLE -D12

IES Augustógriga - Ciclos Informática 2º ASI - 2007/08 SGBD: ORACLE avanzado ● Creación de usuario ● Creación de un esquema ● Introducción al PL/SQL ● Tipos de datos y variables ● Estructuras de control ● Bucles Rmonago - SGBD T ORACLE -D13

Add a comment

Related presentations

Related pages

DATE_FORMAT - Oracle

The DATE_FORMAT command assigns a format template to the definition of an object that has a DATETIME, TIMESTAMP, TIMESTAMP_TZ, TIMESTAMP_LTZ, DSINTERVAL ...
Read more

Oracle DB Semantic Technologies Overview

Oracle Database 11g Semantic Technologies Bill Beauregard, Senior Principal Product Manager, Oracle USA. 2 ... /takes/t11.mov 2010-03-04:created seq100:sh1:t11
Read more

Transactions - 11g Release 2 (11.2) - Oracle Help Center

All Oracle transactions comply with the basic properties of a database transaction, known as ACID properties. ACID is an acronym for the following: ... t11 ...
Read more

Ask Tom "index fragmentation" - Oracle

Is it true that while doing a Range Scan Oracle reads only one block at a time. ... , Table t11 and indexes on table t11 are detailed below.
Read more

INCITS: T11 - Fibre Channel Interfaces

Groups » T11 - Fibre Channel Interfaces. T11 ... T11 is responsible for standards development in the areas of Intelligent Peripheral ... Oracle; Panduit ...
Read more

Orange County Los Angeles Oracle Training |Oracle R12 Apps ...

We Provide Oracle Applications Training – R12 Functional and Technical Courses – DBA, SOA Middleware, Developer Tools, ERP Project Management – Class ...
Read more

Oracle 11g: Change Database Name - Experts Exchange

Oracle 11g: Change Database Name. Posted on 2010-04-08 ... (SID_NAME=t11) (ORACLE_HOME=/dbms/app/ora cle/produc t/11.1.0/d b_1)) (SID_DESC= (SID ...
Read more

Using NPIV with Oracle VM Server for SPARC (The HyperTrap)

Using NPIV with Oracle VM Server for SPARC By Alexandre Chartre-Oracle on Apr 19, 2012 ... The exact definition, from the Technical Committee T11, ...
Read more

Ask Tom "how to export / import an SQL Profile

... LEADING(@"SEL$1" "T6"@"SEL$1" "T11"@"SEL$1" "T5"@"SEL$1" "T3"@"SEL$1" "T7"@"SEL$1" "T2"@"SEL$1" "T9 ... Oracle shall not be liable for any ...
Read more