I was at the EnterpriseDB web site recently and noticed that the downloads have changed a bit. I no longer see a download for EnterpriseDB Express. If you remember a while back, I had found an annoyance with the installation of the express version.

Now you go right to the advance server download and get a messsage.

You have downloaded EnterpriseDB Advanced Server. Currently, EnterpriseDB Advanced Server 8.2 requires a Product Key in order to use the software above 1 CPU, 1 GB of memory, and 6GB of data.

According to this article in ComputerWorld, MySQL to get injection of Google code. Google has signed an agreement to contribute to MySQL (oddly enough called a contributer license agreement) and will contribute source code for a variety of technical items.
In a way, this can be considered a very strong endorsement of MySQL by Google. Google even has an engineer dedicated to working with MySQL and the MySQL development team. I didn’t realize that Google was such a heavy user of MySQL. Google will contribute some code related to replication and monitoring.

A few days ago, I posted an entry, Anchored Declarations – %TYPE and %ROWTYPE. That article talked about using anchored declarations in your PL/SQL code.

PeteF ask a couple of questions about that post:

Inglés:

Nice little article – I have a couple of questions… Is there any way to utilise the %rowtype attribute from within a trigger i.e. can I easily populate a rowtype variable with all the old (or new) columns in one shot? Number two – is there an easy way to write the rowtype variable back to the DB without having to mention every column name?

Cuando se declara una variable, hay que darle un tipo de datos y de un tamaño.

Vamos a suponer por un momento que tengo una tabla que se parece a esto:

SQL> desc employees Name                                      Null?    Type ----------------------------------------- -------- ---------------------------- EMPLOYEE_ID                               NOT NULL NUMBER(6) FIRST_NAME                                         VARCHAR2(20) LAST_NAME                                 NOT NULL VARCHAR2(25) EMAIL                                     NOT NULL VARCHAR2(25) PHONE_NUMBER                                       VARCHAR2(20) HIRE_DATE                                 NOT NULL DATE JOB_ID                                    NOT NULL VARCHAR2(10) SALARY                                             NUMBER(8,2) COMMISSION_PCT                                     NUMBER(2,2) MANAGER_ID                                         NUMBER(6) DEPARTMENT_ID                                      NUMBER(4)SQL> 

Podría crear un pl/sql- código de la unidad que acceder a algunas de estas columnas.

Hotsos has released its Profiler extension for SQL Developer. The extension is free but you must have a license for the profiler for the extension to do you any good.

The profiler works almost like the Explain Plan tool in SQL Developer. Enter the text you want to profile, press a key and then view the output.

You do need access to the trace files that are generated. The page linked above had instructions on how to enable access and what permissions you need.

A neat feature is that you can save profiling sessions for historical access.

City University of New York (CUNY) has standardized on PeopleSoft Financials, Human Capital and Campus Solutions. Of course, all of this will be running on Oracle 11g and, eventually, Fusion.

“We chose Oracle to provide the highest quality service and advanced solutions to accommodate our institutions’ various sizes and non-traditional programs,” said Brian Cohen, CUNY’s chief information officer and co-project leader for CUNY FIRST. “We chose Oracle’s PeopleSoft Enterprise Campus Solutions 9.0 for the new capabilities this version offered and look forward to leveraging it to transform our student information system.”

CUNY selected Oracle due to the functionality and scalability of its applications – vital factors considering CUNY’s unique composition of senior and community colleges and other programs and institutions – and the number of PeopleSoft implementations within higher education institutions in the U.S.

Como es posible que puedas decir, no soy un experto español. Quería crear un blog para que más personas puede ayudar a empezar con Oracle por lo que optaron por crear un blog que se escribe en español. Yo uso el traductor Google herramienta para crear este blog de escritos que he hecho en inglés.

Entonces, mi pregunta es, ¿encontraste esta página útil? Aun con la mala gramática? ¿Le gustaría a mí seguir con la publicación?

Gracias de antemano por su respuesta. Soy consciente de que tomar el tiempo para hacerlo.

LewisC

Una base de datos de enlace es la forma de Oracle le permite conectarse desde una base de datos a otro. Un enlace a la base de datos de una base de datos remota utilizando una ID y una contraseña al igual que un usuario, pero sólo permite el acceso programático.

Base de datos permitirá a los vínculos de procesamiento distribuido. Replicación es un excelente ejemplo de una aplicación que utiliza la base de datos enlaces. Replicación de bases de datos Oracle utiliza vínculos con el movimiento de datos de una base de datos a otro.

Un vínculo es una base de datos en un solo sentido conducto que le permita realizar LMD contra bases de datos remotas al igual que lo haría en contra de una base de datos local.

Usted podrá declarar NVARCHAR2 lugar de VARCHAR2. NVARCHAR2 se utiliza para almacenar los conjuntos de caracteres Unicode. Yo, personalmente, nunca han tenido un uso para NVARCHAR2. Si escribir aplicaciones multilingües y utilizar un juego de caracteres Unicode, en lugar de utilizar NVARCHAR2 VARCHAR2. CHAR también tiene un correspondiente NCHAR.

Largo restricciones son las mismas que un VARCHAR2 y UTF8 puede almacenar 32767 dividido por 2 y UTF16 puede almacenar 32767 dividido por 3. No se puede mezclar y combinar VARCHAR2 NVARCHAR2 y las variables. Usted debe escoger uno o el otro y se pegan con él. Ambos están disponibles en SQL y PL / SQL.

CHAR es una longitud fija de datos. Si no se especifica un tamaño máximo, el valor por defecto es 1. El tamaño máximo para un carácter en una columna es de 2000 bytes y 32767 en PL / SQL.

Yo bastante considerar CHAR a ser un legado de datos. Algunas personas utilizan CHAR (1) para almacenar indicadores (Y, N, etc) o como una tabla BOOLEAN. Prefiero usar VARCHAR2 incluso en esos casos.

Un caso que puede estar justificada (en mi opinión, de todos modos, esta es mi opinión) sería rellenar los datos desde o hacia un modelo de informe que tendrá que ser reproducida.

DATE El dato es un dato fecha. Almacena una fecha y una hora. La fecha parte se basa en el número de días desde el 1 de enero de 4712 aC. El tiempo se basa en el número de segundos desde mediados de la noche.

Un campo de fecha se declara como una variable seguida por el nombre DATE palabra clave:

v_date_field DATE;

No hay “correcto” el formato de una fecha. El formato está determinada por varios factores. En la base de datos, se puede establecer que la NLS_DATE_FORMAT.

Oracle tried to buy Bea, Bea slapped them down, Oracle responds:

October 12, 2007
Board of Directors
BEA Systems, Inc.
2315 North First Street
San Jose, CA 95131

Dear Members of the Board of Directors:
As discussed with your management team, Oracle remains available to discuss and complete a transaction quickly and efficiently.

We believe that it is important to clarify the sequence of activities that have transpired over the past few days. Upon receipt of Bill Klein’s letter dated October 11, I contacted him to address any process concerns.

Oracle today announced the contribution and a preview release of an enhanced Oracle Call Interface (OCI8) database driver for PHP. This helps bring breakthrough scalability to PHP applications, further enhancing PHP as a viable development environment for mission-critical applications. The OCI8 database driver for PHP supports important Oracle® Database features such as connection pooling and fast application notification, enabling a single industry-standard server to support tens of thousands of database connections while providing higher availability.

The enhanced OCI8 database driver for PHP provides new, improved integration between PHP and Oracle Database 11g, to allow a server-side connection pool shareable across web servers and languages, significantly enhancing the scalability of web-based systems.

Oracle won the CMP Channel VARBusiness 2007 Tech Innovator award in the Business Enterprise category for the Oracle SOA Suite. The SOA Suite is part of Oracle Fusion. SOA Suite is Oracle’s answer to web services and service oriented architecture.

oracle award

When it comes to data issues (too many rows, no data found, etc), in Oracle stored procedures, I am used to having exceptions raised that I then handle. PL/pgSQL does not raise exceptions for the same conditions in the same way. The Postgres docs are pretty complete though and through some reading this weekend, I discovered a new keyword.
For example, assuming that I have this table (which is empty) in both Oracle and Postgres:

CREATE TABLE empty_table
(
  empty_col integer
);

In Oracle this procedure:

CREATE OR REPLACE PROCEDURE no_data_found_test
AS
  v_int_field INTEGER;
BEGIN

  SELECT empty_col
    INTO v_int_field
    FROM empty_table;

END;

When run:

BEGIN
  no_data_found_test;
END;

Produces an error:

Error starting at line 1 in command:
BEGIN
  no_data_found_test;
END;
Error report:
ORA-01403: no data found
ORA-06512: at "HR.NO_DATA_FOUND_TEST", line 6
ORA-06512: at line 2
01403. 

I recently wrote a blog entry (on my Postgres blog) about hiding SQL in a stored procedure, Hiding SQL in a Stored Procedure. I decided to see if I could convert that same concept to a MySQL stored procedure.



It doesn’t work exactly the same. For one, the syntax is a little different. I expected that and the syntax differences really aren’t that bad. Minor tweaks really.



The second issue is the major one. While I could write the proc and return a result set, I am not, as far as I can tell, able to treat the procedure as a table.

NVL2 es una pequeña función aseada del SQL que pienso soy underused. Se parece a mí que podría tener un nombre mejor.

El formato es NVL2 (expr1, expr2, expr3). Qué lo hace es si expr1 es NULL, él vuelve expr3. Si expr1 NOT NULL, vuelve expr2.

IF la declaración para hacer igual parecería:

IF expr1 IS NULL THEN   expr3ELSE  expr2END IF

Tiendo para conseguir expr2 y expr3 al revés cada vez que utilizo esta función. No soy seguro porqué.

Hoy, voy a darte una extremidad de Oracle para conseguir librado de espacios después de que hayas utilizado TO_CHAR:

Si funciono esta escritura:

select to_char(1234.89, ‘$999,990.00′) num_format
from dual
/

select to_char(SYSDATE, ‘Day, Month DD, YYYY’) date_format
from dual
/

Consigo:

NUM_FORMAT
————
$1,234.89

1 row selected.

DATE_FORMAT
—————————–
Friday , August 14, 2006

1 row selected.

¿Notas el plomo el espaciar en la primera declaración y el espaciamiento impar en el segundo?

Eso puede ser molesto. Conseguir libró de él, uso justo el modificante de la máscara del formato de FM.

Ahora puedo funcionar esto:

Y consigo:

NUM_FORMAT
————
$1,234.89

1 row selected.

DATE_FORMAT
—————————–
Friday, August 14, 2006

1 row selected.

Awesome picture over San Fran.

oracle planes

I read about the Postgres LiveCD at the Blue Gnu.
That’s such a good idea! I don’t know why we don’t see more LiveCDs. Even commercial software should be taking advantage of such an easy marketing opportunity.
The entry says:

Well, what can I say? The CD is simply Xubuntu with PostgreSQL loaded up and ready to run. And once loaded, you can actually play with PostgreSQL at least three different ways. The Xubuntu CD offers three icons that launch the Command-Line client, PGAdmin3 or phpPGAdmin. Now you can play with the server for as long as you like, goof it up and reboot for a clean, shiny new server.

Yesterday, Postgres made it to Mashable, today it got a mention in E-Commerce Times, Open Source for Business: Now More Than Ever, Part 1.
The article isn’t about Postgres specifically. It’s about business targeted OSS uptake in the enterprise. There’s an “open source roundup” “based on the recommendations of business leaders”.
The Postgres entry:

Postgresql: PostgreSQL is an open source relational database system. It runs on all major operating systems, including Linux, Unix (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64) and Windows. It is fully ACID (Atomicity, Consistency, Isolation, Durability) compliant, has full support for foreign keys, joins, views, triggers and stored procedures (in multiple languages).

Bob Zurek of EnterpriseDB posted a blog entry today titled, “We slammed into a brick wall with MySQL“. If you read his blog entry, the information he is referencing is in this press release, FortiusOne Migrates GeoCommons Intelligent Mapping Website to EnterpriseDB Advanced Server.
If you read that press release, it says:

“We slammed into a brick wall with MySQL,” said Chris Ingrassia, chief technology officer, FortiusOne. “As an example, MySQL’s rather limited and incomplete spatial support dramatically impacted performance. We were looking for an affordable database solution, but we required enterprise-class features and performance that MySQL simply couldn’t deliver.

Mashable posted a SQL TOOLBOX: 20+ Tools and Lessons About SQL.

While there are a lot more links to MySQL, at least Postgres made the list. The description isn’t exactly the best I have seen though, “PostgreSQL.org – An open source database system developed on SQL.”

I’ve been to some of these sites and they aren’t exactly the best around. Some are old. There are a couple of really good ones though.
The Comparison of different SQL implementations seems pretty well maintained and covers Oracle, Postgres, MySQL, DB2, & SQL Server.
Check it out.
LewisC

postgresql media

Do you do GEO? If you do, you’ve probably at least heard of PostGIS, the Postgres GIS extension. PostGIS just gave EnterpriseDB a big win over its open source competition.

FortiusOne leads the market towards the next generation of Web mapping. Its breakthrough Intelligent Mapping technologies offer rich information visualization on maps and unprecedented access to geographic data. FortiusOne innovations include: high-speed Web-based geographic analysis tools, a flexible and scalable Web services platform supporting the special needs of geographic data, and an innovative application of social networking techniques to geographic knowledge creation.

FortiusOne’s main product is GeoCommons.

¿Cuál es SQL?

El SQL se compone de DML y de DDL. DML son las palabras claves que utilizas tener acceso y manipular a datos, por lo tanto la lengua de manipulación de datos conocida. DDL son las palabras claves que utilizas crear objetos tales como opiniónes, tablas y procedimientos, por lo tanto el idioma de definición de datos conocido. Los ejemplos de DML son SELECT, UPDATE, INSERT, MERGE, DELETE, etc. Los ejemplos de DDL son CREATE TABLE, ALTER VIEW, CREATE OR REPLACE PROCEDURE, el etc.

Ejemplo DDL:

CREATE TABLE whatever (   column1 NUMBER NOT NULL PRIMARY KEY,   column2 VARCHAR2(10),   column3 DATE );

Ejemplo DML:

INSERT INTO whatever (column1, column2, column3)  VALUES (1, 'Text Data', sysdate );

SELECT column1, column2, column3  FROM whatever;

COMMIT;

¿Cuáles son comandos del SQL?

Los comandos del SQL son los comandos que no son realmente una parte del estándar del SQL pero son apoyados por las herramientas que apoyan el SQL.