Searching on column which contains the document name and document name is in Lower case and Upper case. To find the document with document name the query would be:
Select d.document_name from document d where LOWER(d.document_name) like LOWER('%java%')
Select d.document_name from document d where UPPER(d.document_name) like UPPER('%java%')
Select d.document_name from document d where LOWER(d.document_name) like LOWER('%java%')
Select d.document_name from document d where UPPER(d.document_name) like UPPER('%java%')
No comments:
Post a Comment