Category Archives: Uncategorized

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 Database Developer Choice Awards, SQL Category Winner!!!

Hi Everyone,  I nominated for Oracle Database Developement Choice Awards from Turkey approximately five months ago. Then I learnt to be a finalist from Oracle Technology Network on 15th October. Then voting started to determine winners for each category. I … Continue reading

Posted in Uncategorized | Tagged , , , , , | 1 Comment

Oracle Database Developer Choice Awards

Hi Everyone, Today, I recieved very good news from Oracle, USA. Both I want to share this news  and I expect your support for my achivements. I had the final list in “The SQL developer of the 2015” prize which … Continue reading

Posted in Uncategorized | 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

PL/SQL Native Compilation

Hi Everyone, In this article I’ll discuss Oracle’s native compilation feature which will increase our query performance in PL/SQL. I hope this will be a helpful article in terms awareness. Oracle, runs a PL/SQL command in interpreted mode as default … Continue reading

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

Performance Enhancement in Distributed Queries (DRIVING_SITE HINT)

Hi Everyone, In this article, I’ll discuss “driving_site” hint which is about enhancement of distributed query performance and its usage. I hope this will be a useful article in terms of awareness. In IT world, we usually do processes on … Continue reading

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

Oracle After Logon Trigger

Hi everyone, In this article, I will give an information about one of the Oracle schema security method that increase your schema security level. With this method, based on IP address of users who have logged on the schema or,  … Continue reading

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