Oracle DB: How can I write query ignoring case?

by 
Select * from table where upper(table.name) like upper('IgNoreCaSe');

Alternatively, substitute lower for upper.

More Related Contents:

  1. How do I reset a sequence in Oracle?
  2. ORA-00904: invalid identifier
  3. How can I get column names from a table in Oracle?
  4. Is there any boolean type in Oracle databases?
  5. SQL ROWNUM how to return rows between a specific range
  6. MySQL equivalent of DECODE function in Oracle
  7. SQL recursive query on self referencing table (Oracle)
  8. create table with sequence.nextval in oracle [duplicate]
  9. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  10. Deferrable Constraints in SQL Server
  11. Oracle (Old?) Joins – A tool/script for conversion?
  12. How to populate calendar table in Oracle?
  13. What is it exactly a BLOB in a DBMS context
  14. What can cause an Oracle ROWID to change?
  15. Does ‘Select’ always order by primary key?
  16. Is there a version control system for database structure changes?
  17. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  18. How do I list all the columns in a table?
  19. How do you interpret a query’s explain plan?
  20. How do NULL values affect performance in a database search?
  21. Query a Table’s Foreign Key relationships
  22. Oracle , != , ^= operators
  23. SQL Server equivalent of WM_CONCAT function [duplicate]
  24. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?
  25. SQL Query to concatenate column values from multiple rows in Oracle
  26. Oracle Differences between NVL and Coalesce
  27. PLSQL Insert into with subquery and returning clause
  28. ORACLE SQL:Get all integers between two numbers
  29. How can I solve ORA-00911: invalid character error?
  30. What is difference between foreign key and reference key?

Leave a Comment