SQL> column "123456" format a50 --定义显示列的长度 SQL> /123456 -------------------------------------------------- 12SQL> select '1' as "123456" from dual;123456 -------------------------------------------------- 1
SQL> column "123456" format a50 SQL> select '1' as "123456" from dual;123456 -------------------------------------------------- 1SQL> select '12' as "123456" from dual;123456 -------------------------------------------------- 12
我这就正常 在plsql dev中: SQL> select '1' as "123456" from dual 2 /
123456 ------ 1
SQL> select '12' as "123456" from dual 2 /
123456 ------ 12在sqlplus中就不正常了: SQL> select '1' as "123456" from dual 2 /1 - 1SQL> select '12' as "123456" from dual 2 /12 -- 12
col '12345' format a10; col de_name format a10 在SQL PLUS中输入这个命令,刚刚显示的表排列紧缩 a后面的数字按照需要自己设置
我用的是sql plus (cmd window),定义格式可以解决问题,但是我的疑惑还是没有了解清楚。。
注意看看sqlplus/admin目录下边的glogin.sql就知道了。-- -- Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved. -- -- NAME -- glogin.sql -- -- DESCRIPTION -- SQL*Plus global login startup file. -- -- Add any sqlplus commands here that are to be executed when a user -- starts SQL*Plus on your system -- -- USAGE -- This script is automatically run when SQL*Plus starts ---- For backward compatibility SET PAGESIZE 14 SET SQLPLUSCOMPATIBILITY 8.1.7-- Used by Trusted Oracle COLUMN ROWLABEL FORMAT A15-- Used for the SHOW ERRORS command COLUMN LINE/COL FORMAT A8 COLUMN ERROR FORMAT A65 WORD_WRAPPED-- Used for the SHOW SGA command COLUMN name_col_plus_show_sga FORMAT a24-- Defaults for SHOW PARAMETERS COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE-- Defaults for SET AUTOTRACE EXPLAIN report COLUMN id_plus_exp FORMAT 990 HEADING i COLUMN parent_id_plus_exp FORMAT 990 HEADING p COLUMN plan_plus_exp FORMAT a60 COLUMN object_node_plus_exp FORMAT a8 COLUMN other_tag_plus_exp FORMAT a29 COLUMN other_plus_exp FORMAT a44
是在plsql plus中的显示宽度有问题 column "123456" format a50 --定义显示列的长度
SQL> column "123456" format a50 --定义显示列的长度
SQL> /123456
--------------------------------------------------
12SQL> select '1' as "123456" from dual;123456
--------------------------------------------------
1
SQL> column "123456" format a50
SQL> select '1' as "123456" from dual;123456
--------------------------------------------------
1SQL> select '12' as "123456" from dual;123456
--------------------------------------------------
12
我这就正常 在plsql dev中:
SQL> select '1' as "123456" from dual
2 /
123456
------
1
SQL> select '12' as "123456" from dual
2 /
123456
------
12在sqlplus中就不正常了:
SQL> select '1' as "123456" from dual
2 /1
-
1SQL> select '12' as "123456" from dual
2 /12
--
12
你只需要能够实现你的需求就ok了
只实现了sqlplus部分功能,当然实现的部分一些细节是不一样的。初学者使用plsql developer的command窗口还是很方便的。
col de_name format a10 在SQL PLUS中输入这个命令,刚刚显示的表排列紧缩
a后面的数字按照需要自己设置
-- Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved.
--
-- NAME
-- glogin.sql
--
-- DESCRIPTION
-- SQL*Plus global login startup file.
--
-- Add any sqlplus commands here that are to be executed when a user
-- starts SQL*Plus on your system
--
-- USAGE
-- This script is automatically run when SQL*Plus starts
---- For backward compatibility
SET PAGESIZE 14
SET SQLPLUSCOMPATIBILITY 8.1.7-- Used by Trusted Oracle
COLUMN ROWLABEL FORMAT A15-- Used for the SHOW ERRORS command
COLUMN LINE/COL FORMAT A8
COLUMN ERROR FORMAT A65 WORD_WRAPPED-- Used for the SHOW SGA command
COLUMN name_col_plus_show_sga FORMAT a24-- Defaults for SHOW PARAMETERS
COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME
COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE-- Defaults for SET AUTOTRACE EXPLAIN report
COLUMN id_plus_exp FORMAT 990 HEADING i
COLUMN parent_id_plus_exp FORMAT 990 HEADING p
COLUMN plan_plus_exp FORMAT a60
COLUMN object_node_plus_exp FORMAT a8
COLUMN other_tag_plus_exp FORMAT a29
COLUMN other_plus_exp FORMAT a44
column "123456" format a50 --定义显示列的长度