SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference in syntax between SQL Developer and TOAD

973721Nov 12 2012 — edited Nov 23 2012

Hello there,

Appreciate your input on the below matter:

- I have tried running an sql script in TOAD and in SQL Developer, both yielded different results. Running the INSERT script in SQL Developer, I managed to get a success response, whereby the table was created. However, when running the INSERT script in TOAD, an error "ORA-00917: missing comma" was encountered.
- I have verified the comma syntax and the command was written correctly.

Has anyone encountered this before? Appreciate your comments on this.

How would a query differ in both these applications?

Thanks and have a great day!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2012

Added on Nov 12 2012

#sql-developer

5 comments

1,291 views