Feed aggregator

Introduction to Liquibase and Managing Your Database Source Code

Shay Shmeltzer - Mon, 2017-10-16 10:35

In previous posts I showed how you can manage SQL scripts lifecycle with the help of Oracle Developer Cloud Service (DevCS) as part of an overall Oracle DB DevOps solution. I wanted to add one more utility that might act as an alternative or addition to the SQL script managing - Liquibase.

Liquibase logo

Liquibase is an open source solution for managing revisions of your databse schema scripts. It works across various types of databases, and supports various file formats for defining the DB structure. The feature that is probably most attractive in Liquibase is its ability to roll changes back and forward from a specific point - saving you from the need to know what was the last change/script you ran on a specific DB instance.

Liquibase uses scripts - referred to as "changesets" - to manage the changes you do to your DB. The changesets files can be in various formats including XML, JSON, YAML, and SQL. In the examples below I'm using the XML format.

As you continue to change an enhance your DB structure through the development lifecycle you'll add more changesets. A master file lists all the changeset files (or the directories where they are). In parallel Liquibase tracks in your database which changesets have already run. 

When you issue a liquibase update command, liquibase looks at the current state of your DB, and identifies which changes have already happened. Then it run the rest of the changes - getting you to the latest revision of the structure you are defining.

By integrating Liquibase into your overall code version management system and continuous integration platform you can synch up your database versions with your app version. In my case this would of course mean integration with Oracle Developer Cloud Service (DevCS) - which you get for free with the Oracle Database Cloud Service. In the video below I show a flow that covers:

  • Tracking my DBA tasks in the issue system
  • Modifying a local MySQL DB with Liquibase (doing forward and backward rolls)
  • Adding a change set defining a new table
  • Committing to Git
  • Automatic build implementing the changes in Oracle Database Cloud Service
  • Automatic testing with UT/PLSQL

Here is a quick 10 minute demo:

For those who want to try and replicate this, here are some resources:

A changeset that creates a "department" table with three columns:

A changeset that creates PL/SQL function, package and procedure. Note that in line 3 the dbms="oracle" means this script will only run when we are connected to an Oracle DB:

create or replace function betwnstr( a_string varchar2, a_start_pos integer, a_end_pos integer ) return varchar2 is begin return substr( a_string, a_start_pos, a_end_pos - a_start_pos+1 ); end; create or replace package test_betwnstr as -- %suite(Between string function) -- %test(Returns substring from start position to end position) procedure basic_usage; end; create or replace package body test_betwnstr as procedure basic_usage is begin ut.expect( betwnstr( '1234567', 2, 5 ) ).to_equal('2345'); end; end; A changeset that adds a record to a table. Line 8 has the rollback tag that defines how to do a rollback for this insert: delete from department where id=20

 

A few tips about my DevCS project and build setup.

1. For the sake of simplicity, I loaded the liquibase and JDBC jar files into my git repository - this makes it easy for my build steps to find the files and execute them. I'm guessing you could also use Maven to host those.

2. I use a password parameter for my build so I don't need to hardcode the password adding a bit of security to my build. Reference teh parameter in your build with a $ sign - $password

3. Want to learn more about test automation with ut/PLSQL - check out this blog entry.

 

 

Categories: Development

Oracle Defines Path to Open API Banking with an Unparalleled Array of Solutions

Oracle Press Releases - Mon, 2017-10-16 08:00
Press Release
Oracle Defines Path to Open API Banking with an Unparalleled Array of Solutions With regulation and competition challenging banks in unprecedented ways, Oracle offers one of the most comprehensive open API banking solutions

Redwood Shores Calif—Oct 16, 2017

In today’s economy, banks seek to adapt a more customer-centric business model by delivering new services with greater transparency. Traditional banks understand that they must equip themselves with digital capabilities to avoid being disintermediated by new players in the industry. Oracle’s open API banking solution set can help banks make the difference they need. Packaged and ready for integration with any financial institution’s tech ecosystem, Oracle’s  end-to-end solution is well suited for open API initiatives that require design, documentation, simulation, management, identity/security management and monetization backed by business analytics.
 
With both, the rise of fintechs and increased scrutiny from regulatory agencies dominating industry conversation, banks must look to embrace change rather than simply comply with it. This means going beyond acting as traditional banks and begin operating as ‘platforms’ that enable direct integration from third party applications. Open API protocols have even gained global prominence through region-specific initiatives that focus on end-customer benefits. PSD2 regulation in the European Union and initiatives by the Singapore Monetary Authority, U.K. Financial Conduct Authority and Australia Economic Committee are ongoing efforts to make open banking and open APIs standard.
 
This environment ushers an age of transparency that demands an open API architecture, which typically requires components from several vendors if it is to be executed successfully. Oracle today, eliminates the need of engaging with multiple vendors, and offers customers an end-to-end open API solution under one roof. It also provides the added benefit of an unparalleled hyper-connected experience.
 
“Times have changed and today, more than ever, a two-fold approach is necessary when implementing customer facing technology,” said Oracle Senior Vice President Chet Kamat. “Quite simply, the two aspects are acquiring plug-and-play lifecycle experience products—like mobile applications and omni-channel user experience solutions—and adopting open API banking. Oracle offers a solution versatile enough to cater to both these needs.”
 
Oracle’s open API banking solution enables financial institutions to roll out their API initiatives quickly. Banks can gain new revenue streams, rethink their operating and business models, all without disrupting their pre-existing tech architecture. This is made possible by the sheer breadth of offerings within Oracle’s toolset.
 
Oracle’s open API banking solution set includes:
  • Oracle Banking Digital Experience: This full spectrum multi-channel solution provides over 1000 fine grained APIs which can be leveraged for Open Banking.
  • Oracle Revenue Management and Billing: Allows the bank to price each API call based on rate plans blended with enterprise class relationship pricing. This provides a unique API monetization model for financial institutions.
  • Oracle Identity Cloud Service Management: A next-gen security and identity platform that helps banks define and manage their API security policy.
  • Apiary: This cloud banking platform can be leveraged to design, prototype, document and test APIs.
  • Oracle API Platform Cloud Service: Manages the entire API lifecycle beginning with design and standardization to documenting, publishing, and parameterization and testing of prototypes.
  • Oracle Banking Payments: With payments underlining most API regulations, banks need a robust payments engine to deliver rich payment experiences. Built grounds up on ISO20022 Oracle’s payments solution gives banks the ability to cater to rich API workloads.
Contact Information
Alex Moriconi
Oracle Corporation
 +1-650-607-6598
 
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.com.
 
Trademarks
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
 
Safe Harbor
The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle Corporation.

Oracle Financial Services Transaction Filtering Now Available

Oracle Press Releases - Mon, 2017-10-16 08:00
Press Release
Oracle Financial Services Transaction Filtering Now Available Offering includes screening options for SWIFT, SEPA, ISO 20022 and more

Redwood Shores Calif—Oct 16, 2017

Announced today, Oracle Financial Services Transaction Filtering product is now widely available. The solution, which integrates tightly with Oracle Financial Crime and Compliance Management (FCCM), holds the sanctioned transactions in real-time with accuracy and efficiency. The offering enables compliance with current legal and regulatory requirements with the ability to filter against key watch lists—such as the U.S. treasury, European Union and United Nations—via pre-integrated Oracle architecture. Powering the FCCM suite is Oracle Financial Services Analytical Applications (OFSAA), a leading provider of financial crime, risk and compliance solutions.
 
Today’s financial climate demands evolved sanctions screening technology that not only narrows down false positives, but learns from previous instances. False positives can clog up banking systems and result in transactions remaining on hold until a full investigation has been conducted. When coupled with mounting regulatory obligations that levy sanction-based fines and penalties, instantaneous vetting is no longer a nice-to-have, but a necessity. While proper transaction filtering continues to be top-of-mind for financial institutions, many systems are marred by ineffectiveness and productivity hurdles.
 
“The release of our Transaction Filtering product re-affirms Oracle’s understanding that compliance and risk are of paramount importance to c-suites at financial institutions,” said Oracle Financial Crime and Compliance Management Vice President Sunil Mathew. “To operate smoothly, financial institutions need an integrated Financial Crime & Compliance solution; and there’s currently not an offering like ours that provides a complete package for fraud, crime and compliance.”
 
The demand for an integrated FCCM solution that combines everything from customer screening to AML and sanctions has grown. Oracle’s sophisticated matching algorithms and data management capabilities reduce the possibility of false positives while maintaining real-time detection standards and automatically generating an audit trail that denotes alterations (a regulatory requirement).
 
There are hundreds of transaction filtering compliance lists globally that change frequently, leaving companies struggling to find new innovative solutions to keep up with the changing regulatory landscape. Oracle’s solution monitors these regulations in all relevant jurisdictions and possesses the technological excellence to meet this challenge in an automated way with the launch of their Transaction Filtering product.
 
To learn more about Oracle Transaction Filtering please view our datasheet.
Contact Information
Alex Moriconi
Oracle Corporation
 +1-650-607-6598
 
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.com.
 
Trademarks
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
 
Safe Harbor
The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle Corporation.

NetSuite Accelerates Business Expansion in EMEA

Oracle Press Releases - Mon, 2017-10-16 05:15
Press Release
NetSuite Accelerates Business Expansion in EMEA Leveraging Oracle Resources, NetSuite Adds More Capabilities to Help Ensure Customer Success

NEXT READY BUSINESS TOUR 2017, London—Oct 16, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today launched SuiteSuccess editions for Ireland and UK headquartered companies and announced more EMEA-specific product enhancements, more new offices in the region and more customer and partner wins. With the resources of Oracle, NetSuite is able to accelerate growth and product innovation, and strengthen its commitment to customer and partner success in the region.

“EMEA has long been a strategic region for NetSuite and a key factor in our growth,” said Mark Woodhams, VP EMEA for Oracle NetSuite. “With the backing of Oracle’s resources, we are doubling down on our commitment to the region to help ensure more customer and partner success.”

MORE LOCALISED FUNCTIONALITY

The new NetSuite OneWorld features unveiled today deliver more global financial capabilities to allow businesses in EMEA to gain greater financial control over intercompany accounting across multiple jurisdiction countries, improve auditing process, reduce financial close time, and provide businesses with an exceptional experience when conducting bank reconciliation. In addition, building on the momentum of localised product releases for the Nordics, Benelux, Southern Europe and Middle East headquartered companies, NetSuite not only released more localised functionality for existing customers across these regions, but launched NetSuite OneWorld localized features to help meet business requirements, tax and regulatory compliance in Spain and Portugal, allowing businesses in those countries to run their mission critical business processes in the cloud.

Read the full press release.

MORE SUITESUCCESS

NetSuite today announced the availability of SuiteSuccess, one of the first unified industry cloud solutions, for companies based in the UK and Ireland. SuiteSuccess gives customers access to leading industry practices, pre-built KPIs and dashboards, and a path to the cloud in as little as 100 days. The SuiteSuccess Financials First Edition and SuiteSuccess for Wholesale Distribution Industry Solution are the first SuiteSuccess solutions to be offered in the region.

Read the full press release.

MORE SUITECLOUD DEVELOPMENT NETWORK PARTNERS

NetSuite today announced significant expansion of its SuiteCloud Developer Network (SDN) programme, on a global basis. Under the initiative, NetSuite is increasing the growth of SDN partnerships with independent software vendors (ISVs) that build specialised and complementary solutions, to extend the NetSuite platform across more countries in EMEA, APJ and Latin America. NetSuite customers can benefit from the globalisation of SDN by gaining access to completely localised solutions that help meet local requirements. The SDN globalisation aligns with NetSuite’s own rapid acceleration of international growth.

By adding and expanding SDN partnerships around the world, NetSuite is driving partner development of add-on solutions, called SuiteApps, that enrich NetSuite with process- and industry-specific functionality localised to the unique requirements of individual countries. SDN partner SuiteApps with “last-mile localisation” give customers country-specific functionality for accounting standards, tax calculations, regulatory and reporting requirements, compliance, billing and prevailing business standards. The expansion also promotes development of SuiteApps that address unique needs in industry verticals and microverticals on a country and regional level.

MORE PARTNER SUCCESS

NetSuite continues to strengthen its channel in EMEA, adding new partners in the UK, Sweden, Finland, Belgium, South Africa, Middle East and more, to meet the growing demand for cloud ERP in the region. NetSuite announced today that SystemsAccountants, a leading specialist recruitment and resourcing solutions company, has joined the NetSuite Alliance Partner Program after having first-hand experience growing its own business as a customer.

Read the full press release on SystemsAccountants.

MORE CUSTOMER SUCCESS

EMEA-Based Customers Get Ready for Next with NetSuite
Many fast growing, innovative companies adopt NetSuite to ready themselves for next. Along with SystemsAccountants, other customers announced today include London-based home fashion label, Buster + Punch, and OSL Cutting Technologies, a manufacturer and importer of magnetic drilling machines and cutting tools.

Read the full press release on Buster+Punch.

Read the full press release on OSL Cutting Technologies.

MORE OFFICES, MORE COUNTRIES, MORE EMPLOYEES, MORE INFRASTRUCTURE

Delivering on its pledge to expand globally, NetSuite announced today that it has quadrupled the sales force in EMEA since January of this year. That investment includes direct sales forces in the Netherlands, Sweden and Germany, as well as direct sales forces in Dubai and Qatar to serve the Middle East and South Africa. NetSuite is also adding marketing and services personnel in the region and development staff to continue to localise NetSuite to address country- and region-specific requirements.

With the rapid expansion across Europe, NetSuite plans to build a data centre in Germany in the coming year to remedy the lack of modern cloud computing offerings in the country. NetSuite currently operates six data centres, four in North America, most recently opening a data centre in Chicago. In addition, NetSuite currently operates two data centres in EMEA, one in Amsterdam, Netherlands and one in Dublin, Ireland.

Contact Info
Sarah Heinz
Public Relations
+44 (0) 208 118 6013
OracleNetSuite@cmgrp.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.co.uk.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuiteEMEA Twitter handle for real-time updates.

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 www.oracle.com.

Trademarks

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

Talk to a Press Contact

Sarah Heinz

  • +44 (0) 208 118 6013

SystemsAccountants Supports Expansion into New Markets with NetSuite

Oracle Press Releases - Mon, 2017-10-16 05:00
Press Release
SystemsAccountants Supports Expansion into New Markets with NetSuite Recruitment and consulting leader also becomes NetSuite Alliance Partner

NEXT READY BUSINESS TOUR 2017, London—Oct 16, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce, today announced that SystemsAccountants, a leading specialist recruitment and resourcing solutions company, has chosen NetSuite OneWorld to underpin its global expansion. With new offices opening in Paris and New York, SystemsAccountants has moved to NetSuite’s cloud business platform to help it scale into new markets with ease.

SystemsAccountants’ previous systems were almost a decade old and based on manual input, making them unfit for its increasingly complex global business. By replacing its mid-office systems with NetSuite OneWorld, the company has gained a single platform which sits across its entire global business and allows it to quickly and easily manage the specific needs in each market. For instance, SystemsAccountants now has better capability to adapt to fast-changing US regulations in Chicago and New York, while also respecting local regulations in the Netherlands, France and the UK all on the same platform.

“After 20 years of serving everyone from FTSE 100 and Fortune500 companies to SMEs and NGOs, we are ready to take on new challenges in new markets” said Nicola Sutcliffe, Group Finance Director, SystemsAccountants. “With NetSuite OneWorld, we have gained a platform that can grow with us as we continue to expand and take on new customers.”

SystemsAccountants Becomes NetSuite Alliance Partner

SystemsAccountants increasingly serves businesses that are undergoing digital transformation and want to better integrate their IT and Finance departments as part of their transition. As a NetSuite Alliance Partner, SystemsAccountants can now deliver on this need with the same platform it is using to grow its business – NetSuite OneWorld.

Within two months of becoming a NetSuite Alliance Partner, SystemsAccountants had already secured its first customer, Cubico Sustainable Investments, a world leader in renewable energy infrastructure.

“SystemsAccountants is one of the leading companies going digital to transform its business and capitalise on new market opportunities. Who better then to help its own clients achieve their digital transformation goals with NetSuite OneWorld than an organisation that has seen the benefits first hand,” said Mark Woodhams, Managing Director EMEA at NetSuite.

SystemsAccountants Featured at the Next Ready Business Tour London

SystemsAccountants is the sole sponsor of NetSuite’s ‘Next Ready’ Business Tour’s London event, which will focus on how leading organisations are using the cloud to transform the way they work. The event is taking place today, October 16th, 2017, at the Park Plaza Westminster Bridge in London. To learn more, visit www.netsuite.com/nrbtlondon

Follow the discussions from the event on Twitter by tracking #NextStartsNow.

Contact Info
Sarah Heinz
Public Relations
+44 (0) 208 118 6013
OracleNetSuite@cmgrp.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.co.uk.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuiteEMEA Twitter handle for real-time updates.

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 www.oracle.com.

Trademarks

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

Talk to a Press Contact

Sarah Heinz

  • +44 (0) 208 118 6013

From Garage to Global: Buster + Punch Chooses NetSuite Cloud

Oracle Press Releases - Mon, 2017-10-16 04:45
Press Release
From Garage to Global: Buster + Punch Chooses NetSuite Cloud SuiteSuccess Financials First and SuiteSuccess for Wholesale Distribution Industry Deliver Faster Time to Value and Increased Efficiency, Flexibility and Customer Success

NEXT READY BUSINESS TOUR 2017, London—Oct 16, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, announced today that London-based home fashion label, Buster + Punch, has chosen NetSuite OneWorld as the foundation to support its growth beyond Western Europe. With a B2C ecommerce website, showroom in London, retail store in Stockholm and over 71 stockists selling its select products across 27 countries, the company was ready for its next move to build a physical presence in the United States. With NetSuite OneWorld, Buster + Punch will be able to standardise, streamline and scale its operations across its multichannel business within one unified cloud solution to support this continued global growth.  

“Our business has gained massive popularity over the last couple of years. In order to keep up and continue to deliver the premium service and products our customers expect, we realised our back-end systems needed a revamp,” said Martin Preen, CEO, Buster + Punch. “NetSuite’s capabilities have the ability to make us smarter. With it, we will be able to manage our operations on a single platform, all while combining data from across our manufacturing plants in Asia, physical locations in Sweden and the UK, and from retail channels across the world, to get the insights we need to keep driving Buster + Punch forward with certainty.”

Architect and industrial designer, Massimo ‘Buster’ Minale, launched Buster + Punch in an East London garage in 2013. In a matter of two years, the company was selling its unique items to customers across 84 countries. Inspired by London’s distinctive fashion, music and sub-culture scenes, the company has quickly grown to create a wide range of products from lighting and home hardware to custom motorcycles, collaborating with street artists, bike builders, musicians and fashion designers. Those collaborations include a contemporary version of the Edison light bulb created with Rolls Royce, new packaging with renowned British design firm ILOVEDUST and a steel candle holder for chef Tom Seller’s FAT CANDLE dish, a beef fat candle created in homage to Seller’s father who saved the fat and juices from family lunches to eat later with bread.

Buster + Punch selected NetSuite OneWorld to provide it with a real-time view across its operations, from its manufacturing facilities and warehouses, to its supply chain and customer service. This will allow it to align its business across all markets and get products to customers faster and at a lower cost, all while maintaining the high product quality and service that have shaped its success to date.

With visibility across its entire global operation, Buster + Punch will have the ability to more precisely forecast product demand and consequently scale its manufacturing and delivery processes to prevent supply bottlenecks. Buster + Punch will also be able to use the data from the NetSuite OneWorld platform to successfully roll-out new product lines.

NetSuite OneWorld supports 190 currencies, more than 20 languages, automated tax calculation and reporting in more than 100 countries, and customer transactions in more than 200 countries. Further, to help today’s B2B and B2C businesses with omnichannel commerce, NetSuite OneWorld delivers commerce-ready capabilities that can help both B2B and B2C commerce businesses to move from siloed online, in-store and phone consumer shopping channels to an integrated commerce solution, connecting ecommerce and in-store POS to order management, inventory, merchandising, marketing, financials and customer service, while delivering a seamless brand experience and exceeding customer expectations.

Contact Info
Sarah Heinz
Public Relations
+44 (0) 208 118 6013
OracleNetSuite@cmgrp.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.co.uk.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuiteEMEA Twitter handle for real-time updates.

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 www.oracle.com.

Trademarks

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

Talk to a Press Contact

Sarah Heinz

  • +44 (0) 208 118 6013

OSL Cutting Technologies Modernises with NetSuite OneWorld

Oracle Press Releases - Mon, 2017-10-16 04:30
Press Release
OSL Cutting Technologies Modernises with NetSuite OneWorld International manufacturer streamlines operations across complex business

NEXT READY BUSINESS TOUR 2017, London—Oct 16, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced that OSL Cutting Technologies, a manufacturer and importer of magnetic drilling machines and cutting tools, has improved its on-time delivery, reporting and streamlined its financial operations with the implementation of NetSuite OneWorld in May 2017. OSL Cutting Technologies, a division of the OSL Group, is using NetSuite OneWorld to manage financials, multi-currency accounting and financial consolidation, Customer Relationship Management (CRM), email marketing and advanced manufacturing processes.

Amongst its market leading brands, OSL Cutting Technologies owns Rotabroach, G & J Hall and Taylor and Jones and has a more than 100-year history in the cutting technology industry. Based in Sheffield, England – the traditional heart of the steel industry in the UK, it manufactures drills, drill bits and related equipment and distributes to over 100 countries worldwide, to customers that range from small tools shops to large national distributors like Cromwell and Buck & Hickman. When the company acquired G & J Hall, a provider of specialist tools for the fabrication and engineering industries in 2015, it found itself struggling to manage its business in two separate systems. The multiple systems limited overall business visibility and impacted everything from managing sales teams to production to its two warehouses. Moreover, as the company expanded to launch a new subsidiary in the United States, it needed to account for the complexities of a new currency, taxation rules and additional financial consolidation.

The company considered consolidating on Efacs, the system used by G & J Hall, or Microsoft Navision, the system Rotabroach had implemented a few years earlier, but determined NetSuite would better suit its needs. Microsoft Navision didn’t have the manufacturing functionality the company needed, forcing it to do planning in Excel spreadsheets and the CRM functionality was limited. OSL Cutting Technologies determined NetSuite’s cloud-based architecture, unified platform and advanced manufacturing capabilities presented the best method to modernise its existing systems.

“NetSuite really took the time to understand our business and our needs,” said Graeme Swift, Operations Manager at OSL Cutting Technologies. “With the flexibility of NetSuite, I feel it can mold around any business model you can think of. We do more and more customisation every day. That’s what makes it so powerful.”

With on-site assistance from the NetSuite implementation team, OSL Cutting Technologies was able to combine the processes of the two companies into one on NetSuite OneWorld. As a result, the company has seen significant savings in the warehouse, where two separate teams had previously been working with paper-based pick and pack processes. Now, they receive automated orders in NetSuite via iPads. On-time delivery has improved from 85 percent to 95 percent, and the company has been able to reassign two members of the five-person team to other roles. Purchasing staff, who used to manage processes across as many as 10 different spreadsheets, now have real-time dashboards automatically displaying task lists, orders overdue and stock levels, while purchase orders can be created with the click of a button.

In finance, the two companies have now been consolidated into one. NetSuite OneWorld – with support for 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and customer transactions in more than 200 countries – will allow OSL Cutting Technologies to quickly and easily set up its US operations as a subsidiary and expand into other regions as opportunities arise.

The sales team has also seen the benefits of the implementation with synchronisation between NetSuite OneWorld and its Outlook accounts and visibility across the customer record with a unified system. In manufacturing, OSL Cutting Technologies has real-time visibility into backlogs and bottlenecks, enabling the company to continue to innovate and improve on the manufacturing process.

Contact Info
Sarah Heinz
Public Relations
+44 (0) 208 118 6013
OracleNetSuite@cmgrp.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.co.uk.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuiteEMEA Twitter handle for real-time updates.

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 www.oracle.com.

Trademarks

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

Talk to a Press Contact

Sarah Heinz

  • +44 (0) 208 118 6013

APEX Office Print 3.1 released - support for Docker

Dimitri Gielis - Mon, 2017-10-16 04:18
Last week we release APEX Office Print (AOP) 3.1, our best release ever :)

AOP was already the easiest and most fully integrated printing and exporting solution for Oracle APEX, but with every new release we allow you to customise the way you use AOP a bit more and add more advanced functionalities.

As more and more bigger companies are using AOP, we focussed in this release more on enterprise features, for example, native HTTPS support, end-to-end and customisable debugging, a new queuing system for large amounts of prints and overall performance enhancements and general improvements.
You can read more about this release in our release history.

One other addition I want to highlight is the ability to run AOP in a Docker configuration.
The Docker image is available for our Gold and Enterprise license.

Docker is the world’s leading software container platform. If this concept is new for you, you can read more at What is Docker?



In the previous days Martin Giffy D'Souza blogged about How to Setup Oracle DB 12.2 Docker Container and Docker Oracle and APEX and Roel Hartman talked about Dockerize your APEX development environment. Those are some excellent posts how to get started with Docker in an Oracle Database and APEX context.

The most important reason for us to make an APEX Office Print docker image available was to ease the installation of multiple AOP instances even more and give the possibility to scale AOP in an enterprise way.

Here's a video how you are up and running with our AOP docker image in less than a minute:



You also find the detailed steps in the AOP documentation.

Juergen Schuster and Martin Giffy D'Souza did a podcast with me end of August, where I talk a bit about AOP and our development too.

If you are not yet on APEX Office Print 3.1, go and download the latest version, even when you are not enterprise, it's worthwhile the upgrade. We updated our AOP Sample Application with some new examples too.


Happy printing and exporting from Oracle APEX with AOP :)

Categories: Development

NetSuite Announces SuiteSuccess for UK- and Ireland-based Companies

Oracle Press Releases - Mon, 2017-10-16 04:15
Press Release
NetSuite Announces SuiteSuccess for UK- and Ireland-based Companies SuiteSuccess Financials First and SuiteSuccess for Wholesale Distribution Industry Deliver Faster Time to Value and Increased Efficiency, Flexibility and Customer Success

NEXT READY BUSINESS TOUR 2017, London—Oct 16, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced the availability of SuiteSuccess, one of the first unified industry cloud solutions, for companies based in the UK and Ireland. SuiteSuccess delivers to customers leading industry practices, pre-built KPIs and dashboards, and a path to the cloud in as little as 100 days. The SuiteSuccess Financials First Edition and SuiteSuccess for Wholesale Distribution Industry Solution are the first SuiteSuccess solutions to be offered in the regions.

“SuiteSuccess has already proven to be incredibly popular with our customers and extremely valuable,” said Jim McGeever, Executive Vice President Oracle NetSuite. “We’ve entirely reimagined how to implement, support and optimise a cloud business solution. We’re pleased to now bring the first industry cloud solution to our customers in the UK and Ireland and introduce Financials First, our latest edition.”

SuiteSuccess is the culmination of a multi-year transformation effort to combine the NetSuite unified suite, 20 years of industry leading practices, a new customer engagement model, and business optimisation methods into a unified, industry cloud solution. SuiteSuccess was engineered to solve unique industry challenges that historically have limited a company’s ability to grow, scale and adapt to change. Most ERP vendors have tried to solve the industry solution problem with templates, rapid implementation methodologies, and custom code. NetSuite took a holistic approach to the problem and productised domain knowledge, leading practices, KPI’s, and an agile approach to product adoption. The benefits are faster time to value, increased business efficiency, flexibility, and greater customer success. To learn more about SuiteSuccess, please visit www.netsuite.com/suitesuccess.

The four key pillars of SuiteSuccess are:

  • BUILD. A complete suite to support the modern business including ERP, CRM, PSA, omnichannel commerce, HR, and Business Intelligence (BI) built on the NetSuite cloud platform, continually updated with leading edge capabilities and technologies to support all eight industries.
  • ENGAGE. Leading practices for each industry and role including workflows, KPI’s, reports, dashboards and metrics, with the flexibility to personalise on the NetSuite platform from the initial sales contact to ongoing support. With these leading practices, value is added at each stage of engagement.
  • CONSUME. Intelligent staged approach via NetSuite’s industry ‘stairway’ allows companies to consume capabilities based on their business needs. Re-imagined consumption model drives faster time to value, better ROI and greater user adoption. Companies can now go from zero to cloud in as little as 100 days.
  • OPTIMISE. Customers benefit from continuous engagement, updated leading practices, new feature releases, value added SuiteCloud partners, and movement up the stairway. Customers are also always on the latest release.

Financials First Provides Foundation for Cloud Expansion

The Financials First SuiteSuccess edition, available today, allows companies to quickly and easily transition from their legacy financials system to NetSuite’s cloud-based platform. With more than 40,000 organisations and subsidiaries as customers, NetSuite has extensive experience with moving companies across all sectors to the cloud. With Financials First, businesses can automate financial processes, speed month-end close, improve reporting and gain real-time visibility into the true financial status of the organisation – in as little as 100 days.

Financials First includes pre-defined roles, KPIs, dashboards and workflows, all designed with finance departments in mind. Of specific importance to UK and Ireland-based companies, the Financials First Edition also includes fixed assets electronic payments, enabling automated payments to reduce payment processing times, improve payment accuracy and timeliness and automated tracking of fixed assets to account for depreciation.

With a foundation in place for financials, customers can then progress through the NetSuite ‘stairway’, adding modules such as inventory management, ecommerce or industry-specific features. NetSuite customers running Financials First that plan to expand globally are immediately able to take advantage of NetSuite’s OneWorld global capabilities. NetSuite OneWorld supports 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and customer transactions in more than 200 countries, enabling businesses to quickly and easily set up new subsidiaries.

SuiteSuccess for Wholesale Distribution Jump Starts Cloud Transitions in the UK, Ireland

One of the first SuiteSuccess solutions developed, SuiteSuccess for Wholesale Distribution is now available for customers in the UK and Ireland. It gives wholesale distributors a structured, agile path to the cloud enabling them to quickly and easily add features and modules as their business grows.

The key components of SuiteSuccess for Wholesale Distribution include:

  • Tailored roles with built-in workflows specific to wholesale distribution such as supply chain manager, warehouse operations and AP analyst.
  • Industry leading best practices built into the system spanning inventory utilisation and visibility, order orchestration and more.
  • More than 150 Pre-built KPIs and reports, giving wholesale distributors real-time insight into the business from Day 1.
Contact Info
Sarah Heinz
Public Relations
+44 (0) 208 118 6013
OracleNetSuite@cmgrp.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.co.uk.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuiteEMEA Twitter handle for real-time updates.

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 www.oracle.com.

Trademarks

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

Talk to a Press Contact

Sarah Heinz

  • +44 (0) 208 118 6013

NetSuite Unveils New OneWorld Features for EMEA Companies

Oracle Press Releases - Mon, 2017-10-16 04:00
Press Release
NetSuite Unveils New OneWorld Features for EMEA Companies New Features Give EMEA Companies Access to Country-Specific Business Requirements to Succeed in the Cloud

NEXT READY BUSINESS TOUR 2017, London—Oct 16, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced more NetSuite OneWorld features localised for EMEA headquartered companies. The new features unveiled today deliver the global financial capabilities to allow businesses to gain greater financial control over intercompany accounting across multiple jurisdiction countries, improve auditing processes, reduce financial close time, and provide businesses with an exceptional experience when conducting bank reconciliation. NetSuite additionally announced today new localized features in Spain and Portugal, to help meet country-specific business requirements and tax and regulatory compliance.

Already in use by more than 3,000 subsidiaries and legal entities of global companies running businesses across EMEA, NetSuite OneWorld, winner of the 2017 UK Cloud award for ERP Product of the Year, provides a unified and cloud-based suite of software that is flexible enough to meet the needs of diverse business models, legal structures and geographies. NetSuite OneWorld supports 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and customer transactions in more than 200 countries.

EMEA Companies Receive More Global Financial Features for Operational Efficiency

Companies with headquarters in EMEA and local subsidiaries continue to confront challenges managing accounting across multiple countries while maintaining auditability. The new features released in NetSuite OneWorld give organisations across EMEA rich new capabilities, including book-specific intercompany journal entries, cross book reporting, deferred expense roll forward report, and GL audit numbering in searches and reports to fulfill Storno requirements for reversing transactions. The new features also improve auditability, giving companies even greater financial controls.

“With these new OneWorld features, companies in EMEA are reaping the benefits of NetSuite’s ongoing commitment to the region, now backed by the resources of Oracle,” said Craig Sullivan, Group Vice President of Product Development for NetSuite. “From dealing with the complexities of acting global in operating across multiple jurisdictions, to easier bank reconciliation, to being local and keeping up with the latest taxation and regulatory changes, NetSuite customers know they have a platform and partner that is ready to support their needs now for their next.”

Other features include country-specific support depreciation for Benelux companies and support for the EU Sales Listing for Belgium. For Middle East headquartered countries, NetSuite OneWorld includes new country-specific features, including support for the new Unified Value Added Tax (VAT) Agreement, set to take effect for Saudi Arabia and the United Arab Emirates (UAE) in 2018 with more Gulf Cooperation Council (GCC) countries expected to follow.

Additionally, NetSuite OneWorld has made significant additions to its bank reconciliation and transaction matching capabilities. As EMEA-based companies see increasing utilisation and modernisation of electronic banking systems and more complex reconciliation requirements, NetSuite OneWorld has delivered support for: industry-standard commercial banking statement formats including BAI2 and MT940 using ISO20022 (CAMT053.006.001); a new UI and side-by-side matching; an advanced transaction matching engine; and user-defined rules to support additional matching criteria. The new bank reconciliation provides an exceptional, modern user experience and is just the first in a number of advancements planned over the next few releases.

NetSuite Extends Localisations for Spain and Portugal

Leveraging Oracle’s global resources, NetSuite has accelerated business expansion into more and more countries throughout EMEA. Following recent announcements of new operations in the United Arab Emirates and South Africa, NetSuite has extended its product localizations and support for Spain and Portugal, where it currently has an expanding partner network, to include:

  • Country-specific indirect tax support for Spain – support for the new VAT management system (the SII) that went into effect in Spain 1 July, 2017. The new system requires companies to submit the VAT register books through the tax administration’s online platform on a real-time basis.
  • Country-specific indirect tax support for Portugal – support for the updated SAFT-PT requirement for Portugal. The latest release of NetSuite OneWorld includes localised features for Nordics-headquartered companies across indirect tax reports for EU Sales listing and Intrastat reports in Denmark and Finland, and support for the Swedish Svenska Enskilda Banken (SEB) payment format.
 

NetSuite OneWorld delivers a real-time, unified global business management platform for companies that manage multinational and multi-subsidiary operations and provides real-time visibility at the local, regional and headquarter levels. With NetSuite OneWorld, companies can easily manage multiple subsidiaries, business units and legal entities all from a single cloud-based ERP system, while seamlessly handling different currencies, taxation rules, compliance and reporting requirements. To learn more about NetSuite OneWorld, visit www.netsuite.com/portal/products/global-business-management.shtml

Contact Info
Sarah Heinz
Public Relations
+44 (0) 208 118 6013
OracleNetSuite@cmgrp.com
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit http://www.netsuite.co.uk.

Follow NetSuite’s Cloud blog, Facebook page and @NetSuiteEMEA Twitter handle for real-time updates.

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 www.oracle.com.

Trademarks

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

Talk to a Press Contact

Sarah Heinz

  • +44 (0) 208 118 6013

When does RMAN validate archived redo logs are available during a duplicate?

Tom Kyte - Mon, 2017-10-16 00:26
Does RMAN validate all archived redo logs are available at the beginning of a duplication or once it starts restoring the logs after the backup data files have been restored?
Categories: DBA Blogs

Keyword Rank Tracking Tools

Nilesh Jethwa - Sun, 2017-10-15 13:34

An important element of search engine optimization (SEO) is choosing the right keyword. With the right keywords, you can make your content rank on search engines. But the work doesn’t stop after ranking, you still need to track the position of your keyword during the search. That way, you can obtain helpful information that will guide you in keeping your SEO efforts successful.

Why Check Keyword Ranking Regularly

One of the main reasons why you need to check your keyword ranking is to identify target keywords. Any SEO professional or blogger should understand how important it is for their content marketing strategies. In fact, a common mistake committed by website administrators and bloggers is writing and publishing articles that don’t target any keywords. It’s like aiming your arrow at something that you are not sure of.

Here are some of the best tools you can take advantage of when tracking your keyword rank:

SEMRUSH. When using this keyword rank tracking tool, it will take 10 to 15 minutes in order to determine which keywords or key phrases to use. Whether you are a webmaster or SEO specialist, this tool will help you analyze data for your clients and website. It also offers useful features such as in-depth reports, keyword grouping, and competitor tracking.

Google Rank Checker. This is a premium online tool that you can use for free. It will help you in tracking keyword positioning while making sure that you appear in search results. To use Google Rank Checker, all you need to do is enter the keywords that you want to check as well as your domain name. After putting in the details, you will now view the keyword rank.

 

Read more at https://www.infocaptor.com/dashboard/best-tools-for-keyword-rank-tracking

Oracle SOA Suite developer IDE: Creating a BPEL process (101HelloWorld)

Dietrich Schroff - Sun, 2017-10-15 05:53
After downloading and installing jdeveloper SOA Suite edition here a short 101 for building a BPEL process. (Nearly 10 years ago i posted the lost collaxa tutorials: 101.HelloWorld. All of these tutorials can be found here.)

First you have to start your jdeveloper (Middleware/Oracle_Home/jdeveloper/jdev/bin/jdev) and choose "All Features":
Then create a new application:
and choose SOA application:
and walk through the application wizard:
application wizard 2/3
application wizard 3/3
application wizard 3.1/3 (create BPEL process)

and here we are:

a right click onto the blue BPELProcess1 icon and "edit" opens the BPEL process:


On the right hand to this process you can find the components palette:

Now drag and drop the assign icon between the receiveInput and replyOutput node:


A right click to the Assign node and choosing "edit" will open up this dialog:


You can do this mapping via drag and drop:


and finished!

A nice feature of jdeveloper is the "History" tab, where you can compare changes within the XML:


Next posting i will show, how you can run this BPEL process within the jdeveloper builtin weblogic server.

International Financial Reporting Standards (IFRS)

OracleApps Epicenter - Sun, 2017-10-15 00:59
International Financial Reporting Standards (IFRS) Oracle’s Financial Mgmt Solutions Segment reporting Specialized currency Intercompany reconciliations Inventory management Multi-GAAP management Flow, audit trails Custom dimensions Financial intelligence Simulations, impacts Reports, MS Office direct links   IFRS is coming to the US Oracle is designed to address the IFRS requirements Organizations likely didn’t originally implement Oracle with […]
Categories: APPS Blogs

Debugging bash scripts on remote hosts using Eclipse

Dietrich Schroff - Sat, 2017-10-14 14:05
After installing the two plugins
it is very easy to debug scripts inside your workspace on your computer. But i was wondering, if this can work on a remote host, too.

So what has to be done?

Only these steps:
  • copy your shell scripts AND _DEBUG.sh onto your remote host
  • change the first line of _DEBUG.sh from
    exec 33<>/dev/tcp/localhost/33333
    to
    exec 33<>/dev/tcp/host_running_eclipse/33333
After that start the debugger in eclipse and then run the shell script on the remote host. Done.

If this does not work: Check for firewalls blocking port 33333

Submitting Questions

Tom Kyte - Sat, 2017-10-14 11:46
Hi Tom, I've been consulting your site for years, and its almost always a source of answers to just about all Oracle issues I encounter. On rare occasions I might encounter an issue not previously discussed, but there's an uncertainty how long I w...
Categories: DBA Blogs

Mmm, π

Oracle WTF - Sat, 2017-10-14 06:31

Young rz.He over on Stack Overflow has a question about why SQL*Plus doesn't parse every damn line of a PL/SQL block in case it's a comment in order to avoid unnecessary prompts for substitution variables. Here's his mcve:

SQL> begin
  2      null; -- &commented_out
  3  end;
  4  /
Enter value for commented_out: wtf

PL/SQL procedure successfully completed.

Oh, wait - it's not that. It's actually this:

CREATE OR REPLACE PROCEDURE cal_circle AS
-- DECLARE

  pi              CONSTANT NUMBER := 3.1415926;
  radius          NUMBER := 3;

  -- to make it more dynamic I can set 
  -- radius NUMBER := &enter_value;

  circumference   DECIMAL(4,2) := radius * pi * 2;
  area            DECIMAL(4,2) := pi * radius ** 2;

BEGIN

  -- DBMS_OUTPUT.PUT_LINE('Enter a valur of radius: '|| radius);
  dbms_output.put_line('For a circle with radius '
   || radius
   || ',the circumference is '
   || circumference
   || ' and the area is '
   || area
   || '.');
END;
/

But anyway.

This excellent answer explains all about clients and servers and procedure parameters and why it's really not SQL*Plus's job to pre-parse everything before sending it to the database and it wouldn't be such a great idea if it did. I voted up. But what really baked my noodle was the opening comment (my emphasis):

You can use a parameter instead of a substitution variable to allow different users to call the procedure with different values of pi.

...with a fixed version of the code posted as an example...

CREATE OR REPLACE PROCEDURE CAL_CIRCLE(P_RADIUS IN NUMBER, P_PI IN NUMBER) AS
  CIRCUMFERENCE DECIMAL(4, 2) := P_RADIUS * P_PI * 2;
  AREA          DECIMAL(4, 2) := P_PI * P_RADIUS ** 2;

BEGIN
  DBMS_OUTPUT.put_line('For a circle with radius '
                       || P_RADIUS
                       || ', the circumference is '
                       || CIRCUMFERENCE
                       || ' and the area is '
                       || AREA
                       || '. ' || 'Calculated with Pi = ' || P_PI);
END;

You will agree that is much more flexible. Now we can call it for a conventional π, like this:

SQL> call cal_circle(3, 3.1416);
For a circle with radius 3, the circumference is 18.85 and the area is 28.27. Calculated with Pi = 3.1416

Or like this:

SQL> call cal_circle(3, acos(-1));
For a circle with radius 3, the circumference is 18.85 and the area is 28.27. Calculated with Pi = 3.1415926535897932384626433832795028842

But what if we need to switch to the imperial π following our exit from the EU, or the chancellor increases the UK's π in the next budget in order to stimulate economic growth, or if we simply want to use the same procedure in an alternative universe with a fundamentally different geometry than our own? No problem:

SQL> call cal_circle(3, 2.71828);
For a circle with radius 3, the circumference is 16.31 and the area is 24.46. Calculated with Pi = 2.71828

Now that is reusability. (The radius can't be more than 9.99, but come on, you can't have everything.)

As usual, of course, the easy way is no fun:

create or replace function circumference
    ( p_radius in number )
    return number
    deterministic
as
begin
    return p_radius * 6.2831853071795864769252867666;
end circumference;

Study: ASC 606 Might Slow IPOs in 2018 ??

OracleApps Epicenter - Fri, 2017-10-13 20:33
A new study by Deloitte reveals that initial public offerings (IPOs) may suffer as a result of New Accounting Standard (ASC606) Here are excerpts from an article by Terry Sheridan in accountingWEB.com Here’s a snapshot of the survey’s findings: 60 percent of the respondents said they have not begun implementation of the standard or have […]
Categories: APPS Blogs

After install of 12,2 on Windows 10, I can only connect as SYS

Tom Kyte - Fri, 2017-10-13 17:26
I have installed Oracle 12c Release 2 twice as a non-container database. The issue I have run into both times is that I keep getting "ORA-01017: invalid username/password; logon denied" every time I try connecting as any user other than SYS. See exam...
Categories: DBA Blogs

How to Create backup table from one schema to another schema every time the live schema table is inserted or deleted or updated

Tom Kyte - Fri, 2017-10-13 17:26
Hi, I want to know How to create a backup table that will backup data from one schema to another schema table every time the live table is inserted or updated or deleted. Awaiting for your response. Thanks, Ershad
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator