oracle timeatamp,oracle12c_Temporal Validity

最新推荐文章于 2021-07-15 07:38:29 发布
最新推荐文章于 2021-07-15 07:38:29 发布
阅读量140 收藏
点赞数
文章标签： oracle timeatamp

创建Temporal Validity有两种方法一是自己指定列，一是让oracle自己指定 手工指定 CREATE TABLE Temporal_ValidityEMPNO NUMBER, SALARY NUMBER, DEPTID NUMBER, NAME VARCHAR2100, USER_TIME_START DATE, USER_TIME_END DATE, PERIOD FOR USER_TIME USER_TI

创建Temporal Validity有两种方法一是自己指定列，一是让oracle自己指定

手工指定CREATE TABLE Temporal_Validity

(EMPNO NUMBER, SALARY NUMBER, DEPTID NUMBER,

NAME VARCHAR2(100),

USER_TIME_START DATE,

USER_TIME_END DATE,

PERIOD FOR USER_TIME

(USER_TIME_START, USER_TIME_END));

SQL> SELECT OWNER,TABLE_NAME,COLUMN_NAME,COLUMN_ID FROM DBA_TAB_COLS WHERE TABLE_NAME=UPPER('Temporal_Validity');

: TEMPORAL_VALIDITY

TABLE COLUMN

Owner Name COLUMN_ID

---------- ------------------------------ ---------

TRAVEL USER_TIME_END 6

TRAVEL USER_TIME_START 5

TRAVEL NAME 4

TRAVEL DEPTID 3

TRAVEL SALARY 2

TRAVEL EMPNO 1

TRAVEL USER_TIME

7 ROWS selected.

SQL> col NAME FOR a15

SQL> col DEFAULT$ FOR a10

SQL> col SPARE4 FOR a1

SQL> col SPARE5 FOR a1

SQL> col SPARE6 FOR a1

SQL> SELECT * FROM sys.col$ WHERE obj#=92087;

OBJ# COL# SEGCOL# SEGCOLLENGTH OFFSET NAME TYPE# LENGTH FIXEDSTORAGE PRECISION# SCALE NULL$ DEFLENGTH DEFAULT$ INTCOL# PROPERTY CHARSETID CHARSETFORM EVALEDITION# UNUSABLEBEFORE# UNUSABLEBEGINNING# SPARE1 SPARE2 SPARE3 S S S SPARE7 SPARE8

---------- ---------- ---------- ------------ ---------- --------------- ---------- ---------- ------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------- ------------ --------------- ------------------ ---------- ---------- ---------- - - - ---------- ----------

92087 0 0 22 0 USER_TIME 2 22 0 0 0 9 430120635 1 65576 0 0 0 0 0 0

92087 1 1 22 0 EMPNO 2 22 0 0 2 0 0 0 0 0 0 0

92087 2 2 22 0 SALARY 2 22 0 0 3 0 0 0 0 0 0 0

92087 3 3 22 0 DEPTID 2 22 0 0 4 0 0 0 0 0 0 0

92087 4 4 100 0 NAME 1 100 0 0 5 0 873 1 0 0 0 100

92087 5 5 7 0 USER_TIME_START 12 7 0 0 6 0 0 0 0 0 0 0

92087 6 6 7 0 USER_TIME_END 12 7 0 0 7 0 0 0 0 0 0 0

7 ROWS selected.

SQL> col COLUMN_NAME FOR a20

SQL> col TABLE_NAME FOR a15

SQL> col CONSTRAINT_NAME FOR a20 USER_TIME_START ENABLED VALIDATED

SQL> col R_CONSTRAINT_NAME FOR a20

SQL> @cons

SHOW constraints ON TABLE %TEMPORAL_VALIDITY%...

OWNER TABLE_NAME CONSTRAINT_NAME CO R_CONSTRAINT_NAME COLUMN_NAME POSITION STATUS VALIDATED

------------------------------ --------------- -------------------- -- -------------------- ------------------------------ ---------- ---------------- --------------------------

TRAVEL TEMPORAL_VALIDI USER_TIMEA31EBB C USER_TIME ENABLED VALIDATED

TY

TRAVEL USER_TIMEA31EBB C USER_TIME_END ENABLED VALIDATED

TRAVEL USER_TIMEA31EBB C USER_TIME_START ENABLED VALIDATED

SQL>

SQL> @DESC TEMPORAL_VALIDITY

Name NULL? TYPE

------------------------------- -------- ----------------------------

1 EMPNO NUMBER

2 SALARY NUMBER

3 DEPTID NUMBER

4 NAME VARCHAR2(100)

5 USER_TIME_START DATE

6 USER_TIME_END DATE

手工指定是正常列，可以通过SELECT * 来查看

系统自动

SQL>

SQL> CREATE TABLE TEMPORAL_VALIDITY2

2 ( empno NUMBER, salary NUMBER, deptid NUMBER, name VARCHAR2(100),

3 PERIOD FOR user_time);

TABLE created.

SQL> @DESC TEMPORAL_VALIDITY2

Name NULL? TYPE

------------------------------- -------- ----------------------------

1 EMPNO NUMBER

2 SALARY NUMBER

3 DEPTID NUMBER

4 NAME VARCHAR2(100)

SQL>

SQL> col TABLE_NAME FOR a25

SQL> col OWNER FOR a10

SQL> SELECT OWNER,TABLE_NAME,COLUMN_NAME,COLUMN_ID FROM DBA_TAB_COLS WHERE TABLE_NAME=UPPER('Temporal_Validity2');

OWNER TABLE_NAME COLUMN_NAME COLUMN_ID

---------- ------------------------- -------------------- ----------

TRAVEL TEMPORAL_VALIDITY2 NAME 4

TRAVEL DEPTID 3

TRAVEL SALARY 2

TRAVEL EMPNO 1

TRAVEL USER_TIME

TRAVEL USER_TIME_END

TRAVEL USER_TIME_START

7 ROWS selected.

SQL>

SQL> @o TEMPORAL_VALIDITY2

owner object_name object_type STATUS OID D_OID CREATED LAST_DDL_TIME

------------------------- ------------------------------ ------------------ --------- ---------- ---------- ----------------- -----------------

TRAVEL TEMPORAL_VALIDITY2 TABLE VALID 92089 92089 20140526 22:41:37 20140526 22:41:37

SQL> SELECT * FROM sys.col$ WHERE obj#=92089;

OBJ# COL# SEGCOL# SEGCOLLENGTH OFFSET NAME TYPE# LENGTH FIXEDSTORAGE PRECISION# SCALE NULL$ DEFLENGTH DEFAULT$ INTCOL# PROPERTY CHARSETID CHARSETFORM EVALEDITION# UNUSABLEBEFORE# UNUSABLEBEGINNING# SPARE1 SPARE2 SPARE3 S S S SPARE7 SPARE8

---------- ---------- ---------- ------------ ---------- --------------- ---------- ---------- ------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------- ------------ --------------- ------------------ ---------- ---------- ---------- - - - ---------- ----------

92089 0 1 13 0 USER_TIME_START 181 13 0 6 0 1 32 0 0 0 6 0 0

92089 0 2 13 0 USER_TIME_END 181 13 0 6 0 2 32 0 0 0 6 0 0

92089 0 0 22 0 USER_TIME 2 22 0 0 0 9 430191669 3 65576 0 0 0 0 0 0

92089 1 3 22 0 EMPNO 2 22 0 0 4 0 0 0 0 0 0 0

92089 2 4 22 0 SALARY 2 22 0 0 5 0 0 0 0 0 0 0

92089 3 5 22 0 DEPTID 2 22 0 0 6 0 0 0 0 0 0 0

92089 4 6 100 0 NAME 1 100 0 0 7 0 873 1 0 0 0 100

7 ROWS selected.

SQL> @cons

SHOW constraints ON TABLE %TEMPORAL_VALIDITY2%...

OWNER TABLE_NAME CONSTRAINT_NAME CO R_CONSTRAINT_NAME COLUMN_NAME POSITION STATUS VALIDATED

------------------------------ ------------------------- -------------------- -- -------------------- ------------------------------ ---------- ---------------- --------------------------

TRAVEL TEMPORAL_VALIDITY2 USER_TIMEA43435 C USER_TIME_END ENABLED VALIDATED

TRAVEL USER_TIMEA43435 C USER_TIME_START ENABLED VALIDATED

SQL>

系统自动创建了2个隐藏列USER_TIME_START，USER_TIME_END

插入数据

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (101,1900,90,'ADAM',to_date('2000-01-01', 'yyyy-mm-dd') ,to_date('2004-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (102,2900,90,'ADAM',to_date('2001-01-01', 'yyyy-mm-dd') ,to_date('2005-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (103,3900,90,'ADAM',to_date('2002-01-01', 'yyyy-mm-dd') ,to_date('2006-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (104,4900,90,'ADAM',to_date('2003-01-01', 'yyyy-mm-dd') ,to_date('2007-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (105,5900,90,'ADAM',to_date('2004-01-01', 'yyyy-mm-dd') ,to_date('2008-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (106,6900,90,'ADAM',to_date('2005-01-01', 'yyyy-mm-dd') ,to_date('2009-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (107,7900,90,'ADAM',to_date('2006-01-01', 'yyyy-mm-dd') ,to_date('2010-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (108,8900,90,'ADAM',to_date('2007-01-01', 'yyyy-mm-dd') ,to_date('2011-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (109,9900,90,'ADAM',to_date('2008-01-01', 'yyyy-mm-dd') ,to_date('2012-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (110,1900,90,'ADAM',to_date('2009-01-01', 'yyyy-mm-dd') ,to_date('2014-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (111,2900,90,'ADAM',to_date('2010-01-01', 'yyyy-mm-dd') ,to_date('2011-05-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (112,3900,90,'ADAM',to_date('2011-01-01', 'yyyy-mm-dd') ,to_date('2011-08-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (113,4900,90,'ADAM',to_date('2012-01-01', 'yyyy-mm-dd') ,to_date('2013-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (114,5900,90,'ADAM',to_date('2013-01-01', 'yyyy-mm-dd') ,to_date('2014-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (115,6900,90,'ADAM',to_date('2014-01-01', 'yyyy-mm-dd') ,to_date('2015-01-01', 'yyyy-mm-dd'));

1 ROW created.

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (116,7900,90,'ADAM',to_date('2002-04-01', 'yyyy-mm-dd') ,to_date('2002-06-01', 'yyyy-mm-dd'));om

2

SQL> INSERT INTO TEMPORAL_VALIDITY2 (empno , salary , deptid , name , USER_TIME_START, USER_TIME_END) VALUES (116,7900,90,'ADAM',to_date('2002-04-01', 'yyyy-mm-dd') ,to_date('2002-06-01', 'yyyy-mm-dd'))

2 ;

1 ROW created.

SQL> commit;

Commit complete.

SQL> SELECT * FROM TEMPORAL_VALIDITY2;

EMPNO SALARY DEPTID NAME

---------- ---------- ---------- ---------------

101 1900 90 ADAM

101 1900 90 ADAM

102 2900 90 ADAM

103 3900 90 ADAM

104 4900 90 ADAM

105 5900 90 ADAM

106 6900 90 ADAM

107 7900 90 ADAM

108 8900 90 ADAM

109 9900 90 ADAM

110 1900 90 ADAM

111 2900 90 ADAM

112 3900 90 ADAM

113 4900 90 ADAM

114 5900 90 ADAM

115 6900 90 ADAM

116 7900 90 ADAM

SQL> SELECT NAME,

2 to_char(USER_TIME_START, 'yyyy-mm-dd'), to_char(USER_TIME_END, 'yyyy-mm-dd')

3 FROM TEMPORAL_VALIDITY2 ORDER BY 2;

NAME TO_CHAR(USER_TIME_ST TO_CHAR(USER_TIME_EN

--------------- -------------------- --------------------

ADAM 2000-01-01 2011-12-31

ADAM 2000-01-01 2004-01-01

ADAM 2001-01-01 2005-01-01

ADAM 2002-01-01 2006-01-01

ADAM 2002-04-01 2002-06-01

ADAM 2003-01-01 2007-01-01

ADAM 2004-01-01 2008-01-01

ADAM 2005-01-01 2009-01-01

ADAM 2006-01-01 2010-01-01

ADAM 2007-01-01 2011-01-01

ADAM 2008-01-01 2012-01-01

ADAM 2009-01-01 2014-01-01

ADAM 2010-01-01 2011-05-01

ADAM 2011-01-01 2011-08-01

ADAM 2012-01-01 2013-01-01

ADAM 2013-01-01 2014-01-01

ADAM 2014-01-01 2015-01-01

示例1

dfa73457a0586021bb3549004614a4bb.pngSQL> SELECT NAME,

2 to_char(USER_TIME_START, 'yyyy-mm-dd'), to_char(USER_TIME_END, 'yyyy-mm-dd')

3 FROM TEMPORAL_VALIDITY2 AS OF PERIOD FOR USER_TIME

4 to_date('2004-01-01', 'yyyy-mm-dd') ORDER BY 2;

NAME TO_CHAR(USER_TIME_ST TO_CHAR(USER_TIME_EN

--------------- -------------------- --------------------

ADAM 2000-01-01 2011-12-31

ADAM 2001-01-01 2005-01-01

ADAM 2002-01-01 2006-01-01

ADAM 2003-01-01 2007-01-01

ADAM 2004-01-01 2008-01-01

The query displays all whose

示例2

9aba239f4e855d584ee7b7eefc6bc899.png

SQL> SELECT NAME,

2 to_char(USER_TIME_START, 'yyyy-mm-dd'), to_char(USER_TIME_END, 'yyyy-mm-dd')

3 FROM TEMPORAL_VALIDITY2 versions PERIOD FOR USER_TIME

4 BETWEEN to_date('2004-01-01', 'yyyy-mm-dd')

5 AND to_date('2008-01-01', 'yyyy-mm-dd')

6 ORDER BY 2;

NAME TO_CHAR(USER_TIME_ST TO_CHAR(USER_TIME_EN

--------------- -------------------- --------------------

ADAM 2000-01-01 2011-12-31

ADAM 2001-01-01 2005-01-01

ADAM 2002-01-01 2006-01-01

ADAM 2003-01-01 2007-01-01

ADAM 2004-01-01 2008-01-01

ADAM 2005-01-01 2009-01-01

ADAM 2006-01-01 2010-01-01

ADAM 2007-01-01 2011-01-01

ADAM 2008-01-01 2012-01-01

The query displays all whose USER_TIME_START is less than or equal to ‘2004-01-01′ and USER_TIME_END greater than or equal to ‘2008-01-01′‘.

示例3

0f2932dd2d513f94d085e1e18aa719bc.png

SQL> EXEC DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME('CURRENT')

PL/SQL PROCEDURE successfully completed.

SQL> SELECT NAME,

2 to_char(USER_TIME_START, 'yyyy-mm-dd'), to_char(USER_TIME_END, 'yyyy-mm-dd')

3 FROM TEMPORAL_VALIDITY2 ORDER BY 2;

NAME TO_CHAR(USER_TIME_ST TO_CHAR(USER_TIME_EN

--------------- -------------------- --------------------

ADAM 2014-01-01 2015-01-01

示例4

SQL> EXEC DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME('ALL')

PL/SQL PROCEDURE successfully completed.

SQL> SELECT NAME,

2 to_char(USER_TIME_START, 'yyyy-mm-dd'), to_char(USER_TIME_END, 'yyyy-mm-dd')

3 FROM TEMPORAL_VALIDITY2 ORDER BY 2;

NAME TO_CHAR(USER_TIME_ST TO_CHAR(USER_TIME_EN

--------------- -------------------- --------------------

ADAM 2000-01-01 2011-12-31

ADAM 2000-01-01 2004-01-01

ADAM 2001-01-01 2005-01-01

ADAM 2002-01-01 2006-01-01

ADAM 2002-04-01 2002-06-01

ADAM 2003-01-01 2007-01-01

ADAM 2004-01-01 2008-01-01

ADAM 2005-01-01 2009-01-01

ADAM 2006-01-01 2010-01-01

ADAM 2007-01-01 2011-01-01

ADAM 2008-01-01 2012-01-01

ADAM 2009-01-01 2014-01-01

ADAM 2010-01-01 2011-05-01

ADAM 2011-01-01 2011-08-01

ADAM 2012-01-01 2013-01-01

ADAM 2013-01-01 2014-01-01

ADAM 2014-01-01 2015-01-01

17 ROWS selected.

Daisy-Tung
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Deploying_Oracle_RAC_12c_rhel7_v1.2.pdf
09-09
Deploying_Oracle_RAC_12c on rhel7 Deploying_Oracle_RAC_12c on rhel7 Deploying_Oracle_RAC_12c on rhel7 Deploying_Oracle_RAC_12c on rhel7
QUESTION 110-Temporal Validity
jisen_huang的专栏
05-11 185
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: create table employees (empno number, salary number, deptid number, name varchar2(100),period for employe
【12c】新特性：Oracle 12c Temporal Validity 时间有效性
个人公众号：Alen的数据库学习笔记
05-22 1254
在应用程序开发中，有时会碰到这样一个场景：设置一条记录的生效时间范围，比如某个产品信息，在某个时间段内是有效的，一般设计表时会在表中增加valid_start和valid_end这两个字段来限制，并通过设置这两个字段来实现具体产品的生效范围，如果查看当前生效的记录，则需要通过时间进行过滤。 Oracle 12.1.0.1引入了Temporal Validity（时间有效性），通过这一特性，在不增加列的情况下可以实现时间有效性的的判断，下面将对这一特性进行演示。 1 数据库版本 ALEN@PROD2&
12c,plsql新特性
anddyhua's Cookbook
07-20 1894
1.1.4 Improved Oracle SQL and PL/SQL The following sections describe the improved Oracle SQL and PL/SQL features 1.1.4.1 An Invoker's Rights Function Can Be Result Cached (调用者权限的函数结果也可以被cache）
Oracle 12C -- temporal validity
weixin_34235371的博客
11-03 275
temporal validity需要在创建表的时候使用一个vaild-time维度(包含时间起始和结束) 创建有valid-time维度的表 (1)显式指定两个date-time列 SQL> create table emp(empno number,salary number,deptid number,name varchar2(20),user_time_start dat...
【Oracle Database 12cR1新特性】Implementing Temporal Validity
weixin_34033624的博客
11-12 119
Implementing Temporal Validity [gview file="http://www.askmaclean.com/wp-content/uploads/2013/08/Implementing-Temporal-Validity.pdf"] 本文转自maclean_007 51CTO博客，原文链接:http://blog...
oracle12c_centos7.zip
05-26
oracle12C 离线安装的有的依赖包，全了
oracle_rac_12c_rhel7.pdf
06-19
通过udev创建oracle asm磁盘组，对oracle rac安装的每一步，都有详细讲解。是oracle rac安装经典文档。
Oracle_12c_RAC_官方安装指南.pdf
07-16
Oracle 12c RAC 官方安装指南 最佳实践 Oracle Database Real Application Clusters Guide, 12c Release 2 (12.2)
（实操）RedHat 7.4安装Oracle12c_RAC.docx
07-15
vsphere私有云平台安装Oracle12C_RAC实战，完全为个人实操笔记，Oracle Grid Infrastrue和数据库软装安装截图供参考，实际操作步骤完全一致
【趣味问答 12C新特性】时间有效性(temporal validity)
weixin_34203832的博客
07-18 517
编辑手记：Oracle 12.2官方文档已经发布。相比很多朋友们都迫不及待要深入学习了。今天我们来测一测你对12C的新特性了解多少。 本文原始出处：http://www.plsqlchallenge.com/ 翻译：newkid 苏旭辉 题目： 你正在创建一个产品报价的应用。它在如下的表保存这价格： create table plch_produc...
QUESTION 215-Temporal Validity feature
jisen_huang的专栏
07-15 123
Which three statements are true about the use of the In-Database Archiving and Temporal Validity feature of Oracle Database 12c? A. Temporal Validity spans the time between a row insert and a subsequent update or delete for the same row. B. Bot...
深入了解数据校验：Java Bean Validation 2.0（JSR303、JSR349、JSR380）Hibernate-Validation 6.x使用案例【享学Java】
架构师：通透，才能写出好代码！
07-21 8165
前言 前几篇文章在讲Spring的数据绑定的时候，多次提到过数据校验。可能有人认为数据校验模块并不是那么的重要，因为手动都可以做。若是这么想的话，那就大错特错了~ 前面讲解DataBinder的时候一个小细节，它所在的包是：org.springframework.validation，并且在分析源码的时候能看到DataBinder它不仅能够完成数据绑定，也提供了对数据校验的支持且保存校验结果。 我...
QUESTION 192- ValidTime Temporal
jisen_huang的专栏
06-20 210
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table employees: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employe
时态数据库(temporal database) 在 oracle 中的实现
点点滴滴
05-05 497
时态数据库是种以时间为基础的数据库，它所实现的不仅仅是对当前数据库的处理，也可以对过去和未来进行处理。 A temporal database is a database with built-in time aspects, e.g. a temporal data model and a temporal version of structured query language.   1...
钢筋混凝土污水池及提升泵站施工方案.doc
05-03
课程设计污水处理
PHP基于Web的subversion用户管理系统(源代码+设计说明书).zip
最新发布
05-03
PHP基于Web的subversion用户管理系统(源代码+设计说明书).zip
oracle12c查看pdb状态,oracle12c_pdb_SAVE STATE
06-10
要查看PDB状态，可以使用以下命令： ```SQL SHOW PDBS; ``` 该命令将显示所有PDB的状态。 要保存PDB的状态，可以使用以下命令： ```SQL ALTER PLUGGABLE DATABASE pdb_name SAVE STATE; ``` 该命令将保存PDB的状态，以便在重新启动后自动打开。请将“pdb_name”替换为您要保存状态的实际PDB名称。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值