Todos los Sábados a las 8:00PM

Soy parte de ULACIT

Ahora a suscribirse y seguir el contenido de este blog.

sábado, 21 de julio de 2018

Tip# 3 Obtener el DDL de un tabla

TIP#3: Obtener el DDL de una tabla

SQL> ddl bitacora_ingreso

   (    "COD_USUARIO" VARCHAR2(30),
        "FECHA" DATE,
        "OPERATIVO" VARCHAR2(30),
        "MAQUINA" VARCHAR2(100)

miércoles, 18 de julio de 2018

Hungary’s MKB Bank Goes Fully Digital with Oracle

Press Release 
 First all digital bank in Hungary can now implement new and improved services faster 

Redwood Shores, Calif.—Jul 17, 2018 

MKB Bank, Hungary’s fourth largest commercial bank has today announced it is the first in the country to take a leap towards digital and open banking after transforming its entire technology system. Its transformation has included a full replacement of its core banking system, the retirement and consolidation of roughly 10 additional systems, and the modernization of its entire IT architecture. 

MKB implemented Oracle FLEXCUBE, a core banking solution that has been adopted by more than 600 financial institutions around the world, as part of a broader restructuring project to streamline its internal and customer-facing operations and provide customers with more personalized services across multiple channels. MKB’s aim is to reduce its go-to-market time for new services such as corporate and retail lending, as well as digital only services, and to manage customer requests more quickly and easily. 

“It is not every day that a historically conservative medium-sized player commits its resources to modernizing its systems, changing its culture and taking a leap towards digitalization” said Ádám Balog, Chief Executive Officer, MKB. “It is through the reliability of partners like Oracle and the management of our stakeholders that we were able to make this move in such short a time.” 

“Banks still have some catching up to do when it comes to serving customers. It’s time to stop resisting change and develop a model based on the way people want to interact with banking services,” said Mark Hetényi, Chief Digital, Retail and Strategy officer, MKB. “This starts with a robust digital offering. We replaced our core banking platform with Oracle FLEXCUBE because it supports fully digital customer experiences.” 

MKB was intent on fast-tracking its technology program. Despite having comparatively fewer resources than major global banks operating in Hungary, MKB achieved its digital transformation in just two and a half years. The average deployment for projects of this scope typically takes between four and five years. 

“MKB recognized that digital services are a key differentiator. As a bank with its eyes firmly planted on the future of customer service, MKB’s bullish implementation of our flexible Oracle FLEXCUBE technology has put it in a position to pull ahead in a competitive Hungarian market,” said Sonny Singh, senior vice president and general manager, Oracle Financial Services. 

Contact Info 

Judi Palmer
Oracle Corporation
+ 1 650 784 7901

Michael Ruppert
+ 44(0) 207 067 0641
About MKB Bank 

MKB Bank is a leading digital bank in Hungary, which has put open banking as one of the pillars of its strategy and believes in partnering with its customers, corporate and private banking clients, as well as the Fintech world through innovations such as its new core system and IT architecture, an innovative MKB Fintechlab ecosystem it has built, as well as its network. The bank is considering an IPO in 2019. 

For more information about MKB Bank, visit
About Oracle 

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.



Product Area
Bug ID
Last Updated
Oracle Database - Enterprise Edition
Wed, 18 Jul 2018 06:37 GMT-06:00

Knowledge Articles

Knowledge Article
Product Area
Last Updated
Oracle Database - Enterprise Edition
Tue, 17 Jul 2018 17:59 GMT-06:00

martes, 17 de julio de 2018

CJAVA PERU: Taller Gratuito Arquitectura de Microservicios

CJAVA Perú te invita al "Taller Gratuito de ARQUITECTURA DE MICROSERVICIOS" 📍Inscríbete: 🗓 VIERNES 20 DE JULIO ⏰ De 6:45 PM - 9:45 PM Avenida Arenales 395, Oficina 405, Lima. 📗 Temario del curso: Comunícate con nosotros ☎️ (01) 433-6948 📲 Whatssap: 932-656-459 ✉ / Cjava siempre para apoyarte ;)

lunes, 16 de julio de 2018

Oracle SQLCL 18.2: Tip #1

La utilidad TNSPING en la herramienta SQLCL 18.2, determina si se puede llegar con Éxito  al listener de un servicio en una red de Oracle.

Si se puede establecer correctamente la conexión entre un cliente y un servidor (o entre servidores) con la utilidad TNSPING, aparecerá el tiempo completo (en milisegundos) que se prevé que llevará acceder al servicio de la red de Oracle.

Si no se puede, aparecerá un mensaje donde se podrá ver el motivo del error. De esta forma, podrá ver el error de red que se ha producido sin necesidad de estar conectado a una base de datos.

Utilice el comando siguiente para comprobar la conectividad:


Donde la dirección es una entrada de TNS o una cadena de conexión JDBC.

Por ejemplo:

 TNSPING localhost:1521/orcl

SQL> tnsping

SQL> tnsping
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor



Global Businesses Turn to Oracle Blockchain Service to Speed Transactions Securely

Press Release 

Arab Jordan Investment Bank, CargoSmart, and Intelipost are among early adopters of enterprise-class general ledger service 

Redwood Shores, Calif.—Jul 16, 2018 

Businesses around the world have been deploying an early adopter version of Oracle Blockchain Cloud Service, which becomes generally available today. The service allows organizations to easily build blockchain networks to drive more secure and efficient transactions and to track goods through supply chains on a global scale. Arab Jordan Investment Bank, CargoSmart, Certified Origins, Indian Oil, Intelipost, MTO, Neurosoft, Nigeria Customs, Sofbang, Solar Site Design and TradeFin are among the many global organizations that already have adopted Oracle’s blockchain platform. 

Blockchain has the power to fundamentally transform how every industry does business by making interactions more secure, transparent, efficient and cost-effective. Oracle Blockchain Cloud Service provides customers with a development platform to build their own networks, and to quickly integrate with Oracle SaaS and third-party applications they already use, as well as other blockchain networks and Oracle PaaS services. It also enables users to provision blockchain networks, join other organizations, and deploy and run smart contracts to update and query the ledger. Oracle’s blockchain platform leverages the company’s decades of experience across industries and its extensive partner ecosystem to reliably share and conduct trusted transactions with suppliers, banks, and other trade partners through blockchain. 

“Blockchain promises to be one of the most transformative technologies of our generation,” said Amit Zavery, executive vice president, Oracle Cloud Platform. “We are excited to announce the availability of Oracle Blockchain Cloud Service. It is the result of years of R&D alongside our valued partners and customers. With Oracle’s platform, enterprises can enhance their business, eliminate unnecessary processes, and transact with their distributed networks more easily, transparently and securely than ever before.” 

Oracle’s blockchain platform is built on top of The Linux Foundation’s Hyperledger Fabric. It is pre-assembled with all the underlying infrastructure dependencies, container lifecycle management, event services, identity management, REST proxy, and a number of operations and monitoring tools integrated under a single console, expediting the set-up and application development process. Oracle Blockchain Cloud Service is an Oracle-managed cloud platform backed by a 99.95 percent availability SLA, with built-in high availability configuration, autonomous recovery agents, as well as continuous ledger backup capabilities that can enable multi-datacenter disaster recovery across availability domains. 

It further benefits from broad capabilities in Oracle Cloud Platform for plug-and-play integration with existing cloud and on-premises applications, API management, and application development environments and tools. Additionally, Oracle is delivering new SaaS applications to use blockchain technology for common use cases, such as track and trace, provenance identification, warranty and usage, and cold chain. The plug-and-play ability with Oracle and third-party applications results in faster integration with diverse systems of record; greatly accelerating time to market and multiplying the returns from using the blockchain platform across different application use cases. 

“Blockchain projects are quickly moving from pilot to production as enterprises and governments begin to see the inherent value of distributed ledgers and smart contracts,” said Robert Parker, group vice president of manufacturing and retail insights, IDC. “As spending accelerates, buyers will need an enterprise class platform beyond open source that includes data security and integrity, scalability, manageability, and interoperability.” 
Quotes from Global Organizations and Consortia Using Oracle Blockchain Cloud Service 

Blockchain has the power to impact almost all industries and has applicability to verticals from transportation, supply chain and logistics, energy, retail and ecommerce, to financial services, telecommunications and public sector. Organizations and industry consortia are already using Oracle Blockchain Cloud Service to help ease transactions, track goods through supply chains, and reduce costs, including global shipping leaders, multi-national manufacturers, food producers and energy marketplaces. For example, Oracle joined the Food Safety Consortium and is a member of The Alliance for Telecommunications Industry Solutions, participating in its working group on blockchain. 

“Oracle’s blockchain platform has helped us minimize the complexity of electronic fund transfers by reducing cost, increasing efficiency and security levels, and ultimately improving the overall customer experience,” said Ayman Qadoumi, A. Deputy General Manager, Information Technology and Security, Arab Jordan Investment Bank. “The built-in features such as identity management and data encryption made it an ideal choice given our industry requirements and compliance needs. Additionally, the REST APIs helped us and our vendors accelerate application development and integration with existing core services.” 

“We are using Oracle Blockchain Cloud Service to develop an application to help simplify the complex documentation processes that plague the shipping industry,” said Steve Siu, CEO, CargoSmart. “Its comprehensive nature has allowed us to quickly turn prototypes into viable products in several 12-week sprints and so far, we have seen proven productivity gains of more than 30 percent compared to other blockchain platforms we tested. Another key purchasing requirement were its integrated management and operations tools, which allow business partners to monitor all of their blockchain activities and the health of the network.” 

“As the producer of Extra Virgin Olive Oil from fruits grown in small family farms in Italy, we wanted to trace our product that we sell in the US market branded Bellucci Evoo across the entire supply chain – ‘from the tree to the shelf,’” said Andrea Biagianti, CIO of Certified Origins. “The availability of Oracle’s blockchain service simplifies the implementation and collaboration of all parties included, and represents a real competitive advantage for us. It adds a further level of transparency and information that is valuable for consumers looking for quality products and helps us to support the excellence of the small farms.” 

Dr. Terence Lau, Convener of the Food Safety Consortium (FSC), welcomed Oracle as a Corporate Member of the non-profit technology development platform established by The Hong Kong Polytechnic University. “FSC is committed in advancing global food safety with science and technology,” said Dr. Lau. “With an increasing demand on multidisciplinary expertise in tackling challenges in food safety and quality, FSC is delighted to partner with Oracle to leverage blockchain, big data, and other IT applications to provide better food provenance, tracking and safety. We look forward to exploring Oracle Blockchain Cloud Service to improve and accelerate the Food Safety initiative in Hong Kong, as well as globally.” 

“Companies are increasingly testing and seeing the value blockchain technologies can offer their organizations, from streamlining internal processes to building trusted networks with partners, customers and third parties,” said Brian Behlendorf, Executive Director, Hyperledger. “Based on Hyperledger Fabric, Oracle’s platform, with its support for interoperability with non-Oracle Hyperledger Fabric instances, will help build further support for open standards and interoperability, while illustrating how quickly, easily and securely businesses can begin utilizing blockchain to improve business processes.” 

“Oracle’s blockchain platform is agile, easy to develop on and its enterprise-grade scalability makes it an ideal choice for deploying blockchain platforms rapidly,” said Juan José Miranda, blockchain project manager, Magia.Digital. “Based on our experience with the platform, we even chose it as our main development platform for the New York Consensus’ Hackathon 2018. With its features, we were able to impress the judges and ultimately be named winner of the contest.” 

“Once we decided that blockchain would be the ideal technology to help bring our ‘From Mileage to Opportunity’ – M2O – loyalty program to life, we went through a rigorous approach to find the right vendor,” said Suwan Kim, CEO, MTO. “We were confident that Oracle’s pre-assembled blockchain cloud service could quickly help us realize a trusted platform that empowers users to convert credit card points and air miles to tokens. It also provides us with easy, ongoing management and all the underlying security, scalability, and resilience that are needed for a production solution like this.” 

“We used Oracle’s blockchain to build a trusted platform for the automation of Customs Excise Trade business processes and procedures,” said Aber T Benjamin, Assistant Comptroller General Modernization, Nigeria Customs Service. “Using this technology, we found the entire business environment can be migrated to blockchain to automate processes and create transparency and predictability. Once the transition to blockchain is completed, NCS expects revenue growth increase of about 50 percent. This technology helps our organization to build global trust for Nigerian businesses through irrefutable data on goods manufactured in the country.” 

“Using Oracle’s blockchain platform in factoring and supply chain finance seems a natural fit that enables us to go from a fragmented process along heterogeneous systems to a common base, that can be trusted by all, used as a reference, resolve conflicts and streamline processes,” said Nikolaos Vasilonikolidakis, CEO, Neurosoft. “Risk mitigation in factoring is paramount and Oracle’s blockchain brings common consensus that helps settle transactions in near real-time.” 

“Oracle’s blockchain platform is enabling Sofbang to build smart contract supply chain solutions for our customers,” said Michael Ribet, product development manager, Sofbang. “We’re delighted with the rich functionality, robust scalability of the service and how it’s designed to integrate blockchain technology with current business critical applications seamlessly. Our customers are anticipating up to 35 percent efficiency gains by communicating more reliably and rapidly with their trading partners through Oracle Blockchain Cloud Service.” 

“We helped found the Energy Blockchain Network earlier this year after realizing stakeholders in the solar project ecosystem needed a single source of truth with immutable records, so they can trust project status data,” said Jason Loyet, CEO of Solar Site Design. “We can now program each project’s status, list requirements to move forward, and rewards value contributions in near real-time. We are really happy with how easily NetSuite SuiteCloud Development Platform and Oracle‘s blockchain platform integrate with pre-packaged blockchain APIs, allowing us to explore new ways to develop smart contracts, manage the projects and reward programs.” 

“As a company dedicated to making business-to-business payments and supply chain finance secure, frictionless and ubiquitous using blockchain, we are able to significantly accelerate the time to onboard corporations, their suppliers and banks by using Oracle’s blockchain platform,” said Amit Baid, CEO, TradeFin. “It provides a REST API-driven platform with rich integration options in Oracle Cloud Platform, allowing us to quickly onboard existing customers. Additionally, Oracle Scaleup Ecosystem provides access to the platform itself, cloud credits, mentoring, and a number of Oracle resources that can help start-ups like ours grow quickly.” 

Join the Oracle Blockchain Cloud Service webcast on July 16 at 9AM PT 
Learn more in a city near you at an Oracle Blockchain Roundtable
Follow Oracle Platform via Blog, Facebook and Twitter

Contact Info 

Nicole Maloney

Oracle Named a Category Leader for Data Integrity and Control by Chartis Research

Press Release 
Recognizes Oracle Financial Services’ Completeness of Offering and Market Potential 

Redwood Shores, Calif.—Jul 16, 2018 

Today Oracle Financial Services announced it has been named by Chartis Research as a Category Leader for Data Integrity and Control (DI&C) on Chartis’ FinTech Quadrant for DI&C solutions in Financial Services. 

For its report Data Integrity and Control in Financial Services 2018, Chartis considered two key dimensions when evaluating vendors: completeness of offering and market potential. Oracle’s positioning in the quadrant highlights its depth and breadth of functionality, technology and content. 

“We are proud to be recognized by Chartis as a category leader for our data integrity and control capabilities,” said Ambreesh Khanna, Group Vice President, Financial Services Analytical Applications, Oracle Financial Services. “As the volume of data and number of industry regulatory requirements keeps growing, financial institutions are in need of robust data governance, quality and controls more than ever before. Our placement on the quadrant re-affirms our status as a best-in-class provider with an unrivaled array of services and capabilities, and we are committed to continuously strengthening our toolset.” 

By positioning Oracle as a category leader, Chartis recognizes the range and diversity of its offerings, its sector coverage, and the financial strength it has to absorb demand volatility in specific industry sectors or geographic regions. Chartis also rated Oracle for its strong alliance strategies with leading consulting firms and systems integrators. 

“Oracle combines deep domain knowledge in various risk topics with strong technology assets and capabilities,” said Rob Stubbs, Head of Research at Chartis. “The company is positioned to address a range of needs, from complex risk management and technology to standardized and integrated solutions.” 

The 2018 market report by Chartis examines how the dynamics in this space have shifted since its last update in 2016, and the implications for Financial Institutions and technology vendors. The FinTech Quadrant is a proprietary methodology developed specifically for the financial technology marketplace. It takes into account vendors’ product, technology and organizational capabilities. 

Chartis’ FinTech Quadrant reports are written by experienced analysts with hands-on experience of selecting, developing and implementing financial technology solutions for a variety of international companies in a range of industries including banking, insurance and capital markets. The findings and analyses in the FinTech Quadrant reports reflect their analysts’ considered opinions, along with research into market trends, participants, expenditure patterns, and best practices. 

More information and a copy of the full report can be found on Chartis’ website here

Contact Info 

Judi Palmer

viernes, 13 de julio de 2018



Product Area
Bug ID
Last Updated
Oracle Database - Enterprise Edition
Thu, 12 Jul 2018 06:34 GMT-06:00

Knowledge Articles

Knowledge Article
Product Area
Last Updated
Oracle Database - Enterprise Edition
Wed, 11 Jul 2018 23:19 GMT-06:00

Media Agencies Conquer Industry Transparency Issues with NetSuite

Press Release 

Forthea Interactive and MediaMax Focus on Creativity and Clients by Eliminating Business Process Complexity 

San Mateo, Calif.—Jul 11, 2018 

To focus time on rapidly changing client needs, boutique media agencies are selecting Oracle NetSuite to scale their business, without sacrificing creativity. For example, Forthea Interactive and MediaMax implemented Oracle NetSuite to gain a source of efficiency across their growing businesses and provide the support, transparency and creativity that clients demand. 
Forthea Interactive Balances Data and Creativity With the Help of the Cloud 

Founded in 2006, Forthea Interactive specializes in SEO, pay per click, web analytics, website design and social media marketing. The company prides itself on building successful campaigns for its clients by balancing the creative with the analytical. To help achieve this balance and drive results for clients, Forthea Interactive leverages NetSuite for financial management, customer relationship management (CRM) and project management. With NetSuite, Forthea Interactive has a modern, unified system to integrate its services and finance operations. As a result, collaboration and creativity are able to thrive. 

“Marketing is very messy. There is so much data being collected that it’s hard to keep track and it can feel like drinking from a fire hose,” Chris Pappas, founder and CEO, Forthea Interactive. “In order to be more accountable to our clients, we had to be more organized and that’s where NetSuite comes in. NetSuite has provided us with a 360-degree view of our business. This allows us to easily track everything we need to do in order to run efficiently and successfully, and that ultimately helps enhance our client relationships.” 
MediaMax Uses NetSuite From the Start to Help Manage Advertising Solutions and Processes 

MediaMax provides geo-targeted print, data and digital advertising solutions for national brands, regional marketers, and SMBs across the US and Canada. To help support its continued growth and successfully manage data for its more than 1,000 customers, MediaMax utilizes NetSuite OneWorld for financial management, client management, and post-sale operations. NetSuite continues to be a critical platform and has played an integral part of the company’s infrastructure since the company’s inception in 2003. 

“As the media world continues to transform at an unprecedented rate, we have to ensure we keep up,” said Charles Wirth, COO and CFO, MediaMax. “With NetSuite, we worry less about any of our key business processes, even as we continue to grow. What this allows us to do is spend time creating new products, focusing on creative solutions, and most importantly driving results and value for our clients.” 

“We know the pressure media agencies are under. They need to deliver the transparency clients are now requiring while maintaining their creative culture,” said Chris Hering, Director of Advertising & Media Product Marketing, Oracle NetSuite. “NetSuite helps boutique media agencies like Forthea Interactive and MediaMax by streamlining agency workflows, allowing them to gain real-time insight into client and project-based accounting and deliver the best possible client experience.” 

Oracle NetSuite will be attending AdAge’s Small Agency Conference on July 17-18, 2018 and hosting a networking breakfast. Please register here ASAP, space is limited. 

NetSuite’s Cloud blog
Follow NetSuite on Twitter @NetSuite, Facebook, and LinkedIn

Contact Info 

Danielle Tarp
Oracle NetSuite Corporate Communications

Oracle Hot Topics: ORA-600 [16607] WHILE RUNNING UTLRP


Product Area
Bug ID
Last Updated
Oracle Database - Enterprise Edition
Fri, 13 Jul 2018 06:29 GMT-06:00

Knowledge Articles

Knowledge Article
Product Area
Last Updated
Oracle Fusion Middleware Oracle Database - Enterprise Edition
Fri, 13 Jul 2018 02:25 GMT-06:00