Oracle University preparará a profesores en República Dominicana gracias a firma de convenio con el Gobierno

República Dominicana firma un convenio, a través de su Ministerio de Educación Superior, Ciencia y Tecnología (MESCYT) y Oracle Academy.

Este acuerdo permitirá preparar a hasta 100 profesores en Programación Java y Base de Datos SQL y beneficiar a sus estudiantes que luego también tendrán acceso a estas herramientas tecnológicas.

"Tenemos que empezar hoy a preparar a nuestros niños con habilidades que les den más posibilidades para aprovechar las oportunidades de la economía digital", indicó en su cuenta de linkedin Sandra Guazotti, Senior Vice President Multi Country Region de Oracle Latin America at Oracle

#oraclechanginglives

Oracle Hot Topics: Bug 29379932 - LINUX: Improve Sequential Read Performance for Encrypted Files by Page Clustering

Bugs

Bug	Product Area	Bug ID	Last Updated
ORA-600[KDLRCI_GET_INLINE_DATA] MOVING ROW BETWEEN PARTITIONS WITH DIFF LOB TYPE	Oracle Database - Enterprise Edition	24944660	Sun, 18 Aug 2019 03:17 GMT-06:00

Knowledge Articles

Knowledge Article	Product Area	Last Updated
Bug 29379932 - LINUX: Improve Sequential Read Performance for Encrypted Files by Page Clustering	Oracle Database - Enterprise Edition	Fri, 16 Aug 2019 00:54 GMT-06:00

Oracle Costa Rica, en busca de Consultores Funcionales

Costa Rica !!! Únete a Oracle como Consultor Funcional. Utiliza tu espíritu emprendedor y tu experiencia previa en implementación ERP para participar en nuestros proyectos estratégicos en Centro América.

Envía tu CV a maria.cristina.rey@oracle.com y a alejandra.oliva@oracle.com para ser considerado.

Cosas que se debemos conocer y tener en background, antes de ver el documental de Netflix sobre Cambridge Anatíca:

Cambridge Analytica (CA) fue una compañía privada que combinaba la minería de datos y el análisis de datos con la comunicación estratégica para el proceso electoral.

La empresa fue creada en 2013 como una rama de la casa matriz Strategic Communication Laboratories (SCL), para participar en la política estadounidense, pero también lo hicieron en otros países, con una inversión de 15 millones de dólares por parte del republicano Robert Mercer y Steve Bannon

En 2015, la empresa se reveló como la compañía de análisis de datos que trabajó para la campaña presidencial de Ted Cruz. En 2016, tras el fracaso de la candidatura de Cruz, CA trabajó para la campaña presidencial de Donald Trump.

El Parlamento Británico, vincula a la empresa trabajando con el PRO y Mauricio Macri en 2015, luego de revelar que SCL Group, nombre legal de Cambridge Analytica, elaboró una campaña anti-kirchnerista en mayo de 2015, cuando Mauricio Macri y Daniel Scioli se disputaban la presidencia de Argentina.​ Además influyó en la campaña para la retirada del Reino Unido de la Unión Europea.

Mercer es definido como un científico de la computación y director ejecutivo de Renaissance Technologies, un fondo de alto riesgo que usa algoritmos para influir en los mercados financieros, y que le ha hecho multimillonario.

Mercer comenzó a trabajar para IBM Research a finales de 1972 en el Centro Watson de Investigación de Yorktown (NY), donde desarrolló una técnica de traducción automática estadística.

Bannon es un ejecutivo de medios estadounidense, figura política, ex banquero de inversiones y ex presidente ejecutivo de Breitbart News. Se desempeñó como estratega jefe de la Casa Blanca en la administración del presidente de los Estados Unidos Donald Trump, durante sus primeros siete meses de mandato hasta el 18 de agosto 2017, cuando fue despedido.

Después de dejar la Casa Blanca, Bannon ha hecho campaña y ha ayudado a varios movimientos políticos europeos de derecha y extrema derecha. Estos incluyen el Frente Nacional de Francia,3​ la Fidesz de Hungría y la Alternativa para Alemania, entre otros.

Alternativa para Alemania, incluye en su programa electoral el rechazo al euro, a los rescates a los países periféricos y la defensa de la vuelta al marco alemán.

Además de ser un partido populista y de ultraderecha., varios de sus integrantes han hecho declaraciones que han sido calificadas de racistas​ y xenófobas.

Su defensa del nacionalismo alemán ha hecho que algunos medios hayan comparado a AfD con el neonazismo.

Ahora si, a ver el documental.

Home Improvement Specialist Builds Better Customer Experiences with Oracle

Press Release 

Home Improvement Specialist Builds Better Customer Experiences with Oracle 

Nicaragua-based SINSA uses Oracle Retail to drive better understanding of customer needs and inventory control 

Managua, Nicaragua and REDWOOD SHORES, Calif.—Aug 14, 2019 

SINSA, the largest home improvement retailer in Nicaragua, has tapped Oracle Retail as the foundation to deliver superior customer experiences and propel growth. In business for nearly 30 years, the family-owned retailer operates 24 retail stores and wholesale properties, offering 65,000+ SKUs in 15 categories of home improvement products and services for the remodeling, construction, decoration and electrical industries. By adopting Oracle Retail technology, the Do-it-Yourself (DIY) retailer can now provide improved customer service through better inventory control. 

“Innovation is at the core of our DNA and SINSA is constantly looking at how we can improve our operations,” said Roger Vargas, continuous improvement manager, SINSA. “Our focus is to better serve the customer with improved inventory control and transition all processes to digital, which is key to gaining agility in the modern retail environment. The Oracle Retail project has been transformational, we are delivering on our vision to become more agile and satisfy our customer’s needs through a digital transformation process that starts by analyzing our processes, making adjustments and adopting a modern platform that can help us reduce risks and bring scalability to our business units as we continue to grow.” 

SINSA has four business units, with retail accounting for 75 percent of company sales, followed by project and engineering services, wholesale, and car battery distribution. The SINSA store operation has a unique style where customers can negotiate the cost of products with the sales associate. Within a specific range, the associate can offer a discount, which contributes to delivering an even more exciting and dynamic shopping experience. Customers can choose from store pick up and distribution center (DC) pick up, as well as create quotations and come on a later date to process those quotations into sales. As such, providing associates with the latest information on their buyers and store inventory is critical. 

“Retailers need to move beyond just selling what they buy and architect business processes that consider every attribute associated with items, orders, inventory and customers. When data is spread across disparate systems, customer profiles are incomplete. It is necessary for retailers to build informed workflows by mining buyer attributes to build comprehensive customer profiles. Oracle delivers a platform for modern retail that informs and executes; providing the agility companies like SINSA require to keep pace with the changing needs of their business,” said Mike Webster, senior vice president, and general manager, Oracle Retail. 

While the project is still in its early days, SINSA is already able to point to operational improvements. For example, the increased degree of detail at the item level is helping improve the efficiency of replenishment in warehousing. SINSA also reduced the wait time in stores by 33 percent using modern Point of Sale systems, which has positively impacted customer satisfaction. Through a CRM focused in retail, SINSA now has a detailed view of customer needs and can provide a personalized shopping experience. 

“Technology needs to support this dynamic environment at the store level, and our in-house system required modernization. With Oracle Retail, all associates can access transactions anywhere including on their computers or from their mobile phones,” said Edwin Gonzalez Mendoza, IT manager, SINSA. “We adapted payment options and a store operation process to fit our customer service model. The new hybrid on-premise and cloud infrastructure brought us the right combination to gain the speed and agility we needed in our business.” 

SINSA implemented Oracle Retail Merchandising System, Oracle Retail Merchandise Financial Planning, Oracle Retail Xstore Point-of-Service, Oracle Retail Customer Engagement, Oracle Retail Order Broker, and Oracle ERP Cloud with help from Oracle PartnerNetwork Platinum level partner SkillNet. SkillNet provided local resources with language capabilities, in-depth knowledge of the retail industry, and Oracle Retail solution expertise. 

Contact Info 

Kris Reeves

Oracle

+1.925.787.6744

kris.reeves@oracle.com

Cómo conocer el último registro ingresado en una tabla en Oracle, sin tener un campo TIMESTAMP?

A ver, una forma simple de como saber el último registro que ha sido insertado en una tabla.

Para ello vamos a crear una tabla de pruebas y vamos a ingresar algunos registros. Para que nos sirva de validación visual, crearemos una columna tipo DATE y otra con un valor de una secuencia. La tercera columna es relleno.

Connected.
SQL> drop table t;
drop table t
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> create table t ( fecha date, secuencia number, string varchar2(50));

Table created.

SQL> create sequence n_consecutivo;

Sequence created.

SQL> insert into t values ( sysdate, n_consecutivo.nextval, sysdate||n_consecutivo.nextval);

1 row created.

SQL> insert into t values ( sysdate, n_consecutivo.nextval, sysdate||n_consecutivo.nextval);

1 row created.

SQL> insert into t values ( sysdate, n_consecutivo.nextval, sysdate||n_consecutivo.nextval);

1 row created.

SQL> insert into t values ( sysdate, n_consecutivo.nextval, sysdate||n_consecutivo.nextval);

1 row created.

SQL> insert into t values ( sysdate, n_consecutivo.nextval, sysdate||n_consecutivo.nextval);

1 row created.

SQL> commit;

Commit complete.

Veamos el contenido de la tabla.
SQL> select * from t;

FECHA                SECUENCIA STRING
------------------- ---------- -----------------------
13-08-2019 14:58:10          1 13-08-2019 14:58:101
13-08-2019 14:58:15          2 13-08-2019 14:58:152
13-08-2019 14:58:17          3 13-08-2019 14:58:173
13-08-2019 14:58:18          4 13-08-2019 14:58:184
13-08-2019 14:58:20          5 13-08-2019 14:58:205

El método utilizando el rownum, no nos sirve de nada.

SQL> select * from t where rownum = ( select max(rownum) from t);

no rows selected

SQL> select max(rownum) from t;

MAX(ROWNUM)
-----------
          5

SQL> select * from t where rownum = 5;

no rows selected

Las seudocolumnas con información de SCN, tampoco nos sirven, porque van variando según el último cambio generado en alguno de los registros de la tabla.

SQL> select ora_rowscn,scn_to_timestamp(ora_rowscn),fecha, secuencia, string from t;

ORA_ROWSCN SCN_TO_TIMESTAMP(ORA_ROWSCN)        FECHA                SECUENCIA STRING
---------- ----------------------------------- ------------------- ---------- ---------------------
3.9824E+10 13-AUG-19 02.58.19.000000000 PM     13-08-2019 14:58:10          1 13-08-2019 14:58:101
3.9824E+10 13-AUG-19 02.58.19.000000000 PM     13-08-2019 14:58:15          2 13-08-2019 14:58:152
3.9824E+10 13-AUG-19 02.58.19.000000000 PM     13-08-2019 14:58:17          3 13-08-2019 14:58:173
3.9824E+10 13-AUG-19 02.58.19.000000000 PM     13-08-2019 14:58:18          4 13-08-2019 14:58:184
3.9824E+10 13-AUG-19 02.58.19.000000000 PM     13-08-2019 14:58:20          5 13-08-2019 14:58:205

SQL> insert into t values ( sysdate, n_consecutivo.nextval, sysdate||n_consecutivo.nextval);

1 row created.

SQL> commit;

Commit complete.

SQL> select ora_rowscn,scn_to_timestamp(ora_rowscn),fecha, secuencia, string from t;

ORA_ROWSCN SCN_TO_TIMESTAMP(ORA_ROWSCN)         FECHA                SECUENCIA STRING
---------- ------------------------------------ ------------------- ---------- ---------------------
3.9824E+10 13-AUG-19 03.02.13.000000000 PM      13-08-2019 14:58:10          1 13-08-2019 14:58:101
3.9824E+10 13-AUG-19 03.02.13.000000000 PM      13-08-2019 14:58:15          2 13-08-2019 14:58:152
3.9824E+10 13-AUG-19 03.02.13.000000000 PM      13-08-2019 14:58:17          3 13-08-2019 14:58:173
3.9824E+10 13-AUG-19 03.02.13.000000000 PM      13-08-2019 14:58:18          4 13-08-2019 14:58:184
3.9824E+10 13-AUG-19 03.02.13.000000000 PM      13-08-2019 14:58:20          5 13-08-2019 14:58:205
3.9824E+10 13-AUG-19 03.02.13.000000000 PM      13-08-2019 15:02:13          6 13-08-2019 15:02:136

6 rows selected.

Pero si utilizamos el ROWID, ahí podemos obtener la información que andamos buscando.
SQL> select * from t where rowid in(select max(rowid) from t);

FECHA                SECUENCIA STRING
------------------- ---------- ---------------------
13-08-2019 15:02:13          6 13-08-2019 15:02:136

SQL> insert into t values ( sysdate, n_consecutivo.nextval, sysdate||n_consecutivo.nextval);

1 row created.

SQL> commit;

Commit complete.

SQL> select ora_rowscn,scn_to_timestamp(ora_rowscn),fecha, secuencia, string from t;

ORA_ROWSCN SCN_TO_TIMESTAMP(ORA_ROWSCN)          FECHA                SECUENCIA STRING
---------- ------------------------------------- ------------------- ---------- ---------------------
3.9824E+10 13-AUG-19 03.04.01.000000000 PM       13-08-2019 14:58:10          1 13-08-2019 14:58:101
3.9824E+10 13-AUG-19 03.04.01.000000000 PM       13-08-2019 14:58:15          2 13-08-2019 14:58:152
3.9824E+10 13-AUG-19 03.04.01.000000000 PM       13-08-2019 14:58:17          3 13-08-2019 14:58:173
3.9824E+10 13-AUG-19 03.04.01.000000000 PM       13-08-2019 14:58:18          4 13-08-2019 14:58:184
3.9824E+10 13-AUG-19 03.04.01.000000000 PM       13-08-2019 14:58:20          5 13-08-2019 14:58:205
3.9824E+10 13-AUG-19 03.04.01.000000000 PM       13-08-2019 15:02:13          6 13-08-2019 15:02:136
3.9824E+10 13-AUG-19 03.04.01.000000000 PM       13-08-2019 15:04:02          7 13-08-2019 15:04:027

7 rows selected.

SQL>  select * from t where rowid in(select max(rowid) from t);

FECHA                SECUENCIA STRING
------------------- ---------- ---------------------
13-08-2019 15:04:02          7 13-08-2019 15:04:027

SQL>

SQL> select * from t order by rowid;

FECHA                SECUENCIA STRING
------------------- ---------- ---------------------
13-08-2019 14:58:10          1 13-08-2019 14:58:101
13-08-2019 14:58:15          2 13-08-2019 14:58:152
13-08-2019 14:58:17          3 13-08-2019 14:58:173
13-08-2019 14:58:18          4 13-08-2019 14:58:184
13-08-2019 14:58:20          5 13-08-2019 14:58:205
13-08-2019 15:02:13          6 13-08-2019 15:02:136
13-08-2019 15:04:02          7 13-08-2019 15:04:027

7 rows selected.

Que pasa si actualizamos un registro 'X' en la tabla.?
SQL> update t
  2  set fecha=sysdate
  3  where secuencia=2;

1 row updated.

SQL> commit;

Commit complete.

SQL> select ora_rowscn,scn_to_timestamp(ora_rowscn),fecha, secuencia, string from t;

ORA_ROWSCN SCN_TO_TIMESTAMP(ORA_ROWSCN)           FECHA                SECUENCIA STRING
---------- -------------------------------------- ------------------- ---------- --------------------
3.9824E+10 13-AUG-19 03.16.07.000000000 PM        13-08-2019 14:58:10          1 13-08-2019 14:58:101
3.9824E+10 13-AUG-19 03.16.07.000000000 PM        13-08-2019 15:16:08          2 13-08-2019 14:58:152
3.9824E+10 13-AUG-19 03.16.07.000000000 PM        13-08-2019 14:58:17          3 13-08-2019 14:58:173
3.9824E+10 13-AUG-19 03.16.07.000000000 PM        13-08-2019 14:58:18          4 13-08-2019 14:58:184
3.9824E+10 13-AUG-19 03.16.07.000000000 PM        13-08-2019 14:58:20          5 13-08-2019 14:58:205
3.9824E+10 13-AUG-19 03.16.07.000000000 PM        13-08-2019 15:02:13          6 13-08-2019 15:02:136
3.9824E+10 13-AUG-19 03.16.07.000000000 PM        13-08-2019 15:04:02          7 13-08-2019 15:04:027

7 rows selected.

Con la actualización no tenemos ningún problema.

SQL> select * from t order by rowid;

FECHA                SECUENCIA STRING
------------------- ---------- --------------------
13-08-2019 14:58:10          1 13-08-2019 14:58:101
13-08-2019 15:16:08          2 13-08-2019 14:58:152
13-08-2019 14:58:17          3 13-08-2019 14:58:173
13-08-2019 14:58:18          4 13-08-2019 14:58:184
13-08-2019 14:58:20          5 13-08-2019 14:58:205
13-08-2019 15:02:13          6 13-08-2019 15:02:136
13-08-2019 15:04:02          7 13-08-2019 15:04:027

7 rows selected.

SQL> select * from t where rowid in(select max(rowid) from t);

FECHA                SECUENCIA STRING
------------------- ---------- --------------------
13-08-2019 15:04:02          7 13-08-2019 15:04:027

SQL>

Software Player Parlays Oracle Autonomous Database to Speed Retail Operations

Press Release 

Supply-chain SaaS powerhouse JASCI uses latest Oracle database to supercharge processes for customers 

Redwood Shores, Calif.—Aug 13, 2019 

JASCI Software, a leader in cloud supply-chain, is leveraging Oracle’s Autonomous Database technology, continuing to innovate and scale its SaaS platform. With the world’s first self-driving database, JASCI’s enterprise customers are able to process twice as many orders at half the labor costs, which is critical to success in an industry where profit margins are razor thin. 

With Oracle Autonomous Transaction Processing, JASCI can scale and secure real-time order fulfillment processing to meet customers’ ever-growing demands for expedited and smarter order delivery. The database provides the flexibility to instantly scale up CPU and storage capacity for seasonal or spikes in demand. Additionally, JASCI is now able to allocate IT resources more strategically, enabling employees to focus on delivering supply chain expertise to customers while the database tunes, patches and upgrades itself, helping ensure security of critical customer data and availability of the system. 

Businesses need a technology platform that accelerates their supply chains–helping process orders quickly and accurately to keep up with the demanding delivery expectations of modern consumers. With Oracle Autonomous Transaction Processing running on Oracle’s next-generation cloud infrastructure, JASCI has the performance, scalability and reliability to handle huge volumes of transactions, deliver sub-second response times, and protect sensitive customer data. 

“Today’s greatest challenge is meeting customer demands for order fulfillment. Speed is no longer a luxury, but a requirement,” said Craig Wilensky, CEO, JASCI. “With Oracle Autonomous Database, we are creating a new status quo for our industry so our customers can deliver their goods faster and successfully compete in the age of next-day shipping.” 

JASCI’s all-in-one SaaS platform embeds AI into its applications to provide customers with real-time visibility into their warehouse, inventory, orders, labor and shipping. With Oracle Autonomous Database, JASCI has seen transaction times up to 100x faster, a key measurement in real-time environments. 

“Retailers need a platform that can instantly process orders to meet the demand for fastest possible delivery to their doorstep,” said Juan Loaiza, executive vice president of mission-critical database technologies, Oracle. “Oracle Autonomous Database enables companies like JASCI to grow their platform, handle trillions of transactions, and scale elastically to accommodate peak processing demands without downtime.” 

Oracle Autonomous Database builds on 40 years of experience supporting the majority of the world’s most demanding applications. Oracle Autonomous Database uses ground breaking machine learning to provide self-driving, self-repairing, and self-securing capabilities to enable customers to innovate more, pay less, and ensure the safety of their data.

 

Additional Resources

Learn more about JASCI

Learn more about Oracle Autonomous Database

Follow Oracle Database via Blog, Facebook and Twitter

Contact Info 

Nicole Maloney

Oracle

+1.650.506.0806

nicole.maloney@oracle.com

Oracle Hot Topics: ORA-7445 [KAFGEX1] AFTER TTS IMPORT

Bugs

Bug	Product Area	Bug ID	Last Updated
ORA-7445 [KAFGEX1] AFTER TTS IMPORT	Oracle Database - Enterprise Edition	10226927	Mon, 12 Aug 2019 08:28 GMT-06:00

Apparel Group Fuels Amazing Growth Trajectory with Oracle

Press Release 

Global fashion and lifestyle retailer streamlines operations to gain a single view of the truth, from inventory to financials 

DUBAI, UAE and REDWOOD SHORES, Calif.—Aug 12, 2019 

Global fashion retail conglomerate Apparel Group has selected Oracle to help meet its long-term strategic, financial, and operational goals. With a growing portfolio of more than 75 brands, catering for millions of customers in its 1,750 stores, Apparel Group will use Oracle technology to streamline processes across departments, to launch new brands and expand into different geographies. 

“Successful retailers need to be able to gain complete visibility across their operations, from merchandising and inventory down to financials,” said Nilesh Ved, Founder, Apparel Group. “Oracle will provide us with a single, global version of the truth and real-time view of inventory and profitability across our vast array of channels and brands. Not only will this enable us to operate smarter, but also elevate the omnichannel experience we are providing our customers.” 

Tech Mahindra, an Oracle PartnerNetwork Platinum level member, delivered an end to end implementation of Oracle Retail Merchandising Operations Management Suite integrated with Oracle Human Capital Management (HCM) Cloud and Oracle Enterprise Resource Planning (ERP) Cloud. Additionally, the Apparel Group rolled out Oracle Retail Xstore Point-of-Service and Oracle Retail Store Inventory Management in over 700 stores under the brands like Charles & Keith, Aldo, Ardene, Garage, Rituals, HEMA, Dollar Plus, and more. The Oracle Retail stores solutions will continue to be rolled out to the rest of the stores in the next couple of months. With a foundation for growth established, Apparel Group will apply the power of data science against their assortment by implementing Oracle Retail Merchandise Financial Planning, Oracle Retail Assortment Planning, and Oracle Retail Merchandising Insights. 

“Oracle provides a modern, end-to-end platform for retailers to grow and evolve. Our purpose-built solutions easily integrate across the Oracle portfolio to deliver a global competitive advantage,” said Mike Webster, senior vice president and general manager, Oracle Retail. “With our integrated or hybrid cloud solutions, retailers like Apparel Group can drive value securely and at scale.” 

Contact Info 

Kris Reeves

Oracle PR

+1.925.787.6744

kris.reeves@oracle.com

GroundBreakers Tour 2019 Costa Rica: Serie Oracle Hacking Etico: 3 maneras distintas en como un DBA puede robar tu idéntidad, sin que te des cuenta

Me han aceptado una tercera charla para el Oracle GroundBreakers Tour 2019 en Costa Rica.

Esta charla que la había anunciado, la voy a dar de primero en el evento el 21 de Agosto y luego la replicaremos por redes sociales para el resto de la gente que no pueda acompañarnos ese día o que se encuentre fuera del país.

Serie Oracle Hacking Etico Capítulo #3: 3 maneras distintas, en como un DBA puede robar la idéntidad en una base de datos Oracle Enterprise Edition 19c.

La seguridad sigue siendo un desafío de tiempo completo en nuestras compañías. Cada vez más, existe información que se comparte en foros de discusión, redes sociales y blogs, de como violar la seguridad de un sistema. Cada vez más, existen carreras universitarias, que brindan el background requerido para formar Hackers que luego tomaron el camino del sombrero negro, gris o blanco. Es necesario que conozcamos las vulnerabilidades y exposiciones que sufren nuestros sistemas, para estar preparado y no sufrir un apocalipsis.

Ni la más reciente versión de base de datos Oracle, se salva. Siempre habrá una puerta trasera que podrá ser explotada.

Más info: oraugcrc.com

My Oracle Support Site Alert: Planned Maintenance to My Oracle Support Portal on Friday August 2, 2019

My Oracle Support Portal will be undergoing maintenance on Friday August 2, 2019 starting at 9:00 PM Pacific Time (Saturday August 3, 2019 at 4:00 AM GMT/UTC) and ending on Saturday August 3, 2019 at 2:00 AM Pacific Time (Saturday August 3, 2019 at 9:00 AM GMT/UTC).

During this outage, users will not be able to access this application to create or update SRs but can continue to search our Oracle Knowledge Base by going to https://support-lite.oracle.com or access our My Oracle Support Communities by going to community.oracle.com.

Please call your local Oracle Support center for any urgent issues during the outage window. You can find global Support phone numbers at our Oracle Support Contacts Global Directory.