Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query on where condition - upper(rtrim(column)) = ?

663506Oct 14 2008 — edited Oct 14 2008
Hi,

I have a table StudentGrades. This table has an index on the column "grade" of type varchar2.
The values of "grade" column contain string values like: 'A', 'a', 'A ', 'a ', 'A ', i.e. mixed cases and containing white spaces at times.

If I run a query below, will it use the index on grade?

select * from StudentGrades where upper(rtrim(grade)) = ?

where ? is an input parameter from the program and the value has been trimmed and converted to uppercase.

Thanks,
Jason

Comments

Vishal Gupta

Anyone seen this error?

Hi VishalGupta,

1/Which version of SQLDeveloper are you using the recent 4.0 EA or the Production 3.2.2?

2/I have not seen the error you mention (unless there is a typing error in the command).

3/There was a problem with 3.2.2 - need to set the PATH otherwise SQLDeveloper may get confused with another version of SQLDeveloper stored in /opt and referenced elsewhere in the PATH ('which sqldeveloper' to see where it is)

4/I had to use a full path for the file name i.e. /tmp/vg.html on my test case (which did not reproduce your issue) (*)

5/'force_print' in html script output is a bug

(*)export PATH=`pwd`:$PATH ; bash ./sdcli reports generate -report z -db DB_NAME -file /tmp/zzq4.html

Oracle SQL Developer

Copyright (c) 1997, 2013, Oracle and/or its affiliates. All rights reserved.

Java asserts are enabled!

Success!

-Turloch

SQLDeveloper Team

Vishal Gupta

Turloch,

Thanks for the reply.  I was using SQL Developer 4.0 EA1. I noticed that my problem was because of the space in the report name. See following link.

SQLDev4 - sdcli - space in report name (Linux/Mac)

Regards,

Vishal Gupta

http://blog.vishalgupta.com

Barry Mcgillin-Oracle
Answer

Vishal,

Youre right. I just fixed this under bug 17221719

B

Marked as Answer by Vishal Gupta · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 11 2008
Added on Oct 14 2008
4 comments
204 views