- 博客(9)
- 资源 (1)
- 收藏
- 关注
转载 1.1 RMAN Recovery: RESTORE and RECOVER Commands
1.1 RMAN Recovery: RESTORE and RECOVER Commands 在recovery操作 从备份中恢复全部或部分数据库的内容包含两个阶段:...
2014-01-27 15:45:45 116
转载 删除重复数据
删除重复数据delete from mdsp_t_prodorderexwhere rowid not in (select min(rowid) from mdsp_t_prodorderex group by ...
2013-08-14 09:34:21 106
转载 导入数据时遭遇ORA-39087错误
假设导入用户为sysdb数据文件存放目录为DATA_PUMP_DIR查询:select * from dba_directories where DIRECTORY_NAME='DATA_PUMP_DIR';...
2013-06-24 17:46:26 639
转载 Control the order of rows returned
01 SELECT 'Individual', 02 LAST_NAME || ', ' || FIRST_NAME 03 FROM CRUISE_CUSTOMERS 04 UNION 05...
2013-06-17 18:09:09 99
转载 12 Using the Set Operators
1. 4种操作符:union,union all,intersect,minus2. SELECT... UNION (SELECT... INTERSECT SELECT...) INTERSECT SELECT...Ju...
2013-06-17 10:31:41 90
转载 1212
Review the WORK_HISTORY table:Your task is to create a query that will list—for each ship—all of the EMPLOYE...
2013-06-08 09:39:43 81
转载 1 Managing Schema Objects
1Managing Schema Objects1.1Add and Modify Columns1.11Adding ColumnsAL...
2013-06-05 23:57:20 94
转载 solve Problems with Correlated subqueries
SELECT A.SHIP_CABIN_ID, A.ROOM_STYLE, A.ROOM_NUMBER, A.SQ_FT FROM SHIP_CABINS A WHERE A.SQ_FT > (S...
2013-06-03 09:55:24 187
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人