Toad World® Forums

select * from dual; ;


#1

This statement:

select * from dual;;

Causes an “Invalid Character” error.

Note the two semicolons.

Jet


#2

sqlplus raises error too, so I think sqlnav should raise this error.
But, 5.x alows that synatx…


#3

Yeah, I guess you’re right.

Of course, sqlplus isn’t well known for its syntax. :wink:

That being said, I guess it does do it there so it’s not a big deal. I’m just used to 5.5 not worrying about such things!

Jet


#4

Roman has fixed this problem in our internal build.
Cheers
Gwen


#5

1:30:09 PM ORA-00920: invalid relational operator

  SELECT 'N'
  FROM  LCA_SPECIALS_APPROVAL
  WHERE (customer like to_number(lpad(to_char(5),2,'0')||
         lpad(to_char(101911),6,'0')||
         lpad(to_char(1),3,'0'))
  OR
         customer like to_number(lpad(to_char(5),2,'0')||
         lpad(to_char(101911),6,'0')||
         lpad(to_char(0),3,'0')))
  AND   model_name like 'XXXXXXX'
  AND   node_value like 'XXX'
  AND   type_flag = 'I'
  AND   ROWNUM < 2;  -- Added Row num if approved Current div and div 0 only want 1 apporval returned DJ 08/24/2006

This is more than likely a true statement, but if you remove the Comment after the ROWNUM < 2 you do not get the error, you get invalid character in Sqlplus and it runs in 5.x. I guess the biggest problem is that the ND in the last AND is what turns red. I tried to recreate this using other tables, but I can not, so I do not know what part of the select is causing the problem.

This also may be fixed, it may be related to the ;; in this thread…


#6

Hi Dale,

This bug is different from the ;; so we’re investigating it. We will let you know if it’s fixed.