Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

ORA-01735: invalid ALTER TABLE option - Toad

Tags:

sql

oracle

toad

When i execute below SQL in Toad its throws "ORA-01735: invalid ALTER TABLE option".

ALTER TABLE CALCULATE
  ADD (CAL_METHOD VARCHAR2(50), REMARKS VARCHAR2(500));

But when execute in SQL Developer its running successful, Is there any issue with SQL / Toad. Please advice me.

like image 241
deadend Avatar asked Jun 13 '17 06:06

deadend


Video Answer


1 Answers

In TOAD I suppose, you need to execute it as a script (press F5) rather that running it as a statement.

like image 112
pritesh agrawal Avatar answered Oct 07 '22 01:10

pritesh agrawal