Re: Eliminate NAME_CONST to Allow Index Usage
I should have posted that I solved this earlier today by doing just that:
SET current_first_name = 'Joe';
SELECT id INTO current_id FROM names WHERE first_name = CONVERT(current_first_name USING ascii) COLLATE ascii_general_ci LIMIT 1;
Subject
Views
Written By
Posted
10265
April 17, 2013 09:26AM
3633
April 17, 2013 04:55PM
Re: Eliminate NAME_CONST to Allow Index Usage
4097
April 17, 2013 04:59PM
3136
April 18, 2013 08:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.