Sea el esquema gráfico de un modelo relacional de una bbdd: * Crear las tablas resultantes utilizando SQL estándar y estableciendo las restricciones de integridad necesarias. CREATE TABLE Libros (Nro_referencia INTEGER , Isbn` CHAR(13) NOT NULL, Titulo CHAR(50) , Precio NUMERIC(10), Tema CHAR(50), Autor CHAR(50) PRIMARY KEY (Nro_referencia), CHECK (Precio>=0), CHECK (Tema IN (‘Filosofia’,’Matematicas’,’Economia’)) [...]
Posted in Oracle, SQL on Feb 10th, 2010 1 Comment »
Vía: http://download-west.oracle.com/docs/cd/B12037_01/server.101/b12171/toc.htm#i788193 Alphabetic List of SQL*Plus Commands @{url | file_name[.ext]} [arg ...] <=> Muy usado para ejecutar un fichero sql o pl/sql @@ { url | file_name[.ext] } [arg ...] <=> ejecución anidada en comandos / (slash) ACC[EPT] variable [NUM[BER] | CHAR | DATE | BINARY_FLOAT | BINARY_DOUBLE] [FOR[MAT] format] [DEF[AULT] default] [PROMPT text | [...]
* Sintaxis SELECT [ { DISTINCT | UNIQUE } | ALL ] Lista_seleccion FROM referencia_tabla [ , referencia_tabla] … [ WHERE condicion] [{ clausula_consulta_jerarquica | clausula_group_by } [ clausula_consulta_jerarquica | clausula_group_by ] … ] [ UNION | UNION ALL | INTERSECT | MINUS } ( subconsulta ) ] [ clausula order_by ] Nota: [ ] [...]
Consultar los tablespaces en Oracle 11g. google_ad_client = “pub-3342677773387543″; /* 125×125, creado 18/01/10 */ google_ad_slot = “4305427894″; google_ad_width = 125; google_ad_height = 125; – Lanzo el SQLplus del host donde reside el servidor de Oracle 11g. vía ssh. Y me conecto con el usuario sys como sysdba $ ssh usuario@servidor-oracle-o-ip sqlplus … usuario: sys as [...]
Posted in Oracle, hacking on Feb 9th, 2010 No Comments »
Oracle Security Alert for CVE-2010-0073 Unscheduled Oracle Security Alert for CVE-2010-0073 was released on February 4, 2010. Oracle strongly recommends applying the patches as soon as possible. The Critical Patch Update Advisory is the starting point for relevant information. It includes a list of products affected, pointers to obtain the patches, a summary of the [...]
