II 9083671 11.2.0.2, 12.1.0.1 Case insensitive NLS settings affect object name resolution in the dictionary – 9074534 11.2.0.3, 12.1.0.1 Wrong results from XQuery when pathsubsetting XMLindex is on the column
(1) If thesystem or database is case-sensitive, Oracle GoldenGate supports the case sensitivityof database names, owner and schema names, object names, column names, and usernames. (2) If thesystem or database is case-insensitive (or is configured forcase-insensitivity), Oracle GoldenGate c...
II 9083671 11.2.0.2, 12.1.0.1 Case insensitive NLS settings affect object name resolution in the dictionary – 9074534 11.2.0.3, 12.1.0.1 Wrong results from XQuery when pathsubsetting XMLindex is on the column – 9074000 11.2.0.2, 12.1.0.1 Wrong results using ROWID literals over database link...
So, even if your index is case-insensitive, the feedback you get depends on the case of the query -- the feedback for "oracle" will not be the same as the feedback for "Oracle". You can also give hfeedback multiple terms in a query string: ...
The names of mapped databases and tables are case-insensitive, which means no matter if the object name is uppercase or lowercase, it stays lowercase after the object is synchronized to the destination database. You are not advised to use the LOB type and extended character type (the length...
As of Oracle Database 10g, you can perform case- or accent-insensitive queries; these queries provide another way to solve this problem. This capability becomes even more valuable when you consider that you can create your own functions in an Oracle Database. You can create a very sophisticate...
CASE_INSENSITIVE_SEARCH Emulate the same behavior of MSSQL with case insensitive search. If the value is citext it will use the citext data type instead of char/varchar/text in tables DDL (Ora2Pg will add a CHECK constraint for columns with a precision). Instead of citext you can also ...
releases of Oracle E-Business Suite, user passwords were treated as case insensitive. Now, Oracle E-Business Suite user passwords can optionally be treated as case sensitive, depending on the mode you choose. Case-sensitivity in passwords is controlled by the profile option Password Case Option. ...
CASE_INSENSITIVE_SEARCH Emulate the same behavior of MSSQL with case insensitive search. If the value is citext it will use the citext data type instead of char/varchar/text in tables DDL (Ora2Pg will add a CHECK constraint for columns with a precision). Instead of citext you can also ...
Password is case insensitive. A value of true means the connection should enlist and use the transaction attributes of the current system transaction. Specifies whether connection pooling should be enabled for this connection. A value of true means the connection will take part in connection pooling...