POJ---3281 Dining【拆点最大流】

Description Cows are such finicky eaters. Each cow has a preference for certain foods and drinks, and she will consume no others. Farmer John has cooked fabulous meals for his cows, but he forgot ...

POJ---1273 Drainage Ditches【最大流】

Description Every time it rains on Farmer John's fields, a pond forms over Bessie's favorite clover patch. This means that the clover is covered by water for awhile and takes quite a long time to r...

HDU---1732 Push Box【BFS】

Problem Description Push Box is a classic puzzle game. This game play in a grid, there are five types of block in it, the player, the box, the hole, empty place, and the wall. In every step, player...

POJ---3984 迷宫问题【BFS+回溯法】

Description 定义一个二维数组：  int maze[5][5] = { 0, 1, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 1, 0, }; 它表示一个迷宫，其中的1表示墙壁，0表示可以走的路，只能横着走或竖着走，不能斜着走，要求编程序找出从左上角到右下角的最短路线...

【oracle】使用sys进行的操作

SELECT * FROM DBA_TABLESPACES;   --查看表空间   DESC DBA_TABLESPACES;   --查看表空间结构   SELECT * FROM DBA_DATA_FILES;   --查看数据的表空间数据字典，表的存储位置   SELECT * FROM DBA_TEMP_FILES;   --查看数据的临时表空间数据字典，表的存储位置   ...

【oracle】用户权限及角色管理

CREAT USER exercise IDENTIFIED BY 123456 DEFAULT TABLESPACE mldn_data TEMPORARY mldn_temp QUOTA 1M ON mldn_data       创建用户 QUOTA 2M ON users ACCONT UNLOCK PASSWORD EXPIRE; DROP USER exercis...

【oracle】其他数据对象

CREATE VIEW V_MYVIEW    AS SELECT * FROM EMP    --创建视图 WHERE SAL>2000;   SELECT *        --查询视图 FROM V_MYVIEW;   SELECT * FROM USER_VIEWS;    --查看视图目录   CREATE OR REPLACE VIEW V_MYVIEW(部门编号,...

【oracle】完整性约束

CREATE TABLE STUDENT  (SNOCHAR(10) ,  SNAME CHAR(25),  SSEX CHAR(5),  SAGE NUMBER(2),              --CONSTRAINT,为约束对象取个别名  SDEPT CHAR(25),  CONSTRAINT PK_SNO PRIMARY KEY(SNO),  CONSTRAINT UK...

【oracle】表的创建与管理

CREATE TABLE member(   midNUMBER(5),  name VARCHAR2(50) DEFAULT '无名氏',  --设置默认值   ageNUMBER(3),      --创建表  birthday DATE DEFAULT SYSDATE,  note CLOB );   SELECT * FROM tab;   --查看所有表   DESC...

HDU---2364 Escape【广度优先搜索】

Problem Description You find yourself trapped in a large rectangular room, made up of large square tiles; some are accessible, others are blocked by obstacles or walls. With a single step, you can ...

【oracle】替代变量

SELECT * FROM EMP            --替代数字 WHERE SAL>&INPUT;   SELECT * FROM EMP          --替代字符串,区分大小写 WHERE ENAME='&INPUT';   SELECT * FROM EMP          --替代字符串,用UPPER函数转换为大写 WHERE ENAME=UPPER...

【oracle】事务更新及处理

INSERT INTOEMP(EMPNO,ENAME,JOB,HIREDATE,SAL)   --增加操作 VALUES(6612，'张三','CLERK',TO_DATE('1989-09-19','YYYY-MM-DD'),600);   UPDATE EMP SET SAL=3000，COMM=500 WHERE EMPNO=7369;   UPDATE EMP SET SAL=...

【oracle】子查询

SELECT * FROM EMP WHERE SAL IN(  SELECT MIN(SAL) FROM EMP       --用IN进行统计查询  GROUP BY DEPTNO );   SELECT * FROM EMP WHERE SAL NOT IN(  SELECT MIN(SAL) FROM EMP       --用IN进行统计查询  GROUP BY D...

100条 共5页1 2 3 4 5 ... 下一页 尾页
个人资料
• 访问：11613次
• 积分：1035
• 等级：
• 排名：千里之外
• 原创：89篇
• 转载：11篇
• 译文：0篇
• 评论：0条
文章分类
评论排行