ORA-01735: invalid ALTER TABLE parameter - Toad

Question

When I run my Torah " ORA-01735: invalid ALTER TABLE " throws under SQL in Toad .

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

But when the executable in SQL Developer runs successfully, is there a problem with SQL / Toad. Please advise me.

Answer 1

In TOAD, I suppose you need to execute it as a script (click F5), and not run it as an operator.

Answer 2

SQL , , TOAD . , ALTER TABLE Execute Statement F9. , , Statement Script

Execute Statement . ( ). ( : ).

.

select * from customers where customer_id = :id

id

Execute Script , . .

fooobar.com/questions/116073/...

, ALTER TABLE . Execute as Script F5

Answer 3

try the following:

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

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

Answer 4

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

See the scenarios below that I can execute with F5 or by clicking the green arrow as shown in the attached screenshot

CREATE TABLE calculate (col NUMBER);

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

SELECT * FROM calculate;

Answer 5

I end up dropping the column first, then adding back

ALTER TABLE  SITE_NUMBER DROP COLUMN CREATOR_ID;  
ALTER TABLE  SITE_NUMBER ADD (CREATOR_ID varchar2(12))