问题：数据库表名有中划线怎么办？

方法：

SELECT * from [suc_班级-专业-学院简要信息]

问题：sqlserver如何查看表注释？

方法：

SELECT
A.name AS 表名,
B.name AS 字段名,
C.value AS 字段说明
FROM sys.tables A
INNER JOIN sys.columns B ON B.object_id = A.object_id
LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id AND C.minor_id = B.column_id
WHERE A.name = '表名'

查询所有字段，可查视图

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='表名/视图名'

SELECT
    COLUMN_NAME,
    DATA_TYPE,
    CHARACTER_MAXIMUM_LENGTH,
    CHARACTER_OCTET_LENGTH
FROM
    information_schema.COLUMNS
WHERE
    TABLE_NAME = '表名/视图名'

阅读全文

问题：如何查看oracle表结构、视图结构？

方法：

表及字段信息

SELECT * FROM cols WHERE TABLE_NAME = 'xxx';

字段注释

SELECT * FROM user_col_comments WHERE TABLE_NAME = 'xxx';

SELECT * FROM all_col_comments WHERE TABLE_NAME = 'xxx';

表/视图名称及说明

SELECT * FROM user_tab_comments WHERE TABLE_NAME = 'xxx';

SELECT * FROM all_tab_cols WHERE table_name ='LBORGANIZATION' and owner='USR_RSXT';

阅读全文

问题：表字段为desc，导致sqoop导入数据时出错

解决：使用反引号进行转译

方法：

import_recruit_signup_annex_type(){
  import_data recruit_signup_annex_type 'select
                                             id,
                                             title,
                                             `desc`,
                                             graduate,
                                             in_serv,
                                             high_level,
                                             graduate_sort,
                                             in_serv_sort,
                                             high_level_sort,
                                             is_delete
                                          from oahr_recruit_signup_annex_type'
}

问题：如何通过jdbc连接oracle？

解决：jdbc连接方式有三种，使用正确方式才能连上

方法：
1、jdbc:oracle:thin:@host:port:SID

jdbc:oracle:thin:@localhost:1521:orcl

2、jdbc:oracle:thin:@//host:port/service_name 推荐

jdbc:oracle:thin:@//localhost:1521/orcl.city.com

3、jdbc:oracle:thin:@TNSName

jdbc:oracle:thin:@TNS_ALIAS_NAME

阅读全文