从今天开始

暂无签名

  • 博客访问: 56326
  • 博文数量: 42
  • 用 户 组: 普通用户
  • 注册时间: 1970-01-01 08:00
个人简介

鏆傛棤浠嬬粛

文章分类

全部博文(42)

文章存档

2009年(1)

2008年(1)

2007年(40)

我的朋友

发布时间:2007-08-01 16:40:57

The NLS_LANG environment variable specifies the language,territory,and charater set support by the user session in an oracle 10g database.[@more@]The format to specify NLS_LANG is _..The portion specifies the default data format,numeric format,and monetary formats.The default data format assigned to the Oracle 10g database will be DD-MON-YY.......【阅读全文】

阅读(291) | 评论(0) | 转发(0)

发布时间:2007-08-01 16:05:42

while installing the Oracle 10g database on a UNIX platform,you are prompted to run the scirpt file orainstRoot.sh ,which creates another file orainst.loc[@more@].oraInst.loc file is used to find the inventory location when Oracle Universal Installer startup.It is not used by Oracle Universal Installer to store the home directory and base directory locations.No particular file stores the home directory and base directory.These are specified by environment variables.......【阅读全文】

阅读(216) | 评论(0) | 转发(0)

发布时间:2007-08-01 14:16:20

To shrink table and its dependant segments,you should use the ALTER TABLE ** SHRINK SPACE CASCADE;statement .Using the CASCADE clause shrinks all the dependant segments of the ** table to release the unused space below and above the High Water Mark(HWM).[@more@]The table should be located in a tablespace on which automatic segment space management is enabled.If the table is loacted in a tablespace on which manual segment space management is enabled,you cannot shrink the table.......【阅读全文】

阅读(686) | 评论(0) | 转发(0)

发布时间:2007-07-31 17:42:00

TIMESTAMP WITH TIME ZONE和TIMESTAMP WITH LOCAL TIME ZONE的实践理解.TIMESTAMP WITH LOCAL TIME ZONE会随着用户所在时区(SESSIONTIMEZONE)而变化,而TIMESTAMP WITH TIME ZONE则不随用户所在时区的变化而变,简单的说,这两个时间类型的参照时间不同,一个是参照用户的时区,一个是参照数据库的时区。[@more@]实践过程:1.建实践用表:SQL> DROP TABLE TIMESTAMP_TEST;表已删除。SQL> CREATE TABLE TIMESTAMP_TEST(2 TIME DATE,3 TIMESTP TIMESTAMP(3),4 TIMESTP_TZ TIMESTAMP(3) WITH TIME ZONE,5 TIMESTP_LTZ TIMESTAMP(3) WIT......【阅读全文】

阅读(543) | 评论(0) | 转发(0)

发布时间:2007-07-31 17:26:05

和张主任的谈话[@more@]今天张主任问我关于东二广播故障的问题,我对问题描述不是很清晰,感觉张主任似乎不是很满意,唉,没有给他一个好印象,不知道将来去开发部的事情会如何了。发现自己描述问题的能力真的很差,思路不是很清晰,什么都想说给别人听,没有把握住重点。8月2号还要和他去开会,顺道聊聊看吧。......【阅读全文】

阅读(226) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册