Why Rlwrap Echos "Redundantly" What I Type from the Keyboard

Why rlwrap echos redundantly what I type from the keyboard?

This was a known bug with pre-0.36 rlwrap in vi mode. You don't mention your rlwrap version and editing mode (i.e. emacs or vi) but I would suggest upgrading to rlwrap-0.37 and filing a bug report with the rlwrap author if that doesn't help

How to hide ACCEPT command used for user input in SQL Plus while spooling it in a text file? I have tried set VERIFY off

SQL> SET VERIFY OFF

SQL> ACCEPT name CHAR PROMPT 'Enter name::  ' HIDE

Enter name:

SQL> select * from sample where upper(name) = upper(&name);

This way, it will not show OLD/NEW Value, and also you could enter Value in Hidden Way. No display on what you enter.

listagg output formatting

Nothing stops you to make your query a sub-query and select again:

SELECT BOOKID || ':' || AUNAMES FROM 
(
 select BOOKID,
 listagg (AUNAME,' ') WITHIN GROUP (ORDER BY auname)
 AUNAMES
 FROM BOOK_AUTHOR
 group by bookid
) A

If you want to use a space as a delimiter use it in the listagg function

---

Related Topics