Oracle Pivot with value containing &

Asked Jul 21 '19 at 14:23

Active Jul 21 '19 at 14:25

Viewed 33 times

My query is:

select * from (
select 
aa_id, abc_metric, abc_value from TABLE1)
PIVOT(
min(abc_value)
FOR abc_metric IN ('Mode (numbers & dates)')
);

In abc_metric, I have a value called as Mode (numbers & dates) but SQL developer is asking me value of dates.

How can I make the query work?

edited Jul 21 '19 at 14:25

asked Jul 21 '19 at 14:23

dang

Did you try escaping it with a backslash? – Gordon Linoff Jul 21 '19 at 14:25
No, how to do it? – dang Jul 21 '19 at 14:25
2

IF yoy run SET DEFINE OFF before your query SQL Developer will stop thinking & indicates a substitution varaiable and run your query as expected. Run SET DEFINE ON to turn the default behaviour back on. – OTTA Jul 21 '19 at 14:31

0 Answers0