cenwenjia的博客

teradata后台登录bteq.logon ip/user,password;

select octet_length（‘中国’）–6字节，高斯里面一个汉字为三个字节select length（‘中国’） --2，位数

方法一：select replace(字段，’ ‘,’’) from table;方法二：select substr(字段，开始位置，空格开始前结束位置）||substr(字段，空格开始后位置，结束位置）from table;

1、查询表名和表注释select relname as tabname,cast(obj_description(relfilenode,‘pg_class’) as varchar) as comment from pg_class cwhere relname =‘table_name’ ;2、查询字段名、字段类型及字段长度和字段注释select a.attnum,a.attname,concat_ws(’’,t.typname,SUBSTRING(format_type(a.atttyp

1 创建表加注释：create table stu_info ( sno number(3), sname varchar2(30), sex varchar2(4));comment on column stu_info.sex is '性别';comment on column stu_info.sname is '姓名';comment on column stu_info.sno is 'ID';insert into stu_info(sno, s...