set delimiter

User, date Message
Written by kun6858
1 year ago
Category: Feature discussion
3 posts since Mon, 23 Apr 12
as you already know the character ; is the default delimiter which delimits each SQL query.

but I'd like to set this default to newline character, for instance ("\n") so that i can execute query easily like Toad for oracle.
Written by kun6858
1 year ago
3 posts since Mon, 23 Apr 12
anyone knows about it?
Written by ansgar
1 year ago
3975 posts since Fri, 07 Apr 06
You can set the delimiter to anything but a newline charactersmileIndeed, that's a limitation of the DELIMITER command, which needs a new line at the end to recognize the delimiter.
Written by kun6858
1 year ago
3 posts since Mon, 23 Apr 12
unhappyOK, dude. thanks
Written by ansgar
1 year ago
3975 posts since Fri, 07 Apr 06
Hm, did you know you can run the current query where the cursor is located, via Shift+Ctrl+F9 . That's probably what you need.
 

Please login to leave a reply, or register at first.