CODEWITHSUNDEEP
sqloracle-databaseplsqloracle-sqldeveloperplsqldeveloper
user3189320
user3189320

Reputation: 13

Dialog box appear

I'm using decode for my query but when every time I run my query, there's a two dialog box appeared and need to input some number in those dialog box before to see the result. What should I need to remove it?

Please help me.

Thank you.

Here's some of my query..

  SELECT (CODE_SALESROOM) POS_ID
   ,DECODE(CODE_SALESROOM, '60001', 'ABM SYSTEM'
                          ,'50001', 'Acenet Unlimited Business Computer'
                          ,'40002', 'RL My Phone - Robinsons Galleria') AS POS_NAME
  FROM OWNER_DWH.DC_SALESROOM
  WHERE CODE_SALESROOM NOT IN ('XAP', 'XNA', '10001')

Upvotes: 1

Views: 132

Answers (1)

Alex Poole
Alex Poole

Reputation: 191285

Sounds like you're being prompted for substitution variables, because part of your query has somethling like and col = 'AT&T' - the ampersand is interpreted as a variable by default, and you're prompted for a value for &T (or whataver your actual value is interpreted as).

You can add set define off to your script to stop it looking for, and prompting for, a value when that is not what you want.

(The links are for SQL*Plus documentation, but much of that applies to SQL Developer as well; the documentation for that is a bit sparser),

Upvotes: 3

Related Questions