Feed aggregator

how to reset a sequence

Tom Kyte - Wed, 2018-06-20 01:26
Create sequence with no options, and the current value of the sequence is 10. Specify the statements in order to reset the sequence to 8, so that the next value will be generated after 8 is 11. Find out logic.
Categories: DBA Blogs

Log of switchover/failover/open

Tom Kyte - Wed, 2018-06-20 01:26
What data dictionary view can be used to determine the number of times that a switchover/failover/open has occurred for a standby database?
Categories: DBA Blogs

connection pooling

Tom Kyte - Wed, 2018-06-20 01:26
Tom, What is connection pooling ? Please, can you give an example(s) that show thorough understanding of the subject matter as related to either ODBC OR JDBC application connections to the oracle database. Your site is more important and most val...
Categories: DBA Blogs

API Monetization: What Developers Need to Know

OTN TechBlog - Tue, 2018-06-19 23:15

You’ve no doubt heard the term “API monetization,” but do you really understand what it means? More importantly, do you understand what API monetization means for developers?

“The general availability of information and services has really influenced the way APIs behave and the way APIs are built,” says Oracle ACE and Developer Champion Arturo Viveros, principal architect at Sysco AS in Norway. “The hyper-distributed nature of the systems we work with, with cloud computing and with blockchain, and all of these technologies, makes it very important. Everyone wants to have information in real time now, as opposed to before when we could afford to create APIs that could give you a snapshot of what happened a few hours ago, or a day ago.”

These days the baseline consumer expectation is 24/7/365 service. “So, as a developer, when you’re designing APIs that are going to be exposed as business assets or as products, you need to take into account characteristics like high availability, performance resiliency, and flexibility,” says Viveros. “That’s why all of these new technologies go into supporting APIs, like microservices and containers and serverless. It's so critical to learn to use them because they allow you to be flexible to deploy new versions or improved versions of APIs. They allow your APIs to have an improved life cycle and to move away from the whole monolithic paradigm, reduce time to market, and move forward at the speed that the organization and your user base and consumer base require.”

So yeah, there’s a bit of a learning curve. But hasn’t that always been the developer’s reality? And hasn’t there always been some kind of reward at the end of the learning curve?

“It’s an exciting time for developers,” says Luis Weir. He’s an Oracle ACE Director, a Developer Champion, and the CTO of the Oracle Delivery Unit with Capgemini in the UK. “API monetization is an opportunity to add direct tangible value to the business. APIs have become a source of revenue on their own,” says Weir. “This is quite exciting. I don't think this is something that we’ve seen before in the IT industry. Whatever APIs we had in the past were in support of a business product, they were not the business product. That's different, and I think developers have the opportunity now to be completely, directly involved in the creation and maintenance of these products.”

While developing APIs is certainly important, it’s no less important to take advantage of what is already out there. “Developers within an organization need to be thinking about what APIs might be available to complete functions that are not within their core competency,” says Robert Wunderlich, product strategy director for Cloud, API, and Integration at Oracle. “There are a lot of publicly available APIs that can be used for low or no cost or a reasonable cost.”

[For example, check out the API Showcase on the NYC Developer Portal ]

Luis Weir sees another important aspect of API monetization. “As a developer it's always exciting to see how your product is received. For example, when you create an open source GitHub project and then all of a sudden you see a lot of people forking your project and trying to trace pull requests to contribute to it, that's exciting because that means that you did something that added to your organization or to the community. That's rewarding as a developer. It’s far more rewarding to see an IT asset that's directly influencing the direction of the business.” API monetization provides that visibility.

Arturo Viveros, Luis Weir, and Robert Wunderlich explore API monetization in depth from a developer perspective in this month’s Oracle Developer Community Podcast. Check it out!

The Panelists

In alphabetical order

Arturo Viveros
Oracle ACE
Oracle Developer Champion
Principal Architect, Sysco AS
Twitter LinkedIn Luis Weir
Oracle ACE Director
Oracle Developer Champion
CTO, Oracle Delivery Unit, Capgemini UK
Twitter LinkedIn Robert Wunderlich
Product Strategy Director for Cloud, API, and Integration, Oracle
Twitter LinkedIn  Additional Resources Subscribe

Never miss an episode! The Oracle Developer Community Podcast is available via:

Q4 FY18 GAAP EPS UP 8% TO $0.82 and NON-GAAP EPS UP 11% TO $0.99

Oracle Press Releases - Tue, 2018-06-19 14:21
Press Release
Q4 FY18 GAAP EPS UP 8% TO $0.82 and NON-GAAP EPS UP 11% TO $0.99 Q4FY18 Total Revenue Up 3% to $11.3 Billion and FY18 Total Revenue Up 6% to $39.8 Billion

Redwood Shores, Calif.—Jun 19, 2018

Oracle Corporation (NYSE: ORCL) today announced fiscal 2018 Q4 results and fiscal 2018 full year results. In Q4, Total Revenues were up 3% to $11.3 billion compared to Q4 last year. Q4 Cloud Services and License Support revenues were up 8% to $6.8 billion. Q4 Cloud License and On-Premise License revenues were down 5% to $2.5 billion.

Q4 GAAP Operating Income was up 8% to $4.4 billion, and GAAP Operating Margin was 39%. Q4 Non-GAAP Operating Income was up 6% to $5.3 billion, and non-GAAP Operating Margin was 47%. Q4 GAAP Net Income was $3.4 billion, and non-GAAP Net Income was $4.1 billion. Q4 GAAP Earnings Per Share was up 8% to $0.82, while non-GAAP Earnings Per Share was up 11% to $0.99.

At the end of Q4, short-term deferred revenues were up 2% to $8.4 billion, while Operating Cash Flow on a trailing twelve-month basis was up 9%, or $1.3 billion, to a record $15.4 billion.

For the full fiscal year 2018, Total Revenues were up 6% to $39.8 billion compared to fiscal 2017. FY18 Cloud Services and License Support revenues were up 10% to $26.3 billion. FY18 Cloud License and On-Premise License revenues were down 4% to $6.2 billion.

FY18 GAAP Operating Income was up 8% to $13.7 billion, and GAAP Operating Margin was 34%. FY18 Non-GAAP Operating Income was up 9% to $17.6 billion, and non-GAAP Operating Margin was 44%. FY18 GAAP Net Income was $3.8 billion, and non-GAAP Net Income was $13.2 billion. FY18 GAAP Earnings Per Share was $0.90, while Non-GAAP Earnings Per Share was $3.12.

“Last year, I forecast double-digit non-GAAP earnings per share growth for FY18 and we delivered 14% growth this year, largely driven by strong growth in our cloud businesses,” said Oracle CEO, Safra Catz. “Looking ahead to FY19, I expect revenue growth will enable us to deliver double-digit non-GAAP earnings per share growth once again.”

“We had a great fourth quarter with total revenues more than $200 million above our constant currency forecast,” said Oracle CEO, Mark Hurd. “Our strategic Fusion ERP and HCM SaaS cloud applications suite revenues grew over 50% in the fourth quarter, and we expect continued strong growth from our Fusion SaaS suites throughout FY19.”

“Some of our largest customers have now begun the process of moving their on-premise Oracle databases to the Oracle Cloud,” said Oracle Chairman and CTO, Larry Ellison. “For example, AT&T is moving thousands of databases and tens of thousands of terabytes of data into the Oracle Cloud. We think that these large scale migrations of Oracle database to the cloud will drive our PaaS and IaaS businesses throughout FY19.”

The Board of Directors also declared a quarterly cash dividend of $0.19 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on July 17, 2018, with a payment date of July 31, 2018.

Q4 Fiscal 2018 Earnings Conference Call and Webcast

Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast of this event, please visit the Oracle Investor Relations website at http://www.oracle.com/investor. In addition, Oracle’s Q4 results and fiscal 2018 financial tables are available on the Oracle Investor Relations website.

A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Pass Code: 6866209.

Contact Info
Ken Bond
Oracle Investor Relations
Deborah Hellinger
Oracle Corporate Communciations
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE: ORCL), visit www.oracle.com/ or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.


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

“Safe Harbor” Statement

Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding our expectations for future growth in revenues, non-GAAP earnings per share and our Fusion SaaS suite of products, and our beliefs that large scale customer cloud migrations will drive our PaaS and IaaS businesses in FY19, are "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Our cloud computing strategy, including our Oracle Cloud SaaS, PaaS, IaaS and data as a service offerings, may not be successful. (2) If we are unable to develop new or sufficiently differentiated products and services, enhance and improve our products and support services in a timely manner or position and price our products and services to meet demand, customers may not buy cloud licenses and on-premise licenses, cloud services or hardware products or purchase or renew support contracts. (3) If the security measures for our products and services are compromised or if our products and services contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and reduced sales. (4) Economic, political and market conditions can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. (7) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. A detailed discussion of these factors and other risks that affect our business is contained in our U.S. Securities and Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading “Risk Factors.” Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of June 19, 2018. Oracle undertakes no duty to update any statement in light of new information or future events. 

Talk to a Press Contact

Ken Bond

  • +1.650.607.0349

Deborah Hellinger

  • +1.212.508.7935

APIs to the Rescue in the Aftermath of 2017 Mexican Earthquake

OTN TechBlog - Tue, 2018-06-19 13:38

After three weeks Hawaii's Kilauea volcano is still busy eating an island. Early in June Guatemala's Volcan De Fuego erupted and is still literally shaking the earth. And just this past weekend a 5.3 magnitude quake struck Osaka, Japan. Mother Earth knows how to get our attention. But in doing so she also triggers an impulse in some human beings to jump in and help in any way they can.

One great example of that kind of techie humanitarianism is the group of Mexican developers and DBAs who, in the immediate aftermath of the earthquake that hit Mexico in 2017, banded together in a collaborative effort to rapidly build a system to coordinate rescue and relief efforts.

Oracle ACE Rene Antunez was one of the volunteers in that effort. He shares the organizational and technical details in this video interview recorded at last week's ODTUG Kscope 2018 event in Orlando.

Given that natural disasters are likely to continue to happen, the open source project is ongoing, and is available on GItHub:


Why not lend your skills to this worthwhile effort?

Have you been involved in similar humanitarian software development efforts? post a comment below


Oracle Hospitality OPERA Reporting and Analytics Cloud Service Arms Hoteliers with Critical Insights to Improve Operational Efficiencies and Create Rewarding Guest Experiences

Oracle Press Releases - Tue, 2018-06-19 08:00
Press Release
Oracle Hospitality OPERA Reporting and Analytics Cloud Service Arms Hoteliers with Critical Insights to Improve Operational Efficiencies and Create Rewarding Guest Experiences New Analytical Tools Empower Corporate Revenue Managers, Property General Managers and Front Desk Managers to Make More Strategic Decisions

Redwood Shores, Calif.—Jun 19, 2018

Oracle Hospitality today unveiled OPERA Reporting and Analytics Cloud Service, a new offering providing hotel management with access to business data and performance metrics, intuitive data visualization and customized reporting. OPERA Reporting and Analytics Cloud Service is powered by Oracle Business Intelligence (OBI) an industrial-strength analytics engine known for its capability to develop, design and deploy reports that is used by Fortune 100 organizations to leapfrog their competitors. With Oracle Business Intelligence at the core, OPERA Reporting and Analytics Cloud Service empowers corporate hotel executives and front-desk staff to make more strategic decisions that optimize operational efficiency, enhance guest experience, and drive continued revenue.

“OPERA Reporting and Analytics was developed with the goal of simplifying reporting, creating a common reporting platform for both our restaurant and hotel customers and integrating with OPERA platform to provide actionable insights to the hospitality industry faster than ever,” said Laura Calin, vice president strategy and solutions, Oracle Hospitality. “With these new tools hotel staff at every level can make more accurate and strategic decisions that align to corporate growth objectives while enabling meaningful guest interactions that enhance guest loyalty.”

OPERA Reporting and Analytics enables smarter decisions and better forecasts by allowing management to easily analyze and visualize data on property financial performance, guest profiles, reservations, room rates and revenue metrics, restaurant sales, catering events, and blocks. The solution can be fully customized to reflect performance indicators and metrics unique to individual properties and multiple tiers of hotel staff.

Empowering Staff at Every Level to Execute Better

OPERA Reporting and Analytics provides hotel staff at all levels to drive revenue and better guest experiences with a variety of use cases including:

  • Allowing corporate and area revenue managers to analyze performance across multiple properties in a region and understand the factors that cause revenue to fluctuate year to year.
  • Providing general managers with deep analysis of daily operations and measurement against room revenue, food and beverage revenue and occupancy which can be aligned with monthly, quarterly and annual performance goals.
  • Empowering front desk management to offer better guest experience by accelerating guest check-in and prioritizing room availability for loyal or VIP guests with near real-time perspective on departures and room inventory.

Contact Info
Matt Torres
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.

About Oracle Hospitality

Oracle Hospitality brings 35 years of experience in providing technology solutions to food and beverage operators and hoteliers. We provide hardware, software, and services that allow our customers to deliver exceptional guest experiences while maximizing profitability. Our solutions include integrated point-of-sale, loyalty, reporting and analytics, inventory and labor management, all delivered from the cloud to lower IT cost and maximize business agility.

For more information about Oracle Hospitality, please visit www.oracle.com/Hospitality


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

Safe Harbor

The above 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.

Talk to a Press Contact

Matt Torres

  • 415-595-1584

How to detect if insert transactions in oracle db are really slow?

Tom Kyte - Tue, 2018-06-19 07:06
At work, I have an Oracle DB (11g) in which I want to detect if there's slow performance while inserting data. Here's the situation: Some production devices send data results from tests to Server A, this server is a important server and it replica...
Categories: DBA Blogs

How i can optimize this operation DELETE if the values ares setted in codehard.

Tom Kyte - Tue, 2018-06-19 07:06
Hi, I'm a bit new to the development of plsql. I would like to know how I could optimize the delete operation with a forall if my query is the following: DELETE FROM SCH.TA_DELETE WHERE FIACUM < 1 AND FIPAIS = 1 AND F...
Categories: DBA Blogs

problem of inserting a long string of characters

Tom Kyte - Tue, 2018-06-19 07:06
Hello Team , I'm trying to insert into a table " TEST COM " the result of selecting rows of another table. I used the wm_concat function . /**********/ insert into COMMENTAIRE_TEST (SELECT wm_concat((DBMS_LOB.SUBSTR(COM_TEXTE,400...
Categories: DBA Blogs

Use RESULT_CACHE in subqueries

Tom Kyte - Tue, 2018-06-19 07:06
Dear Tom, I am thinking to use the new feature "RESULT_CACHE" to optimize some search queries for my paginated pages. So far, for a search page I have : 1.) a count query and 2.) the query that returns a page from the result set Both 1 an...
Categories: DBA Blogs

database links

Tom Kyte - Tue, 2018-06-19 07:06
how can i create database links to access remote databases. please tell me the procedure of creating database links.
Categories: DBA Blogs

How to avoid repeated function call for multiple columns' values.

Tom Kyte - Tue, 2018-06-19 07:06
Hi I'm refactoring an old procedure that calls a function for determining whether passed in values consist of only characters allowed in the front end app on top of the database. The procedure has a cursor that gathers all records it needs to ...
Categories: DBA Blogs

Docker: Network configuration - none / brigde / hostname / dns entries

Dietrich Schroff - Tue, 2018-06-19 01:59
If you are starting your docker container you can add some network configuration details via command line.
Let's start with the easiest network setting:
docker run -it  --net none alpine /bin/ash
This setting starts the container without any connectivity to the network:
# ip addr show
1: lo: mtu 65536 qdisc noqueue state UNKNOWN qlen 1
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet scope host lo
       valid_lft forever preferred_lft forever
The default is --net bridge:
docker run -it  --net bridge alpine /bin/ash
With this setting your network access is via a bridge of your host:
# ip addr show
1: lo: mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet scope host lo
valid_lft forever preferred_lft forever
7: eth0@if8: mtu 1500 qdisc noqueue state UP
link/ether 02:42:ac:11:00:02 brd ff:ff:ff:ff:ff:ff
inet scope global eth0
valid_lft forever preferred_lft forever
This is the docker0 interface on your docker server machine:
alpine:~# ip addr show
1: lo: mtu 65536 qdisc noqueue state UNKNOWN qlen 1
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000
link/ether 08:00:27:72:ae:ef brd ff:ff:ff:ff:ff:ff
inet brd scope global eth0
valid_lft forever preferred_lft forever
inet6 fe80::a00:27ff:fe72:aeef/64 scope link
valid_lft forever preferred_lft forever
3: docker0: mtu 1500 qdisc noqueue state DOWN
link/ether 02:42:ba:e9:4d:6a brd ff:ff:ff:ff:ff:ff
inet scope global docker0
valid_lft forever preferred_lft forever
inet6 fe80::42:baff:fee9:4d6a/64 scope link
valid_lft forever preferred_lft forever
4: docker_gwbridge: mtu 1500 qdisc noqueue state DOWN
link/ether 02:42:62:f0:92:82 brd ff:ff:ff:ff:ff:ff
inet scope global docker_gwbridge
valid_lft forever preferred_lft forever
Finally you can configure your hostname and manipulate dns entries:
# docker run -it  --net bridge  --hostname myhostname --add-host mygoogle.com:  alpine /bin/ash
/ # hostname
/ # nslookup mygoogle.com
nslookup: can't resolve '(null)': Name does not resolve

Name: mygoogle.com
Address 1: mygoogle.com

Are Wireframes and Prototypes Different?

Nilesh Jethwa - Mon, 2018-06-18 23:08

Both wireframing and prototyping are two essential processes in web and app development. Their main purpose is to establish the basic functions of the project and to present the working design concept. It is mostly shown to clients, but they … Continue reading ?

Via: MockupTiger Wireframes

Custom JavaScript Client Code in Oracle Visual Builder

Andrejus Baranovski - Mon, 2018-06-18 16:17
Hey, this is my first post about VBCS, you should expect more posts in the future about this topic. Red Samurai decided to choose VBCS as our primary JavaScript development IDE in the cloud. We are going to use it for declarative JS development, similar as we use JDeveloper for ADF.

I was going through the custom JS client code functionality in VBCS and thought it would be good idea to describe how it works. There is good material available for the same topic from Oracle, I recommend to go through it - Variables, Modules, and Functions, OH MY! Custom Client Code in Visual Builder.

I have created simple UI with one input and one output field. Button calls custom JS method, where value from input field will be processed and returned to be displayed in disabled field:

Below I will describe how all parts are wired together. Across different parts of VBCS there is a lot of resemblance with the way how ADF development done - this helps to reuse ADF skills for VBCS.

VBCS allows to define variables on 3 levels:

1. Page - page scope
2. Flow - flow scope
3. Application - application scope

In my example I decided to go with page scope variables (defined in page called main-start) - first one is assigned with input field and second with output:

There is property inspector, it allows to assign expressions to UI fields. Below you can see first variable assigned to input field:

Second variable is assigned to output field:

Button is assigned with action chain call - in VBCS we can call action chains. In ADF we call action listener and code Java logic in the method, here action chain gives more flexibility, you will see this below in action chain implementation:

VBCS allows to switch to code view and check HTML structure built with JET components. This is useful when you want to adjust generated code by yourself or copy layout to external JET project:

There is JS tab, associated with each VBCS page. There we can find JS file, where custom code can be included. I have created basic custom function, just for a test purpose:

VBCS JS code editor offers extensive auto suggest functionality - great help during development:

In case of syntax issues - errors are reported in audit window:

There is separate tab for action chains, I have already one - called from button (see above):

Action chain editor view - along with diagram, we have various components available. This looks slightly similar to SOA/BPM extension in JDeveloper, isn't it? In this action chain, first of all we call custom action - custom JS method define above:

Input parameter for JS call is assigned from page variable (input component):

In the next step - assign variables logic is called, this helps to assign function return value to page variable, which is mapped with output UI field:

Function return value mapping with page variable:

Application can be tested with single click, our message is printed in the log:

I have exported VBCS application and uploaded to GitHub repository. Once you export from VBCS, can access and check generated code. Here is main page code:

In main-start-page.json we can see metadata definition. For example, there we can find button event mapping with action chain:

VBCS looks very promising to me and I think this might be declarative JS development future.

PL/SQL Procedure - Catching "ORA - 01013 - User Requested Cancel of Current Operation"

Tom Kyte - Mon, 2018-06-18 12:46
It may be a silly question but I am wondering if there is any way to catch this error "ORA-01013 - User requested cancel of current operation" in a PL/SQL procedure. The requirement that I have is to update a database record before exiting when t...
Categories: DBA Blogs

Ambiguous overloading when parameter is null

Tom Kyte - Mon, 2018-06-18 12:46
<code></code>I have a package with an overloaded function, wich accepts one parameter (INTEGER / VARCHAR2) and returns a booblean indicating if exists a register with the correspondient column having the same value as the parameter. In tests, w...
Categories: DBA Blogs

JDBC thin dirver vs OCI driver

Tom Kyte - Mon, 2018-06-18 12:46
Hi Tom, i had some discussions with other colleagues about which driver should / could be used for connecting to an oracle database. I searched the web but found no sufficient answer for me (only a pretty old question from this site https://askto...
Categories: DBA Blogs

Replace characters in string

Tom Kyte - Mon, 2018-06-18 12:46
What's the best way to replace every character in string on random character and every number on other random number. I think about best performance. Input: MatijZ34 Output: sWirpt77
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator