Sqlplus Application Example 1. export the queried data in sqlplus> set pagesize 0 set newpage none set trimout on set trimspool on spool/tmp/outfile. log select * from table; spool off 2. sqlplus cannot use Up on the keypad, Down to list used historical commands (like mysql), nor can it use left or right to move the cursor to change the command line, solve the following problem in ubuntu: sudo apt-cache search 'rlwre'; if you can find this lib in the preceding command, install sudo apt-get install 'rlwre' directly '; if it cannot be found in the preceding command, install the following: download and install readline, download and install rlwrap-c sqlplus (you will find any arrows on the keypad) if you use other commands (such as mysql) to find "/usr/local/lib/libreadline. so.6: undefined symbol "is similar to an error, the solution is as follows: cd/usr/local/lib sumkdir tempmv/usr/local/lib/libreadline * templdconfigapt-get update rm-rf/usr/local/lib/temp