ORA-01735: invalid ALTER TABLE option - Toad

try this:

ALTER TABLE CALCULATE
  ADD (CAL_METHOD VARCHAR2(50));

ALTER TABLE CALCULATE
  ADD (
 REMARKS VARCHAR2(500));

Your SQL is correct but the problem is TOAD restrict Statements and Scripts for each button. I assume the cause of the error is you are trying to run ALTER TABLE command using Execute Statement or F9 key. First of all, let's see what is different between Statement and Script

Execute Statement will give you a list of all the results in a sortable table. It will also only run the statement under the cursor (or highlighted). You will be prompted for bind variables when you run the statement (any placeholder: in front of it).

E.g.

select * from customers where customer_id = :id

will prompt for a value for id

Execute Script will execute all statements in the worksheet, and give a text readout of the results. It will not prompt you for the values of bind variables.

https://stackoverflow.com/a/479443/2940265

As you can understand ALTER TABLE returns only a text output. So you have to use Execute as Script or F5

Execute As Script Toad


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


I am using TOAD 11.0.6 and Oracle database version is 11gR2

See the below scripts which I am able to execute by F5 or by clicking the green arrow as shown in the enclosed screenshot

CREATE TABLE calculate (col NUMBER);

ALTER TABLE calculate
  ADD (cal_method VARCHAR2(50), remarks VARCHAR2(500));

SELECT * FROM calculate;

enter image description here

Tags:

Sql

Oracle

Toad