Feed aggregator

Difference between SQL and PL/SQL

Tom Kyte - Mon, 2016-11-21 17:06
Hi, What is the Exact Difference Between SQL and Pl/SQL?How This Both are Integrated to Achieve the data from database? Thank you.
Categories: DBA Blogs


Tom Kyte - Mon, 2016-11-21 17:06
Hi, I need to Copy tables data From One DB to Another DB. There are some tables having row count around 99,000,000,000. One approach I can recollect is - insert /*+ APPEND */ into local_table select * from table@database_link; But APPE...
Categories: DBA Blogs

DDL rollback

Tom Kyte - Mon, 2016-11-21 17:06
Hi, I have some transactions in a procedure contains DDL Commands,I want to roll back whole the transactions done if happens anything wrong.So i would like to know is ROLLBACK of DDL is Possible in Oracle? Thank you.
Categories: DBA Blogs

Synchronising BEFORE and AFTER UPDATE triggers

Tom Kyte - Mon, 2016-11-21 17:06
Can a BEFORE UPDATE trigger on table A wait in a loop on a update to table B (by a Java batch program which also wants to read table A) before exiting and causing the AFTER UPDATE trigger on table A to commence?
Categories: DBA Blogs

ORA-00600: internal error while using rowid in merge statement.

Tom Kyte - Mon, 2016-11-21 17:06
Hello, Below Merge statement is giving internal error why? whats wrong with the code? what is the issue with rowid here? [If I use ID instead of rowid, it is giving valid error(unable to get stable set of rows)] ---Error: merge into t1 ...
Categories: DBA Blogs

Examining a new database

Tom Kyte - Mon, 2016-11-21 17:06
Every now and then, a new application with Oracle database comes to us. The manual is usually only end-user orientated. Seldom we get cubes, packages or frameworks for Cognos. A full database description is even more rare. What would be the fastest,...
Categories: DBA Blogs

Apex 5 get value from external?

Tom Kyte - Mon, 2016-11-21 17:06
Good Day, I have a Apex application I wrote where a form is completed, submit is pressed and a process kicks of a perl script as external procedure. The form requests IP Address and SNMP Community string only. What I want to achieve is to get Apex...
Categories: DBA Blogs

Error when restoring DB via RMAN

Tom Kyte - Mon, 2016-11-21 17:06
Hi Tom, we were making DB move procedure. NOTE: Source DB - uses ASM architecture. Target DB - will use filesystem. Backup of DB via RMAN (Linux OS, machine1) Restore of DB via RMAN (Linux OS, machine2) 1) backup was made RMAN> backup ...
Categories: DBA Blogs

Using Types in Read Only databases results in error when invoked for the first time

Tom Kyte - Mon, 2016-11-21 17:06
Following is a query that results in an error -- "ORA-16000: database or pluggable database open for read-only access", when invoked for the 1st time. But subsequent calls to the query are successful. The query runs successfully as long as its in t...
Categories: DBA Blogs

ORA-01555 caused by SQL statement below

Tom Kyte - Mon, 2016-11-21 17:06
Hi Tom, Sometimes we get ORA errors in alert file with message as: .... ORA-01555 caused by SQL statement below (SQL ID: gc8312bb07hav, Query Duration=11848 sec, SCN: 0x0000.35f6a778): WITH CORETABLE( DATAID, MAJOR, MINOR) AS ( SELEC...
Categories: DBA Blogs

Version Control for PL/SQL webinar now at 376 signups!

Gerger Consulting - Mon, 2016-11-21 13:59
Many thanks to 376 people who have registered already!

We are hosting a free webinar to talk about how to manage PL/SQL code bases. Attend and learn how you can use Gitora, our new product that links Oracle Database to Git, to manage your PL/SQL source code.

Register at this link.

Categories: Development

December 7: G&J Pepsi-Cola Bottlers, Inc—Oracle HCM Cloud Customer Forum

Linda Fishman Hoyle - Mon, 2016-11-21 13:35

Join us for an Oracle HCM Cloud Customer Forum call on Wednesday, December 7, 2016, at 9:00 a.m. PT.

Christina Walker, Executive Vice President of Human Resources at G&J Pepsi-Cola Bottlers, will discuss the company’s journey to the HCM Cloud. G&J Pepsi was dealing with disparate systems, paper-based processes, manual data entry, inaccurate payroll calculations, and lack of visibility across its entire organization.

Register now to attend the live Forum and learn more about G&J Pepsi-Cola Bottlers’ experience with Oracle HCM Cloud.

12 Great Tips on How To Be More Professional At Work

Complete IT Professional - Mon, 2016-11-21 13:00
Professionalism in the IT world is desirable. Some people have it, some don’t. The ones that do have it, the ones that are professional, are treated with more respect and are usually better at their jobs. Below, I share five tips that you can use to be more professional in your workplace. Dress Code Wherever […]
Categories: Development

Creating Simple Component Using HTML Templates

WebCenter Team - Mon, 2016-11-21 09:07

Authored by: Igor Polyakov, Senior Principal Product Manager, Oracle

In my previous post “Building a Simple H1 Component with Settings Pane” you learned how to develop simple H1 Component for Oracle Sites Cloud Service (SCS). In this tutorial, I will show you how to create SCS Component that HTML and CS together with tempting language to render view. In this example I will use Mustache JS templates. The Component also provides a Settings panel to enable edit content in the HTML that you wish to make editable in the Site Builder by other users.

Step 1: Create the HTML Component
You will start by creating new Local Component in SCS Components catalog which is a starting point for creating any new component. Repeat the steps described in my previous post, but this time call your new component “HTML Component”.

Once you've followed the steps in the tutorial, you'll add the new HTML Component to a page in your test site. In the Site Builder, you should see:

In Edit mode:

In Preview mode:

To read more, please click here for access to the entire tutorial.

Oracle Buys Dyn

Oracle Press Releases - Mon, 2016-11-21 06:00
Press Release
Oracle Buys Dyn Extends the World’s Most Comprehensive Cloud Computing Platform with the Leading Cloud-based Internet Performance and Domain Name System (DNS) Solution

Redwood Shores, Calif.—Nov 21, 2016

Oracle today announced that it has signed an agreement to acquire Dyn, the leading cloud-based Internet Performance and DNS provider that monitors, controls, and optimizes Internet applications and cloud services to deliver faster access, reduced page load times, and higher end-user satisfaction.

Dyn’s solution is powered by a global network that drives 40 billion traffic optimization decisions daily for more than 3,500 enterprise customers, including preeminent digital brands such as Netflix, Twitter, Pfizer and CNBC. Adding Dyn’s best-in-class DNS solution extends the Oracle cloud computing platform and provides enterprise customers with a one-stop shop for Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS).

“Oracle already offers enterprise-class IaaS and PaaS for companies building and running Internet applications and cloud services,” said Thomas Kurian, President, Product Development, Oracle. “Dyn’s immensely scalable and global DNS is a critical core component and a natural extension to our cloud computing platform.”

“Oracle cloud customers will have unique access to Internet performance information that will help them optimize infrastructure costs, maximize application and website-driven revenue, and manage risk,” said Kyle York, Chief Strategy Officer, Dyn. “We are excited to join Oracle and bring even more value to our customers as part of Oracle’s cloud computing platform.”

More information about this announcement is available at www.oracle.com/dyn.

Contact Info
Deborah Hellinger
Oracle Corporation
Ken Bond
Oracle Investor Relations
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.


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

Product Roadmap

Oracle is currently reviewing the existing Dyn product roadmap and will be providing guidance to customers in accordance with Oracle’s standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle’s review of Dyn’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by Dyn or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements

This document contains certain forward-looking statements about Oracle and Dyn, including statements that involve risks and uncertainties concerning Oracle’s proposed acquisition of Dyn, anticipated customer benefits and general business outlook. When used in this document, the words "anticipates", "can", "will", "look forward to", "expected" and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or Dyn, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business may deteriorate and/or Oracle or Dyn may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or Dyn. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor Dyn is under any duty to update any of the information in this document.

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. 

Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

Oracle DELETE SQL Statement – The Complete Guide

Complete IT Professional - Mon, 2016-11-21 05:00
The DELETE SQL statement allows you to delete records from a table. I’ll explain more about the Oracle DELETE SQL statement in this article. What Is The Oracle DELETE SQL Statement? The Oracle DELETE SQL statement is a statement you can run to delete records from a table. There are statements to INSERT and UPDATE […]
Categories: Development

Links for 2016-11-20 [del.icio.us]

Categories: DBA Blogs

DML operations inside Compound triggers

Tom Kyte - Sun, 2016-11-20 22:46
As suggested I use COMPOUND TRIGGERS, Please find requirements & the below code below. 1. IF DELETING, any record created in USER_INFO table may not be deleted. Attempting to delete a record from this table is captured, create an entry in AUD...
Categories: DBA Blogs


Tom Kyte - Sun, 2016-11-20 22:46
Under what conditions would an ORACLE.SECURITY.TS.ENCRYPTION.xxxxx not be present in the wallet after enabling tablespace encryption? All previous attempts to enable TDE on other databases resulted in the following entries - the most recent did not i...
Categories: DBA Blogs

RMAN Bakcup failure

Tom Kyte - Sun, 2016-11-20 22:46
Hi Tom, we are facing problem to rman backup failure or archive backup failure. This is not daily failure. but need to understand the exact problem and solution. rman failure with following error: channel ORA_DISK_1: starting piece 1 at 18-...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator