|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Estimados Lideres,
Nos complace informar el calendario de las Sesiones periódicas del Cinema Live, presentadas por expertos en Soluciones Oracle Cloud.
¡Esta es la oportunidad de compartir con sus usuarios contenidos relevantes!
Solicitamos su apoyo informando la fecha de cuando compartan el Cinema Live entre sus usuarios, así tendremos la posibilidad de evaluar los resultados de esta iniciativa.
Saludos cordiales,
|
Mes: marzo 2016
Oracle Hot Topics and News: Baddata Script To Check Database For Corrupt column data
Alerts
Alert
|
Product Area
|
Last Updated
|
Oracle Database – Standard Edition Oracle Database – Enterprise Edition
|
Mon, 28 Mar 2016 13:07 GMT-06:00
|
Knowledge Articles
Knowledge Article
|
Product Area
|
Last Updated
|
Oracle Database – Enterprise Edition
|
Tue, 29 Mar 2016 08:53 GMT-06:00
|
Oracle exige a Google una indemnización de 9.000 millones de dólares
![](https://static.betazeta.com/www.fayerwayer.com/up/2016/02/google.jpg)
Oracle Launches New SaaS, PaaS, and IaaS Cloud Services to Help Organizations in their Journey to the Cloud
Press Release
Powerful new cloud services help organizations leverage the latest in business transformation trends, including big data, social and mobileRedwood Shores, Calif.—Mar 24, 2016 Oracle today announced that it has expanded its cloud portfolio, releasing new Oracle Cloud services over the past several months to help companies transition to the cloud. The new services enhance the breadth and depth of Oracle’s extensive cloud portfolio across all layers of the stack—SaaS, PaaS, and IaaS.
With these new advancements, Oracle provides all of the cloud-based services that organizations need to capitalize on key transformative technologies such as big data analytics, social, mobile, and IoT, as well as continue to extend foundational use cases that enable organizations to move enterprise workloads to the cloud. Oracle continues to help organizations drive innovation and business transformation by increasing business agility, lowering costs, and reducing IT complexity. The new PaaS and IaaS services can be deployed wherever an organization chooses—in the Oracle Cloud or in their own data center via the Oracle Cloud at Customer offering.
“In today’s digital age, consumers are more informed, connected, and selective than ever before. As a result, technology providers need to offer highly personalized and secure cloud services in order to stay competitive,” said Thomas Kurian, president, Oracle. “With these new Oracle Cloud services, Oracle is enabling organizations to leverage the industry’s most flexible, proven, and secure cloud infrastructure. With it, organizations are able to enjoy the double benefit of moving their enterprise workloads to the cloud while providing their customers with highly innovative and accessible cloud-based services.”
Oracle Cloud Applications deliver the only complete suite of modern cloud applications that are integrated with social, mobile, and analytics. Oracle Cloud Applications help organizations deliver the experiences customers expect, the talent to succeed, and the performance the market demands. The latest additions to the portfolio include:
The Oracle Cloud Platform provides a complete suite of services to rapidly build and deploy rich applications—or extend Oracle Cloud SaaS applications—using an enterprise-grade cloud platform based on the industry’s #1 database and application server. The latest additions to the portfolio include:
Additionally, Oracle has added a number of new services to its IaaS portfolio:
The Oracle Cloud has shown strong adoption, supporting 70+ million users and more than 34 billion transactions each day. It runs in 19 data centers around the world.
|
Oracle Hot Topics and News: GI install fails with SEVERE: [FATAL] [INS-40911]
Knowledge Articles
Knowledge Article
|
Product Area
|
Last Updated
|
Oracle Database – Enterprise Edition
|
Fri, 25 Mar 2016 03:25 GMT-06:00
|
Oracle alerta sobre una vulnerabilidad grave en Java
Para qué participar en OTN TOUR LATINOAMERICA 2016.?
![](https://ronaldvargasquesada.wordpress.com/wp-content/uploads/2016/03/42d3c-yo_mano_guadalajara3.jpg?w=225&h=400)
Volviendo al tema del primer párrafo, este señor Muñoz, tuvo la «genial idea» de convocar a unos personajes sin importancia alguna, en los últimos 6 años, tales como Tom Kyte, Tim Hall, Debra Lilley, Arup Nanda, Graham Wood, Kuassi Mensah, Dana Singleterry, Ronald Bradford, Edward Roske, Roy Swonger, Daniel Morgan, Hans Forbrich, Bjoern Rost, Kyle Hailey y una veintena más de nombres y recorrer Latinoamericana compartiendo conocimiento y experiencias.
Oracle: El uso adecuado en la evaluación de variables BOOLEAN con valor NULO dentro de una condición CASE
La reproduzco totalmente a continuación como referencia, pero la pueden observar en el siguiente link: http://stevenfeuersteinonplsql.blogspot.com/2016/03/the-case-of-confusing-case.html
TUESDAY, MARCH 22, 2016
The Case of the Confusing CASE
What do you think will be displayed after executing the following block?
DECLARE
my_flag BOOLEAN;
BEGIN
CASE my_flag
WHEN my_flag IS NULL
THEN
DBMS_OUTPUT.PUT_LINE ('my_flag is NULL');
WHEN TRUE
THEN
DBMS_OUTPUT.PUT_LINE ('my_flag is TRUE');
ELSE
DBMS_OUTPUT.PUT_LINE ('my_flag is FALSE');
END CASE;
END;
/
At first glance (if you are like me), you would say «my_flag is NULL», right?
After all, my_flag is initialized to NULL when declared, and I don’t change the value.
But, lo and behold, you will see:
my_flag is FALSE
Curious, right?
So what’s going on? Well, we have a very confused and confusing piece of code: I have written a simple CASE (which is of the form CASE expression WHEN …), but then my WHEN clauses follow a typical searched CASE format (CASE WHEN expr1 … WHEN expr2 …).
CASE is a really wonderful feature in PL/SQL (and many other languages, of course), but you need to make sure you use it properly.
Definitivamente curioso el caso. Por supuesto no me pude quedar tranquilo y tuve que experimentar por cuenta propia como resolver el problema y la buena noticia es que lo encontré.
Veamos, partamos de definir el escenario. Mi máquina virtual con OEL 6.5 y Oracle Database 12c R1 12.1.0.2 SE2
SQL> select * from v$version;
SQL> set linesize 200
SQL> /
BANNER
——————————————————————–
Oracle Database 12c Standard Edition 2 Release 12.1.0.2 – 64bit
PL/SQL Release 12.1.0.2
CORE 12.1.0.2
TNS for Linux: Version 12.1.0.2
NLSRTL Version 12.1.0.2
El seudo código que responde de manera adecuada al problema planteado por Steven es el siguiente:
SQL> host more 10.sql
DECLARE
my_flag BOOLEAN;
BEGIN
CASE WHEN my_flag is NULL
THEN
DBMS_OUTPUT.PUT_LINE (‘my_flag is NULL’);
WHEN TRUE
THEN
DBMS_OUTPUT.PUT_LINE (‘my_flag is TRUE’);
ELSE
DBMS_OUTPUT.PUT_LINE (‘my_flag is FALSE’);
END CASE;
END;
/
SQL> @10
my_flag is NULL
PL/SQL procedure successfully completed.
SQL> host more 10.sql
DECLARE
my_flag BOOLEAN := TRUE;
BEGIN
CASE WHEN my_flag is NULL
THEN
DBMS_OUTPUT.PUT_LINE (‘my_flag is NULL’);
WHEN TRUE
THEN
DBMS_OUTPUT.PUT_LINE (‘my_flag is TRUE’);
ELSE
DBMS_OUTPUT.PUT_LINE (‘my_flag is FALSE’);
END CASE;
END;
/
Ejecutando el seudo código anterior
SQL> @10
my_flag is TRUE
PL/SQL procedure successfully completed.
Al probar con el seudo código original, el valor es incorrectamente devuelto.
SCRIPT ORIGINAL
SQL> DECLARE
2 my_flag BOOLEAN;
3 BEGIN
4 CASE my_flag
5 WHEN my_flag IS NULL
6 THEN
7 DBMS_OUTPUT.PUT_LINE (‘my_flag is NULL’);
8 WHEN TRUE
9 THEN
10 DBMS_OUTPUT.PUT_LINE (‘my_flag is TRUE’);
11 ELSE
12 DBMS_OUTPUT.PUT_LINE (‘my_flag is FALSE’);
13 END CASE;
14 END;
15 /
my_flag is FALSE
PL/SQL procedure successfully completed.
SQL>
Resumen:
La forma correcta de evaluar la condición de una variable con condición boleana en un CASE es utilizando la sintaxis:
…CASE WHEN my_flag is NULL THEN
y no
CASE my_flag WHEN my_flag IS NULL THEN
Latinoamerica OTN TOURA 2016 – Ingreso de propuestas para presentación
- Oracle Database Hacking Etico
La ética informática es el comportamiento en el uso de la tecnología informática que infringen la ley.
El delito informático, es un acto ilícito, son acciones ilegales realizados a través de conocimientos y tecnologías informáticas.
En esta charla, demostraré algunas brechas de seguridad que existen en la base de datos y como resolverlas.
- Oracle Database, Cómo correr y ejecutar correctamente una sentencia SQL en una base de datos Oracle
La regla #5 de Codd:
La regla comprensiva del sublenguaje de los datos: el sistema debe soportar por lo menos un lenguaje relacional que tenga una sintaxis lineal. Puede ser utilizado de manera interactiva.
Soporte operaciones de definición de datos, operaciones de manipulación de datos (actualización así como la recuperación), seguridad e integridad y operaciones deadministración de transacciones.
Él SQL ( Lenguaje estructurado de consulta ) es el lenguaje de programación lineal, que nos permite interactuar con la base de datos Oracle.
Pero sabemos con certeza, como el motor de la base de datos, interpreta y ejecuta estas sentencias.?
- Oracle Database Standard Edition 2, Single Tenant
Entendiendo, comprendiendo y sacando beneficio, de las nuevas características de arquitectura de la versión SE 2, que sustituye a las anteriores versiones Standard Edition y Standard Edition One en oracle Database 12c 12.1.0.1 y versiones inferiores.
FBI STOLEN IDENTITY REFUND FRAUD, Alert I-032316-PSA
March 23, 2016
I-032316-PSA
Local Field Office Locations:www.fbi.gov/contact-us/field
Tips to protect yourself:
- File tax returns as early as possible.
- Monitor your bank account statements regularly, as well and as your credit report at least once a year for any fraudulent activity.
- Report unauthorized transactions to your bank or credit card provider as soon as possible.
- Be cautious of telephone calls or e-mails that require you to provide your personal information, especially your birth date or social security number. If you are in doubt, do not provide the requested information.
- Do not open e-mail or attachments from unknown individuals. Additionally, do not click on links embedded in e-mails from unknown individuals.
- Never provide personal information of any sort via e-mail. Be aware, many e-mails requesting your personal information appear to be legitimate.
- If you use online tax services, ensure your bank account is accurately listed before and after you file your tax return.
- Ensure sensitive information is permanently removed from online tax software accounts that are no longer being used. Allowing online accounts to become dormant can be risky and make you more susceptible to tax fraud schemes.
- If you feel you are a victim, immediately contact the three major credit bureaus to place a fraud alert on your credit records.
- If you are a victim, file an Identity Theft Affidavit (IRS Form 14039). This form is available for download from www.identitytheft.gov.