(connormcdonald) I was patching my 12.1.0.2 home installation to the latest patchset today, and got the following error:

(Terry Munday) This blog describes how to generate a web service client and proxy that can be used to invoke Fusion web services. This example shows how to create a proxy to invoke the HCM WorkerService.

(Hemant K Chitale) Taking up the TEST_FBDA_PARTITIONED table, let’s look at a couple of Partition Maintenance operations.

(Scott Wesley) Consider a chart with a trend that might be quite jagged across data points (blue line).

(Hemant K Chitale) Revisiting the previous test case, but with a larger AVG_ROW_LEN

(Andrejus Baranovskis) Each time when data is changed and updated through ADF BC, before posting changes to DB, SQL query with FOR UPDATE NOWAIT is generated and executed.

(Martien van den Akker) A quick one. In the past I used to generate ddl based on queries, like the following. But I find myself to re-invent them again. So to have it saved for my offspring: here’s one on deleting obsolete columns as generated on importing an excel sheet in SQLDeveloper:

(connormcdonald) Are you stuck with a database that does not offer analytic SQL facilities ? Never mind, you can use the following trivial Smile query can determine the median salary from the EMP table

(Andrew Reid) This example, tested on Oracle 11, shows how you can define bind variables in SQL*Plus, assign values to them in PL/SQL then display those values afterwards back in SQL*Plus:

(Saurabh K. Gupta) Oracle Database 12c enables enhanced security for extproc by authenticating it against a user-supplied credential. This new feature allows the creation of a user credential and links it with a PL/SQL library object.