Skip to content

Oracle Findings

  • Home

Day: August 7, 2016

» 2016 » August » 07

Implementing partial indexes on Oracle 11g

7 Aug 2016 Roberto Rigliaco

Similarly as discussed in this post explaining how to enable partial unique indexes on Oracle 12c, it is possible to use partial indexes on Oracle 11g (tested on 11.2.0.2.0) as well! As you know this feature has been introduced with the Oracle release 12c but using the same method explained in the previous post we can apply it to 11g.

Read More…

Leave a comment Database

Recent Posts

  • DB Unit Testing with Oracle SQL Developer: a serious and complete set up guide
  • Granting INDEX privilege gives access to your data
  • Switch Pl/Sql logging on/off for specific sessions
  • DB Unit Testing with SQL Developer: REF CURSORs still having problems [UPDATE!]
  • How to easily test a complex REF CURSOR

Recent Comments

  • M on DB Unit Testing with Oracle SQL Developer: a serious and complete set up guide
  • Dipak Patil on DB Unit Testing with SQL Developer: REF CURSORs still having problems [UPDATE!]
  • Roberto Rigliaco on DB Unit Testing with SQL Developer: REF CURSORs still having problems [UPDATE!]
  • Dipak Patil on DB Unit Testing with SQL Developer: REF CURSORs still having problems [UPDATE!]
  • Roberto Rigliaco on How to easily test a complex REF CURSOR

Archives

  • September 2022
  • October 2020
  • May 2018
  • September 2017
  • July 2017
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016

Categories

  • Database
  • Sql-Pl/Sql
  • Welcome