文章列表
<html><script language="javascript">window.onload = function() { document.getElementById("btn").onclick = function(){alert("初始化");print();}; }
function test1(){ document.getElementById("btn").onclick = function(){alert("可用");pr ...
- 2008-08-29 14:17
- 浏览 1011
- 评论(0)
create or replace trigger test_trigger before insert on test_tab for each rowdeclare -- local variables herebegin
alter sequence test_seq maxvalue 1000; end test_trigger; 上面的代码仅仅是通过触发事件来修改sequence的最大值;也就是执行了修改对象结构的语句; 显然这是不能编译通过的,除了手工执行像:
alter sequence test_seq maxvalue 1000;的语句有没有 ...
- 2008-08-26 11:02
- 浏览 913
- 评论(0)
CREATE TRIGGER名称CREATE TRIGGER — 创建一个新触发器
语法CREATE TRIGGER name { BEFORE | AFTER } { event [OR ...] } ON table FOR EACH { ROW | STATEMENT } EXECUTE PROCEDURE func ( arguments )输入name 触发器名称. table 表名称. event INSERT,DELETE 或 UPDATE 之一. funcname 一个用户提供的函数.
输出CREATE 如果触发器成功创建,返回此信息.
描述CREATE TRI ...
- 2008-08-24 13:02
- 浏览 1408
- 评论(0)
CREATE SEQUENCE名称CREATE SEQUENCE — 创建一个新的序列号生成器
语法CREATE SEQUENCE seqname [ INCREMENT increment ] [ MINVALUE minvalue ] [ MAXVALUE maxvalue ] [ START start ] [ CACHE cache ] [ CYCLE ]输入seqname 将要创建的序列号名. increment INCREMENT increment 子句是可选的.一个正数将生成一个递增的序列,一个负数将生成一个递减的序列.缺省值是一(1). minvalue 可选的子 ...
- 2008-08-24 12:59
- 浏览 1301
- 评论(0)
CREATE TABLE名称CREATE TABLE — 创建一个新表
语法CREATE [ TEMPORARY | TEMP ] TABLE table ( column type [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ] [column_constraint_clause | PRIMARY KEY } [ ... ] ] [, ... ] [, PRIMARY KEY ( column [, ...] ) ] [, C ...
- 2008-08-24 12:57
- 浏览 1018
- 评论(0)
select decode( op ,'a','hht,I am A; b is the base! and It is not a lie , ' ||'please believe me;I promise!' ,'b','hht,I am B; a is the base! and It is not a lie , ' ||'please believe me;I promise!' ,'c','I am not al ...
- 2008-08-24 12:55
- 浏览 1288
- 评论(0)