Blog: All Things Oracle

208 blogs updated: 80 min. ago
Oracle for Absolute Beginners: Users, Synonyms, Privileges, & Roles
I accidentally locked myself out of my house this evening, and so I had to climb up the wall like a burglar and clamber in through a bathroo...
01-03-2017 11:50:49 All Things Oracle Oracle
Getting started with Oracle Database 12c Multitenant Architecture
Oracle database, since its inception, has always used a very specific and unique architecture which served it very well. In earlier forms of...
22-02-2017 18:50:12 All Things Oracle Oracle
JSON For Absolute Beginners: Part 6 - Generating JSON post-12c Release 2
In this sixth and final installment in this introductory series on JSON I'd like to revisit the question of generating JSON from your Oracle...
22-02-2017 12:05:56 All Things Oracle Oracle
Oracle for Absolute Beginners: Data Types
All databases stand on a tripod of datatypes: strings, numbers and dates. And so I'd imagine that by Day 2 or so of dabbling with Oracle you...
15-02-2017 13:29:16 All Things Oracle Oracle
Policy-Managed Oracle RAC One Node Databases
Oracle RAC One Node, introduced in Oracle Database 11g Release 2 (, is a single instance of an Oracle RAC-enabled database running ...
09-02-2017 21:46:28 All Things Oracle Oracle
Oracle Partitioned Index Efficiency
Although it is generally true that rebuilding an index represents a waste of time and resources, there nevertheless exist situations where d...
09-02-2017 15:02:29 All Things Oracle Oracle
Understanding SQL Query Parsing: Part 4 – Understanding Bind Variable Peeking
In the 3rd part of this series, I introduced you to the concept of the bind variables. We also learned their importance in regard to cursors...
03-02-2017 12:30:33 All Things Oracle Oracle
Oracle for Absolute Beginners: Date, Timestamp and Interval
All databases stand on a tripod of datatypes: strings, numbers and dates. And though they might dress them in fancy clothing varchar2, clob,...
02-02-2017 18:04:26 All Things Oracle Oracle
Oracle for Absolute Beginners: Other SQL Functions
Here's a simple trick you can play on your friends. Ask them to pick a number from 1 to 10, and tell them you'll read their mind and magical...
30-01-2017 16:34:24 All Things Oracle Oracle
Duplicate Point-In-Time Recovered PDB Using Backup
At times, we might need to duplicate a production pluggable database to a Past Point in Time without disturbing the production database itse...
25-01-2017 17:36:00 All Things Oracle Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.