I wish to know which one will be better in term of the performance by using summary table and view. If possible, pls share your opinion with me by using these 2 types of table and view. Thanks
create table lb_tj as select number,sum(cost) cost from rec_213_200705 where number=888888' group by number 这个语句在从ORACLE角度来看这样的语句是没问题的,不知INFORMIX的create table要怎么用才可以有上面的效果。
Creating a Basic table Adding and Controlling Borders Adding a border to the table can help distinguish the data cells and make the table more readable. Use the BORDER attribute in the table element to set a one-pixel border for the table border="1"> Alberts $160,251 $245,600 $132,000 $537,851 Setting Spacing and Padding The CELLSPACING attribute adds space between cells, whereas the CELLPA...
drop table t_theme; create table netbank.t_theme (id_theme serial not null , theme varchar(50), choice_num integer(4), choice1 varchar(50), choice2 varchar(50), choice3 varchar(50), choice4 varchar(50), choice5 varchar(50), choice6 varchar(50), standard_answer varchar(2), ); 如果要制定id_theme 为主键,,应该如何加? 多谢!
我用下面的语句创建了一张表,create table db_test2 (country varchar(30),location varchar(30),address varchar(50),username varchar(30)) tablespace test storage(initial 100k next 50k maxextents 20); ,接着查看了 INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS 106496 1 2147483645 为什么和我上面的创建的不符合呢;max_extents怎么会...
create TEMPORARY table actors ( id DECIMAL(03), name VARCHAR(40), CONSTRAINT actor_id CHECK (id < 150) ) ; insert into actors(id, name) values(1, 'camera'); insert into actors(id, name) values(2, 'flash mem'); "TEMPORARY 此表只是为这次会话创建,并且在会话结束后自动删除。当临时表存在时,同名的永久表是不可见的。" 但我觉得在对话结束后并没有自动删除 为什么上面的语句不...
我是一个管理软件的技术支持,后台用的是Oracle 9.2数据库。我对数据库只是知道一些基本的命令,希望能有哪位高手帮助分析一下。 This management software is about generating reporting, and there are tens of tables and views. What I found is that there are few exactly same names, such as DailySummarydata, WeeklySummarydata... YearlySummarydata for synonym, table and materialized view. There is only one in...
哪位大侠: 我现在在rs6000上,通过IBM的连接软件,把RS6000上的db2通过ODBC连到了AS400上,现在在RS6000上可以select,update,insert ,delete,就是不能create,出错信息为: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0601N The name of the object to be created is identical to the existing name "EA...
请教高手sybase有没有类似于oracle:create table tableA as select * from tableB 的用法在选择数据的同时建一个合A表结构一样的B表,多谢了。
我用system 用户 create table X.......... 创建完一个表后 ,执行 grant select on X to public; 然后 conn sys select * from X; 提示:表或视图不存在. 请各位老大帮忙。 :em02: :em02: :em02: :em02: :em02: