(Scott Wesley) A relatively common on the forums is regarding the escaping of special characters in reports, but it seems the developer isn’t always sure what is actually happening and how to how to search for it.
Tag: Oracle
Oracle Database Cloud (DBaaS) Performance – Part 1 – CPU
(Randolf Geist) After having looked at the performance consistency provided by the Oracle Database Cloud offering in the previous series, I’ll focus here on the raw performance figures I’ve measured during my tests, starting with the CPU related performance findings.
APEX: Display the Page Alias on every page – without modifying the Template
(Alex Nuijten) Having a Page Alias shown on the page can make communication with your end users a little bit easier. Instead of directing them to the URL and asking them for the second value shown after the “f?p”, it is a little bit simpler to direct them to the location of the Page Alias, e.g. bott
When local partitions….aren’t
(connormcdonald) Let’s say I’ve got a partitioned table, and because New Year’s eve is coming around, I certainly don’t want to be called out at 12:01am because I forgot to add the required partition for the upcoming year.
Oracle LENGTH2, LENGTH4, LENGTHB, and LENGTHC Function with Examples
(Ben Brumm) In this article, we’ll look at the variations of the Oracle LENGTH function – LENGTH2, LENGTH4, LENGTHB, and LENGTHC.
Using Read Only Tables
(Zohar Elkayam) While visiting a customer, we had a conversation about the correct way to stop users from writing to code tables. The customer described his ancient logic: when he wanted to move table to a read only state, he removed the write (insert/update/delete) permissions from all of his users
ADF BC REST 12.2.1.2 Custom Method JDeveloper Workaround
(Andrejus Baranovskis) Some of you who would try to implement custom method with ADF BC REST may face JDeveloper 12.2.1.2 wizard issue. JDeveloper 12.2.1.2 wizard is refusing to register ADF BC REST custom method, but it works perfectly on ADF runtime.
A Guide to the Oracle TRUNCATE TABLE Statement
(Ben Brumm) The Oracle TRUNCATE TABLE statement is a useful statement for removing data in Oracle SQL. I’ll explain what the statement does and show you some examples in this article.
RMAN checksyntax function
(John Hallas) I was looking at the RMAN DEBUG options and came across the CHECKSYNTAX function which I had not used before.
Multi-table insert
(connormcdonald) An interesting question came through on AskTom recently. The requirement was to perform a single pass through a source table, and load the data into three target tables.