![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
OCP考题记录
文章平均质量分 79
OCP考题记录
大柏树运维笔记
这个作者很懒,什么都没留下…
展开
-
about GLOBAL TEMPORARY TABLES
1.创建SQL语句CREATE GLOBAL TEMPORARY TABLE tablename (columns) [ ON COMMIT PRESERVE | DELETE ROWS ]SQL> create global temporary table emp_temp(eno number) on commit delete rows;-- transact...原创 2019-12-20 17:06:00 · 313 阅读 · 0 评论 -
oracle-single row function
1.概念单行函数:single row funcation指一行数据输入,返回一个值的函数,常见的有字符函数(如:substr)日期函数(如:months_between)数字函数(如:MOD)转换函数(如:to_char)通用函数(如:NVL)多行函数 :muti row function指多行数据输入,返回一个值的函数常见的有sum 、 max等2.single row...原创 2019-12-05 14:12:00 · 397 阅读 · 0 评论 -
grant
用于给对象授权=================================================================================================================================ocp考题1.sequence的操作只有select和alert2.system privilege权限execut...原创 2019-12-05 15:01:00 · 197 阅读 · 0 评论 -
oracle中delte、truncate和drop的区别
1.种类:首先,delete是dml语句,truncate和drop是ddl语句。2.表和索引所占的空间truncate表后,表和索引的大小恢复到所占空间初始大小。delete不改变表和索引所占空间的大小。drop将表和索引所占用的空间全部释放。3.删除速度drop > truncate > delete4.结构truncate与不带where条件的delete删除表...原创 2019-12-05 13:34:00 · 631 阅读 · 0 评论 -
oracle中and和or
复习ocp考题的时候有道关于and和or的题目,拿出来看一下and和or的区别:Choose twoExamine the description of theBOOKS_TRANSACTIONStableName Null? Type---------------------------------------------------------------------------...原创 2019-12-19 15:58:00 · 340 阅读 · 0 评论 -
create sequence
CREATE SEQUENCEPurposeUse theCREATESEQUENCEstatement to create asequence, which is a database object from which multiple users may generate unique integers. You can use sequences to automatica...原创 2019-12-26 11:49:00 · 197 阅读 · 0 评论 -
scalar subquery expressions 标量子查询
Scalar Subquery ExpressionsA scalar subquery expression is a subquery that returns exactly one column value from one row. The value of the scalar subquery expression is the value of the select list ...原创 2019-12-26 10:36:00 · 305 阅读 · 0 评论 -
scalar subquery expressions
Scalar Subquery ExpressionsA scalar subquery expression is a subquery that returns exactly one column value from one row. The value of the scalar subquery expression is the value of the select list ...原创 2019-12-31 10:17:00 · 340 阅读 · 0 评论 -
virtual columns
Virtual columns are expressions that are based on one or more existing columns in the table. When using Virtual Column-Based Partitioning, a virtual column in a table provides advantages in disk spa...原创 2019-12-31 09:50:00 · 144 阅读 · 0 评论 -
about SQL*Loader Express Mode
SQL * Loader ExpressSQL * Loader快速模式使您可以快速轻松地使用SQL * Loader加载简单的数据类型。话题:什么是SQL * Loader Express模式使用SQL * Loader Express模式SQL * Loader Express模式参数参考SQL * Loader Express模式语法图1.什么是SQL * Loader ...原创 2020-01-06 10:51:00 · 223 阅读 · 0 评论 -
oracle--set unused
一.使用set unused的情况当表中的某一个列不再使用的时候,我们可以删除这个列alter table xxx drop column xxx;或者alter table xxx drop (xxx,xxx);当删除列的时候,需要注意的是,不能删除一个表的所有列和删除sys下面表的列。You cannot drop all columns from a table, nor ca...原创 2020-01-02 14:28:00 · 240 阅读 · 0 评论 -
merge
PurposeUse theMERGEstatement to select rows from one or more sources for update or insertion into a table or view. You can specify conditions to determine whether to update or insert into the targ...原创 2019-12-26 13:43:00 · 87 阅读 · 0 评论 -
ocp考题解析create user
原题:You execute the commands:SQL>CREATE USER sidneyIDENTIFIED BY out_standing1DEFAULT TABLESPACEusersQUOTA 10M ONusersTEMPORARY TABLESPACEtempACCOUNT UNLOCK;SQL> GRANT CREATE SESSION ...原创 2020-05-26 10:26:00 · 134 阅读 · 0 评论