This discussion is archived
1 Reply Latest reply: Apr 2, 2013 1:53 AM by Hilary RSS

with clause query issue in oracle cloud script editor

875412 Newbie
Currently Being Moderated
When I am running this query in SQL Workshop > SQL Commands window then its working fine

with cte as (select * from emp)
select * from cte
where deptno = (select deptno from dept where loc = 'DALLAS')

but its give me error in SQL Workshop > Script Editor window

When I did copy & paste query from Script Editor window to notepad,
then I realize that its automatically adding hidden "?" question mark (as per below query)
how can I resolve this issue?
please guide me.

I have confirm that there is no any white space after 'DALLAS')
& another simple queries working fine in both windows.

with cte as (select * from emp)
select * from cte
where deptno = (select deptno from dept where loc = 'DALLAS')?

Edited by: Sanjay on 28 Mar, 2013 6:46 PM
  • 1. Re: with clause query issue in oracle cloud script editor
    Hilary Expert
    Currently Being Moderated
    Hi Sanjay,

    You have mentioned "+but its give me error in SQL Workshop > Script Editor window+" - are you referring to the SQL Workshop > SQL Scripts > Script Editor option, while editing a SQL script? If so, then I have been unable to reproduce the behaviour you have reported, and have not received any errors using your test query.

    To assist in identifying the cause of your problem, could you please outline the exact steps that you followed, leading up to the step where you receive an error?

    Regards,
    Hilary

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points