3 Replies Latest reply on May 3, 2017 5:50 PM by thatJeffSmith-Oracle

    Semicolon in strings not handled properly in 4.2

    Mustafa KALAYCI



      I just started to use sqldeveloper 4.2 version (I was using 4.1). I searched and found some similar topics about my problem but they are all about comments. Mine is strings:


      select 'alter table  .... ;

      alter table ... ;'

      from dba_Tables;


      this is something I use a lot, I generate scripts using select statements. but semicolon in a string is acted as end of command.is this is a correct behavior? waiting for comments thanks.


      edit: of course I know I can use workarounds but I have many scripts like that and I really don't want to change all of them.