Oracle VM Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

A Difference Between SQL*Plus and SQL Developer

A third-party supplier delivered some SQL today but it did not work in SQL*Plus. We asked the supplier about this and it turned that the code had been tested in SQL Developer. The reason for the failure was as follows. If you end a line of SQL with a semi-colon then add a comment afterwards, SQL*Plus rejects it with an ORA-00911: 

Database popularity: Is Oracle still on top? [VIDEO]

Transcript 

Hi, welcome to RDX! While Oracle has often been regarded as the undisputed leader of database technology, other engines are growing more popular among database administrators.

Notifications just got a boost!

If you’ve been tuning in to Hot Off the Press, you’ll know about recent updates to the WordPress.com interface along with some fantastic technical upgrades. To continue the momentum, we’ve introduced more interactive and robust notifications throughout WordPress.com. (Coming soon to a Jetpack blog near you.) Keep an eye on the new interface and let us know what you think!

Evaluating Classification Results

When you are working on building classification models you will need some ways of measuring the effectiveness of each model that you will build. This measurement/evaluation is perform during the model build process. Typically the model build process consists of 2 steps (I'm assuming all data preparation etc has been completed:

Beatles, Beer and British Conferences – UKOUG TECH14 Wrap Up

In December I was excited to attend UKOUG in the UK. This was my first UKOUG and I didn’t really know what to expect. I landed in London at Heathrow of course and then took the train up to Liverpool. I had the option to fly into Manchester but I love train rides. Coming from the US […]

Rebuild table indexes lobs in oracle

Rebuilds are beneficial in some rare circumstances such as after a mass delete operation. The below method is safer and faster than export/import.

Oracle XFILES now on GitHub

The demonstration environment for Oracle XML DB called XFILES is now on GitHub. As stated…

IS flexes its hacking skills

The Islamic State in Iraq and the Levant has received much attention as of late, and not for nothing.

As the organization took a long time to prepare for its assault on Iraq, Syria, Israel, Lebanon and other states within the region that is considered the Levant, it's no surprise that the Islamic State group spent resources developing assets to be used in cyberwarfare.

Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch

Background

Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query the patch software installed in the Oracle Home programatically through SQL using the new DBMS_QOPATCH package.

Log Buffer #405, A Carnival of the Vanities for DBAs

This Log Buffer Edition rides on the wave of new ideas in the database realms. From Oracle technologies through MySQL to the SQL Server, things are piping hot.

Oracle:

The Call for Papers for the Rittman Mead BI Forum 2015 is currently open, with abstract submissions open to January 18th 2015.

view counter