爱飞的蒲公英

来源：http://www.teradataforum.com/l020829a.htm Teradata Compression (V2R4) Written by Mark Morris  (Teradata-NCR) Introduction We are entering a unique period

查询DBC.Users这个视图，查询出来的始终只有自己，查不到别的用户。 可以采用如下方法查询： select * from DBC.Databases where dbkind = 'U';

查询哪个用户对schema.table有权限： select * from dbc.allrights where databasename='schema' and tablename='table' 查询哪个角色对其有权限： select * from dbc.allrolerights where databasename='schema' and tablename='table'

alter table your_db.your_table ADD job_code TITLE 'depart number';

Every column in a table has a name and data type. The data type tells Teradata how much physical storage to set aside for the column, as well as the form in which to store the data. Teradata data type

用java连接teradata 其实也跟连接其他数据库插不多！ 1. 本地配置数据源 采用JDBC ODBC连接 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:kj021320");//这里我在本地配置了一个数据源叫kj021320 这样就可以直接

select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, sum(l_extendedprice*(1-l_discount)) as sum_disc_price, sum(l_extendedprice*(1-l_discount)*(1+