Query Help - String in where clause has & character

sql oracle plsql toad
x.509 picture x.509 · Feb 16, 2011 · Viewed 23.5k times · Source

I am running an SQL (Oracle) statement like that

select * from table 
where table_id in ('265&310', '266&320')

While running through TOAD, it consider & as some variable placeholder and it asks for its value. If it was for 1-2 place holders then I could have set it in TOAD but the in clause has like 200 of strings.

How to put this query?

I want to export the DATASET as SQL INSERT statement, so I can't use this in SQL-PLUS.

Answer

Randy picture Randy · Feb 16, 2011 
SET DEFINE OFF;

Will work to turn the prompting for variable off..

or 

SET ESCAPE ON;
SELECT 'blah \& blah' AS DES FROM DUAL;

Related questions

Variables in TOAD scripts

I have a SQL script that is being executed in TOAD. Currently, I have it laid out with just statement after statement, thusly: select such-and-such from somewhere; delete other-thing from somewhere-else; And so on. Some of the where clauses end …

Read More
Passing varchar2 parameter to plsql procedure from the Select statement

Executing the following statement in Oracle Toad exec plsql_procedure(select 'somestring' from dual); trhows the following exception: ORA-06550: line 1, column 33: PLS-00103: Encountered the symbol "SELECT" when expecting one of the following: ( ) - + case mod new not null Procedure takes …

Read More
How to set all column from null to not null in table in oracle

I have 1 table having 40 columns. Out of 40 columns only 5 columns are NOT NULL and rest of the columns are set as NULL. How can i set all NULL column to NOT NULL in one time or in TOAD. Is there …

Read More