Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
-- case insensitive searches using Oracle10g release 1 and lower:ALTER session SET NLS_COMP=ANSI;ALTER session SET NLS_SORT=GENERIC_BASELETTER;SELECT*FROM customer WHERE client_city ='San Antonio';-- Oracle10g's new method for case insensitive searches:
(NLSSORT( client_city,'NLS_SORT=BINARY_CI'));ALTER session SET nls_sort=binary_ci;SELECT*FROM customer WHERE client_city ='San Antonio'
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.