- 博客(6)
- 资源 (2)
- 问答 (1)
- 收藏
- 关注
RSS订阅Ajax的简单应用
<html><script language="javascript">window.onload = function() { document.getElementById("btn").onclick = function(){alert("初始化");print();}; } function test1(){ document.getEleme...
2008-08-29 14:17:13
122
如何在触发器中修改对象结构
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; 上面的代码仅仅是通过触发事件来修改...
2008-08-26 11:02:35
163
trigger的管理
CREATE TRIGGER名称CREATE TRIGGER — 创建一个新触发器 语法CREATE TRIGGER name { BEFORE | AFTER } { event [OR ...] } ON table FOR EACH { ROW | STATEMENT } EXECUTE PROCEDURE func ( arguments )输入name 触发器名称． tab...
2008-08-24 13:02:44
227
sequence的管理
CREATE SEQUENCE名称CREATE SEQUENCE — 创建一个新的序列号生成器 语法CREATE SEQUENCE seqname [ INCREMENT increment ] [ MINVALUE minvalue ] [ MAXVALUE maxvalue ] [ START start ] [ CACHE cache ] [ CYCLE ]输入seqname ...
2008-08-24 12:59:21
176
table的管理
CREATE TABLE名称CREATE TABLE — 创建一个新表 语法CREATE [ TEMPORARY | TEMP ] TABLE table ( column type [ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ] [column_constraint_clause | PRIMARY KEY } [ ... ]...
2008-08-24 12:57:48
291
基于dual 有意思的decode和case-when-then-else-end的测试
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 i...
2008-08-24 12:55:25
175
TA创建的收藏夹 TA关注的收藏夹
TA关注的人