sqlplus每行单列显示
2016-05-13set linesize 50行设置短一些，让sqlplus换行
user_name:jydm
dep_id:10003826
password:36724684ff9a81aa941fda0821d05d77
ctime:
set hea off
col value$ format a40
select * from nls_database_parameters;
select 'id:'||id,'name:'||name,'user:'||user,'class:'||class from dbname;
set hea off
set linesize 50
col user_name format a10
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
select 'user_name:'||USER_NAME ,'dep_id:'||DEPARTMENT_ID,'password:'||PASSWORD,'ctime:'||CREATE_TIME from customer where rownum < 10;
user_name:test
dep_id:10132196
password:c73d844683c697aee9a3937ff04c0ee9
ctime:2016-01-13 16:23:32