I fail to understand anonymous PL/SQL block is used with dbms_scheduler.
Here is an example:
hawk:(SYSTEM@hawk):PRIMARY> set echo on
5 x NUMBER := 100;
7 FOR i IN 1..10 LOOP
8 IF MOD(i,2) = 0 THEN
9 INSERT INTO temp VALUES (i);
11 INSERT INTO temp VALUES (i);
12 END IF;
13 x := x + 100;
The new Q4 2016 Forrester Wave report on Mobile Development Platforms is out and Oracle is rocking the leadership zone. Below are a few choice quotes, but you can download the report and read it for yourself.
- “Oracle’s vision and road map set the pace in this market"
- Oracle has quickly “made and immediate impact with over 150 customers already on the platform”
- "Its developer experience is impressive" Got that? Who's owning the direction of (more...)
With your database in archive log mode, a Data Pump Import may be severely slowed down by the writing of much redo into online logs and the the generation of many archive logs. A 12c New Feature enables you to avoid that slow down by suppressing redo generation for the import only. You can keep the database in archive log mode the whole time. Let’s see that in action!
First without the new feature:
I got to Birmingham Airport about 2.5 hours early, so I had no drama at the bag check or security. I’ve mentioned a couple of times I’ve been really nervous about this journey. As I waited the nerves started to take their toll and I puked before I got on the plane.
The flight to Dubai was unusually uncomfortable. I think part of that was because I was already really tired before getting on (more...)
This is the 37th installment of my blog series around Stream Processing and Analytics.
As usual, find below the new blog articles, presentations, videos and software releases from last week:
News and Blog Posts
I created a new GitHub public repository with my SQL scripts. Here is the URL:
I’ve experimented with GitHub for my Python graphing scripts but wasn’t sure about putting the SQL out there. I don’t really have any comments in the SQL scripts. But, I have mentioned many of the scripts in blog posts so those posts form a type of documentation. Anyway, it is there so people can see it. Also, I get (more...)
This was a strange one. Attempts at recompiling the following package body resulted in this PLS-00801 error. COL owner FOR A20 COL object_name FOR A40 BREAK ON object_name SELECT owner, object_name, object_type, status, created, last_ddl_time FROM dba_objects WHERE object_name = 'PKG_FINANCIALS_WORK' ORDER BY status, object_type / OWNER OBJECT_NAME
This post comes from Fishbowl Solutions’ Associate MCAD Consultant, Ben Sawyer.
CAD data migrations are most often seen as a huge burden. They can be lengthy, costly, messy, and a general road block to a successful project. Organizations planning on migrating SolidWorks data to PTC Windchill should consider their options when it comes to the process and tools they utilize to perform the bulk loading.
At Fishbowl Solutions, our belief is that the faster (more...)
In this 5th blog post in my series on using the capabilities of Oracle Text, Oracle R Enterprise and Oracle Data Mining to process documents and text, I will have a look at some of the machine learning features of Oracle Text.
Oracle Text comes with a number of machine learning algorithms. These can be divided into two types. The first is called 'Supervised Learning' where we have two machine learning algorithms for classification type (more...)
wrote a blog about differences between bind peeking and SYS_CONTEXT
in SQL queries. This even led to an proposal in Database Ideas: CBO should peek at SYS_CONTEXT values just like bind values
(feel free to vote and comment, if you like it)
As I have a friend who really loves SYS_CONTEXT; I showed him the blog.
In the following discussion he stated (more/less
I should not have this problem at all, as (more...)
Software updates often include new features, and while useful, these new features are often the only driving factors in upgrading software. There's no harm in wanting to play around with the shiny new toy but many software updates also include much more significant changes, such as resolving bugs or security vulnurabilities.
In fact, bug fixes and security patches are usually released on a more frequent schedule than new feature sets. These changes are necessary to (more...)
Why is cloud so important?
Data warehouses are currently going through two very significant transformations that have the potential to drive significant levels of business innovation:
The first area of transformation is the drive to increase overall agility. The vast majority of IT teams are experiencing a rapid... [Read More
We are proud to announce the release of Oracle Fusion Middleware 12c (188.8.131.52.0).
Media is available for download on the Oracle Technology Network (OTN),
My Oracle Support (MOS) and the Oracle Software Delivery Cloud (OSDC).
This includes the following products:
- Oracle SOA Suite and Business Process Management 12c (184.108.40.206.0)
- Oracle B2B and Healthcare 12c (220.127.116.11.0)
- Oracle Service Bus 12c (more...)
In my previous article New Package Manager in Action I showed 3 possible methods for installing additional Stage Libraries onto a StreamSets Data Collector core distribution.
In this article I will demonstrate how this can be used with the Docker distribution of StreamSets Data Collectosr (SDC). Starting with SDC v18.104.22.168, the public Docker image on Docker Hub is no longer based on the full version but on the smaller, customizable core version.
We've previously provided advice on the general priorities for applying EBS updates and creating a comprehensive maintenance strategy.
Here are our latest upgrade recommendations for E-Business
Suite updates and technology stack components. These quarterly
recommendations are based upon the latest updates to Oracle's product
strategies, latest support timelines, and newly-certified releases.
You can research these yourself using this Note:
At 11:00 AM Pacific on Tuesday, October 25th (tomorrow), I have the privilege of talking about Cloud and on-premise (ground) integration. Whether cloud to cloud, cloud to ground, or ground to ground, integration is probably one of the most difficult aspects of any implementation. Integration comes in two flavors:
Back-end integration is the most common. Back-end integration involves integrating data between two systems either for processing or presenting a common user experience.