Oracle Magazine, Nov/Dec 2017
Database Developer and DBA ETL ORACLE MAGAZINE NOVEMBER DECEMBER 2017 84 SQL CREATE TABLE CUSTOMER 2 ID INT 3 CUST_ NAME VARCHAR2 40 COLLATE BINARY_ AI 4 Table created SQL create index cust_ ix on customer cust_ name Index created After sample data is added to the table note the effect of BINARY_ AI A fourth row is retrieved and the third character in the customer name is a a with a breve SQL select from customer 2 where cust_ name ADAMS ID CUST_ NAME 37 ADAMS 237 Adams 447 adams 647 adăms CHECKING FOR SIDE EFFECTS The new collation feature allows for case insensitive queries without the need to add expressions to existing queries Digging into the details however reveals one
You must have JavaScript enabled to view digital editions.