Tag Archives: Oracle 12c New Features

OTN Appreciation Day : Adding Invisible Column

Hi everyone, First of all, I would like to express my graditude for OTN and Tim Hall who is the father of idea. This is amazing. OTN is a very powerfull community and I am very proud to be part … Continue reading

Posted in Oracle, Root, Uncategorized | Tagged , , , | Leave a comment

Oracle SQL: LATERAL, CROSS APPLY, OUTER APPLY

Hi everyone, In this article I’ll speak about improvements that were made by Oracle 12c and SQL, such as the phrases LATERAL, CROSS APPLY and OUTER APPLY. I hope this will be a helpful article in terms of awareness. When … Continue reading

Posted in Oracle, Root | Tagged , , , , , | Leave a comment

Oracle Temporal Validity

Hi everyone, In this article I will mention the temporal validity subject which is a new feature that has come with Oracle 12c R1. I hope that will be a beneficial article in terms of awareness. Temporal validity offers us … Continue reading

Posted in Oracle, Root | Tagged , , , | Leave a comment

Oracle DB Identity Columns

In this article I’ll talk about identity column option, which is one of the new features that have come with Oracle DB 12c R1. I hope this will be a helpful article in terms of awareness. It’s always been the … Continue reading

Posted in Oracle, Root | Tagged , , , , , | Leave a comment

Oracle 12c JSON Support

Hi everyone, In this article I’ll mention JSON support which has come with Oracle DB 12c 12.1.0.2 I hope this will be a useful article in terms of awareness. With its new version, Oracle Oracle 12c 12.1.0.2 is now capable … Continue reading

Posted in Uncategorized | Tagged , , , , , , | Leave a comment

Improving Function Performance with “PRAGMA UDF”

Hi Everyone, In this article, I’ll discuss the “PRAGMA UDF” phrase that has come with the Oracle 12c, and its effect on performance. I hope this will be a helpful text in means of awareness. With the Oracle’s 12c version … Continue reading

Posted in Oracle, Root | Tagged , , , , | Leave a comment

Oracle Database In-Memory Option

Hi everyone, in this article I’ll explain In-Memory option, which has come with Oracle 12c DB. I hope this will be a helpful article in terms of awareness. As it’s known, Oracle DB saves data on the physical level and in … Continue reading

Posted in Oracle, Root | Tagged , , , , , , , , , | Leave a comment