If you are working with JDeveloper 12c (12.1.2), you will probably have experienced quite a few crashes – I had several during my the live demos in my presentations at the UKOUG Tech 2013 conference in Manchester this week.
A few things that help:
- Increase memory (google “JDeveloper (more...)
Since PL/SQL now is closely integrated into SQL, we hence can happily state
email@example.com > with function bestpractice return varchar2
4 return 'Do not use PL/SQL when it can be done with SQL alone !';
5 end bestpractice;
Today at the UKOUG I showed a new plug-in for JDeveloper 12c together with Wilfred
, the ADF EMG Audit Rules. You can find it through JDevelopers Check for Updates in the Help menu. This plug-in is a starting point for creating rules out of the code guidelines document you (more...)
Since JDeveloper 12c it’s possible to uninstall extension from your JDeveloper, without deleting jar files and cache directories manually. However, the feature is a little bit hidden, it’s not in your preferences, but in the feature section. You get there through the Tools menu.
Here you can manage your features, (more...)
Last week I did a webinar on 12c Adaptive Optimization. The talk was recorded. The slides are here: 12c Adaptive Optimization V2 PDF. The recording can be found here: 12c Adaptive Optimization Recording. There were a number of follow up questions and emails so I thought I’d summarize here. Since (more...)
I just uploaded my DOAG 2013 presentation “Best of Oracle Security 2013“.
This presentation shows how to bypass Oracle Data Redaction, become DBA using CREATE ANY INDEX, Hide information from Oracle Auding using VPD and more…
SQL> select * from scott.credit_card where 1=ordsys.ord_dicom.getmappingxpath((card_id),user,user);
12 and 13 December 2013 AMIS will host a two day masterclas with Oracle PL/SQL guru Steven Feuersten.
The Design Pattern movement reminds us that most of the code we write is similar to something written last week – or maybe even an hour ago. Once you identify a (more...)
Oracle 12c introduced the ability to make user specified columns “Invisible” such that they’re invisible by default and have to be explicitly referenced to be accessed. So a simple SELECT * won’t display columns defined as invisible, but they will be displayed if explicitly referenced in the SELECT column list. (more...)
I’ve been doing a lot of installs lately. With Oracle releasing a lot of 12c items, there have been a lot of install opportunities. Recently, I’ve done a project where I had the chance to install Oracle Golden Gate 12c. The 12c version of Golden Gate introduced (more...)
-- it's just for fun:
SQL> alter system set "_scalar_type_lob_storage_threshold"=32000;
SQL> create table t_varchar32000(v varchar2(32000 byte));
SQL> insert into t_varchar32000
2 select rpad(rownum,31999,'x' ) || 'y' from dual connect by level<=1000;
1000 rows created.
SQL> create index ix_t_varchar32000 on t_varchar32000(v) tablespace users;
Oracle 12c has increased the maximum length of character-based columns to 32K bytes – don’t get too excited, they’re stored out of lines (so similar in cost to LOBs) and need some modification to the parameter file and data dictionary (starting the database in upgrade mode) before you can use (more...)
Finally, at long long last, I have a spare 30 minutes in my life to complete this blog entry !! As discussed previously, Oracle has extended the maximum length of varchar2, nvarchar and raw columns to 32K, but this comes with some challenges when it comes to indexing such columns due (more...)
The current release of Oracle Golden Gate brings a lot of new and exciting opportunities to use when setting up replication. One of the new things, is that it can be installed along side a 11gR2 database, specifically with a 188.8.131.52 database. With the release (more...)
I wrote a note about the 12c “In-Memory” option some time ago on the OTN Database forum and thought I’d posted a link to it from the blog. If I have I can’t find it now so, to avoid losing it, here’s a copy of the comments I made:
Juan Loaiza’s (more...)
Here are two interesting enhancements in Oracle database 12c PL/SQL. PL/SQL subprogram defined using WITH clause of a subquery – Oracle database 12c allows PL/SQL declaration section in the WITH clause. One can define PL/SQL function or procedure into a WITH clause. Functions declared in the PL/SQL declaration section can (more...)
When I read the list of 12c new features the one that interested me immediately was the ability to be able to recover a table from an RMAN backup. This seemed to be quite challenging as RMAN is an image copy of blocks and a table is normally copied using (more...)
Back in June, Oracle released Oracle Database 12c and everyone went nuts trying to download and start documenting the many new features. One of the items within the 12c (database) release that I was curious about was how is Oracle Golden Gate going to work with multi-tenant databases. (more...)
OPatch requirement for October 2013:
- OPatch 184.108.40.206.1 for Database PSU 220.127.116.11.1
- OPatch 18.104.22.168.2 for GI PSU (more...)
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 (more...)