Subscribe: Eddie Awad's Blog
Added By: Feedage Forager Feedage Grade B rated
Language: English
awad blog  cloud service  cloud  database  file  json  new  openworld  oracle database  oracle openworld  oracle  sql  utl file  utl   
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Eddie Awad's Blog

Eddie Awad's Blog

News, views, tips and tricks on Oracle and other fun stuff

Last Build Date: Mon, 06 Mar 2017 03:54:12 +0000


Oracle Database 12c: Interactive Quick Reference12c DB Architecture

Sat, 13 Jun 2015 20:33:45 +0000

★ © Eddie Awad's Blog, 2015. | Permalink | Add a comment | Topic: Oracle | Tags: 12c, reference

Media Files:

★ Oracle to Unveil Database Cloud Service 2.0 at OpenWorldOracle Database Cloud Service

Sun, 21 Sep 2014 23:22:53 +0000

Michael Hickins: At Oracle OpenWorld 2014, the company will roll out its new Database Cloud Service — a new multi-tenant database-as-a-service offering that will let customers migrate their existing apps and databases to the cloud “with the push of a button,” said Ellison. Data will be compressed ten to one and encrypted for secure and efficient transfer […]

Media Files:

★ How BIG is Oracle OpenWorld?Oracle OpenWorld

Sat, 23 Aug 2014 21:19:12 +0000

Here is how big it was in 2013. Compare it to its size in 2012. It is safe to assume that it will be bigger in 2014! I will attend this year’s event by invitation from the Oracle ACE Program. Prior to the start of the conference, I will be attending a two day product […]

Media Files:

★ Database as a Storage (DBaaS) vs. Thick Database

Mon, 18 Aug 2014 14:30:02 +0000

A recent addition to my Oracle PL/SQL library is the book Oracle PL/SQL Performance Tuning Tips & Techniques by Michael Rosenblum and Dr. Paul Dorsey. I agree with Steven Feuerstein’s review that “if you write PL/SQL or are responsible for tuning the PL/SQL code written by someone else, this book will give you a broader, […]

Avoid UTL_FILE_DIR Security Weakness – Use Oracle Directories Instead

Mon, 04 Aug 2014 13:00:08 +0000

Integrigy: The UTL_FILE database package is used to read from and write to operating system directories and files. By default, PUBLIC is granted execute permission on UTL_FILE. Therefore, any database account may read from and write to files in the directories specified in the UTL_FILE_DIR database initialization parameter […] Security considerations with UTL_FILE can be mitigated […]

Are You Using BULK COLLECT and FORALL for Bulk Processing Yet?

Sat, 02 Aug 2014 18:01:02 +0000

Steven Feuerstein was dismayed when he found in a PL/SQL procedure a cursor FOR loop that contained an INSERT and an UPDATE statements. That is a classic anti-pattern, a general pattern of coding that should be avoided. It should be avoided because the inserts and updates are changing the tables on a row-by-row basis, which […]

Media Files:

★ Native JSON Support in Oracle Database 12cjson

Thu, 10 Oct 2013 12:00:49 +0000

If you want JSON support in your Oracle database today you can use PL/JSON, an open source JSON parser written in PL/SQL. However, as Marco reported from Oracle OpenWorld, native JSON support may be an upcoming new feature in Oracle Database 12c. This new feature allows the storage of JSON documents in table columns with […]

Media Files:

★ Now Available for Download: Presentations from Oracle OpenWorld 2013Oracle OpenWorld

Tue, 08 Oct 2013 12:00:21 +0000

Head to the Content Catalog and start downloading your favorite sessions. No registration needed. Sessions will be available for download until March 2014. Note that some presenters chose not to make their sessions available. Via the Oracle OpenWorld Blog. © Eddie Awad's Blog, 2013. | Permalink | 2 comments | Topic: Oracle | Tags: oow

Media Files:

★ Oracle Database 12c In-Memory Option Explained12c

Mon, 07 Oct 2013 12:00:59 +0000

Jonathan Lewis explains the recently announced Oracle Database 12c in-memory option: The in-memory component duplicates data (specified tables – perhaps with a restriction to a subset of columns) in columnar format in a dedicated area of the SGA. The data is kept up to date in real time, but Oracle doesn’t use undo or redo […]

Media Files:

★ Oracle Database 12c Bookmarklet, Search Plugin and New Features12c

Mon, 08 Jul 2013 13:30:43 +0000

The blogosphere continues its buzz about Oracle Database 12c and what feels like an unlimited supply of new features in this latest cloud enabled release. Speaking of new features, here is what’s new in Oracle Database, SQL and PL/SQL from 9iR1 until 12cR1. With a new release comes new documentation and handy tools to make […]

Media Files: