ITPub博客

SQL> SELECT * FROM V$VERSION WHERE ROWNUM=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production[oracle@localhost ~]$ cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 ...

摘自：http://bbs.51cto.com/thread-926748-1.html十五年前，你或许还不懂爱情，看Jack和Rose执手相看泪眼，只是蒙胧的心痛。十五年后，你会和谁一起走进影院，更会和谁一起，走到生命终点。十五年前，我还不太懂技术，凭兴趣玩着C语言。十五年后，当铁达尼的旋律再次响起，我会选择和哪门技术，一起走到我职业生涯的终...

SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production[oracle@localhost ~]$ cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carth...

ORA-00001: 违反唯一约束条件 (.) ORA-00017: 请求会话以设置跟踪事件 ORA-00018: 超出最大会话数 ORA-00019: 超出最大会话许可数 ORA-00020: 超出最大进程数 () ORA-00021: 会话附属于其它某些进程；无法转换会话 ORA-00022: 无效的会话 ID；访问被拒绝 ORA-00023: 会话引用进...

SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production 下面是摘自11gR2部分官方文档： CREATE SEQUENCE Purpose Use the ...

CREATE OR REPLACE PACKAGE BODY QUEST_LUCY_COLLECTOR IS   TYPE TYP_ERROR IS RECORD    (      ERROR_TIME TIMESTAMP WITH TIME ZONE( 6 ),      ERROR_MESSAGE VARCHAR2( 4000 ),      ERROR_STACK VARCHAR2( 4000 ),      ERR...

这部分很基础，但是如果搞不清楚，对以后的学习会有影响。SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production1.sqlplus username/password@net_servic...

SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production今天做实验时，用的是sqlplus，插入一条数据后，没有提交误关了sqlplus，重新登录后，发现这条数据已经...

本人是一名大二的学生，很喜欢数据库方面的知识，正在学习的路上，学习的过程虽然辛苦，但是对技术的热爱和对生活的提高时刻激励我们学习下去！找到志同道合的人一起学习是一大快事！我相信对学习的促进是十分巨大的。希望大家不嫌弃小弟是个菜鸟，一起学习交流oracle，Linux  相信和你们在一起，我会慢慢成长起来！OR...

QUESTION NO: 58You are currently located in Singapore and have connected to a remote database in Chicago.You issue the following command:Exhibit:PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.What is the outcome?A. Number of d...

shmmax内核参数定义是系统允许的单个共享内存段的最大值现在模拟设置shmmax很小：[root@localhost kernel]# cat /etc/redhat-releaseRed Hat Enterprise Linux Server release 5.5 (Tikanga)SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------...

本组ＯＣＰ考试试题文章引自http://blog.csdn.net/rl

QUESTION NO: 59Evaluate the following two queries:Which statement is true regarding the above two queries?A. Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT columnB. Performance would degrade in query 2C. There would be no ch...

QUESTION NO: 60View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables. The CUSTOMERS table contains the current location of all currently active customers. TheCUST_HISTORY table stores historical details relating to any changes in the location of al...

关于日期和时间在数据库中经常用到，下面总结了一些这方面的知识。因为字符集对日期时间有影响，这个是我们首先要关注的，之前的文章中也简单的提到了（http://blog.itpub.net/29876893/viewspace-1627370/）SQL> select * from nls_session_parameters where rownum<4;PARAMETER-------------------------------------...

QUESTION NO: 61You created an ORDERS table with the following description:Exhibit: You inserted some rows in the table. After some time, you want to alter the table by creating thePRIMARY KEY constraint on the ORD_ID column.Which statement is true in this scenario?A. Yo...

由于练习机模拟，误删了口令文件，所以不得不重建：SQL> exit从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options 断开C:\>sqlplus sys/manager@55 as sysdbaSQL*Plus: Release 11.2.0.1.0 Production o...

当spfile损坏，而且没有了pfile文件和init.ora文件，则我们不得不重建参数文件：下面模拟参数文件损坏，删除了所有的参数文件：SQL> startup nomount;ORA-01078: failure in processing system parametersLRM-00109: ???????????????????????? '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/i...

这部分是属于oracle全球化支持的内容，详细了解可以参考文档首先谈一下数据库字符集，我们用dbca建库的时，会让你选择数据库字符集，默认的就是基于操作系统的语言设置：[oracle@localhost ~]$ echo $LANG;zh_CN.UTF-8SQL> select userenv('language') from dual  2  ;USERENV('LANGUAGE')-----------...

这几天qq上很多朋友问及客户端网络配置问题，希望这篇文章能帮助一些朋友（之前也写过一篇文章关于用第三方工具连接数据库:http://blog.itpub.net/29876893/viewspace-1465317/）。首先说明的是数据库是单实例，数据库的连接方式是专有连接模式。SQL> select * from v$version where rownum=1;BANNER-------------------...