3

Anyone knows if there is a column editor function in Oracle SQL Developer?

I have to modify the same column in a large number of insert statement and it would be really useful to have a column editor.

To explain better which is my problem i am searching a function similar to Eclipse ones when you type Alt + Shift + A (How do I enable the column selection mode in Eclipse?), and it allow you to edit in one time a lot of columns.

There is something similar or i have to do it manually?

I am using 4.1.5.21 version.

Thanks

Community
  • 1
  • 1
amicoderozer
  • 2,046
  • 6
  • 28
  • 44
  • You can add extra cursors by ctrl+shift+click, but I can't find column editing in SQL Developer so would recommend UltraEdit instead. – majjam Jul 07 '17 at 14:35
  • i know that, but it's not like others software column editing. I don't think it's possible right now, maybe in the future. Thank you anyway for the suggestion! – amicoderozer Jul 07 '17 at 15:24

2 Answers2

5

If you're using a newer version of Oracle Sql Developer (at least 18.3.x but perhaps before) there is an even easier way.

Simply go to the "Edit" menu and then choose "Block Selection":

Oracle SQL Developer Block Selection

risingTide
  • 1,754
  • 7
  • 31
  • 60
2

Edit/Wrap Selection (enable it):

https://www.thatjeffsmith.com/archive/2012/07/how-to-block-select-text-in-oracle-sql-developer/

Just press Shift and move cursors up and down, etc.

Be careful to press Esc after each edition as it seems to "stick" or something and it keeps adding cursors and modifying where you don't expect it.

Trick: The multi-cursor is useful to edit several parts in the same line.

Raúl Moreno
  • 311
  • 3
  • 14