(Ben) In this article, I’ll explain what the NEW_TIME function does and show you some examples.

(Patch72) Last year I did a presentation on table functions at KScope. One of the questions I got was: ‘If pipelined table functions provide their results faster, why would you want to use a normal table function?’ I couldn’t come up with the answer then, maybe you can help?

(connormcdonald) We had question in the OpenWorld panel about why queries on date columns are “always slow”. Well….they aren’t Smile but here’s a common cause of that misconception.

(John Hallas) Today an application team had a problem with a production system and they wanted the database restored to a point a couple of days ago. It is a configuration management system and they figured they could lose any changes . Their call.

(Jeff Smith) Someone said we should make the view source searchable, and that we should show any errors on a view.

(Dirk Nachbar) Within this blog post I will show you how to configure the Oracle Reports 12c jobStatusRepository against an Oracle Database.

(Uwe Hesse) You have done a failover to your Standby database so it becomes the new Primary. It may be possible to convert the old Primary into a Standby database now instead of having to do a time consuming duplicate again. The old Primary must have been running in flashback mode before the failove

(Ben) The Oracle NANVL function is useful when working with number values. Learn what it does and how to use it in this article.

(Biju) Approximate Query Processing appears to be a major feature of Oracle Database 12c Release 2 SQL. In 12cR1 patchset 2 (12.1.0.2), we saw one approximate query function appear – APPROX_COUNT_DISTINCT to use instead of COUNT(DISTINCT). In 12.2 there are several APPROX functions introduced:

(Uwe M. Küchler) Today I stumbled across a strange error when I tried to run orachk on a customer’s system: