1.查看所有配置
SQL>show all;
2.查看具体某个参数
SQL> show max_connections;
name | setting
--------------------------+---------
MAX_CONNECTIONS | 200
MAX_CONNECTIONS_PER_USER | 0
SQL> show NAME_CASE_SENSITIVE;
name | setting
---------------------+---------
NAME_CASE_SENSITIVE | TRUE
(1 row)
修改配置参数
vi /opt/ShenTong/admin/HXL.conf
#SQL中表名和列名是否区分大小写，为FALSE时SQL里小写也可以匹配上数据库里大写的表名列名
NAME_CASE_SENSITIVE=false
重启
systemctl stop oscardb_HXLd.service
systemctl start oscardb_HXLd.service
systemctl status oscardb_HXLd.service
再次查看参数
[root@localhost bin]# ./isql -h localhost -p 2003 -d HXL sysdba
密码是:szoscar55
SQL> show NAME_CASE_SENSITIVE;
name | setting
---------------------+---------
NAME_CASE_SENSITIVE | FALSE
(1 row)
SQL>
标签：CASE,HXLd,NAME,神舟,数据库,show,SENSITIVE,日常,SQL From： https://www.cnblogs.com/hxlasky/p/18053545