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.
In TOAD I suppose, you need to execute it as a script (press F5) rather that running it as a statement.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With