(Hemant K Chitale) I am now introducing some code samples in my blog. I won’t restrict myself to SQL but will also include PL/SQL (C ? Bourne/Korn Shell ? what else ?)
Tag: Oracle
Intro to Database Security – Part 2
(amitzil) In part 1 I talked about introduction to the security world and important terms. In this post I will introduce database security, what it means and what we can do about it.
Oracle JET Executing Dynamic ADF BC REST URL
(Andrejus Baranovskis) I’m going to explain how to call ADF BC REST service from JET API and how to control parameters passed through to REST URL
Synchronous Dynamic Actions in APEX 5.1
(Scott Wesley) If you’ve ever used a PL/SQL dynamic action with the default ‘wait for result’, you would have seen the following warning if you have the browser console open.
Examining predicted Clusters and Cluster details using SQL
(Brendan Tierney) In a previous blog post I gave some details of how you can examine some of the details behind a prediction made using a classification model.
Data Guard ‘CORRUPTION DETECTED: In redo blocks starting at block…’ issues
(Garth) I’ve been pulling my hair out over this one, so hopefully this post will prove useful to someone else experiencing similar problems with Data Guard traffic.
Returning The Actual DOP When Using Oracle’s Auto Degree Of Parallelism
(David Fitzjarrell) Using Oracle’s Auto Degree of Parallelism (Auto DOP) can improve performance if used judiciously, but unless you’re running autotrace at the time the query or statement runs you probably won’t know what degree Oracle decided to set. There are ways around this; let’s look at them
plsql datapump and excluding both job types
(Dbaharrison) Today I’ve spent a few hours dealing with creating an updated version of our streams recreation script. Streams is both wonderful and frustrating at the same time, I have somewhat of a love-hate relationship with it. After a successful day improving the script I thought I’d share one o
EM13c, Configuration Management and Comparing Targets
(Kellyn Pot’Vin-Gorman) How many times have you had maintenance or a release complete and everyone is sure that everything’s been put back the way it should have been, all t’s crossed, all i’s dotted and then you release it to the customers only to find out that NOPE, something was forgotten in the
Loading SQL*Plus HELP into the Database
(Hemant K Chitale) Oracle provides scripts to load the HELP command for SQL*Plus.
