Forum Stats

  • 3,815,372 Users
  • 2,259,010 Discussions
  • 7,893,059 Comments

Discussions

Windows: control-v no longer works to paste in 21.4

hannangf
hannangf Member Posts: 1 Blue Ribbon

With the latest 21.4 version of SQLcl (sql.exe bundled in SQL Developer), control-v appears to no longer work for pasting from the clipboard. This is true when launching SQLcl by double-clicking sql.exe, launching it from a standard CMD window, and launching it from a powershell window. However, control-v does work when launching from a CMD or Powershell tab in the new Windows Terminal application.

Is this a SQLcl bug? Is there a workaround? We often cannot get Windows Terminal installed.

Windows 10 21H1

Answers

  • ianm42
    ianm42 Member Posts: 38 Blue Ribbon

    Not a solution, but a right-click of the mouse will do a 'paste'.

  • User_2DKLA
    User_2DKLA Member Posts: 33 Red Ribbon

    Hi,

    This is probably by design.

    SQL> show version
    Oracle SQLDeveloper Command-Line (SQLcl) version: 22.1.0.0 build: 22.1.0.90.1611
    
    SQL> show editor
    Inline editor: vi
    
    SQL> show keymap
    Keymap for vi editor command mode (vicmd):
    ...
    ^V                  quoted insert character
    ...
    Keymap for vi editor insert mode (viins):
    ...
    ^V                  quoted insert character
    ...
    
    SQL> set editor emacs
    
    SQL> show editor
    Keymap for emacs editor:
    ...
    ^V                  quoted insert character
    ...
    

    Bottom line: Ctrl+V now means: do not treat the following keystroke as a control character—append it as-is to the input stream.

    Regards,

  • User_2DKLA
    User_2DKLA Member Posts: 33 Red Ribbon

    If using Powershell or cmd.exe under Windows, you still have the option of setting Ctrl+Shift+C/V as the shortcuts for cut and paste into/from the clipboard...

    Regards,