本月博客排行
-
第1名
龙儿筝 -
第2名
lerf -
第3名
fantaxy025025 - johnsmith9th
- xiangjie88
- zysnba
年度博客排行
-
第1名
青否云后端云 -
第2名
宏天软件 -
第3名
gashero - wy_19921005
- vipbooks
- benladeng5225
- e_e
- wallimn
- javashop
- ranbuijj
- fantaxy025025
- jickcai
- gengyun12
- zw7534313
- qepwqnp
- 解宜然
- ssydxa219
- zysnba
- sam123456gz
- sichunli_030
- arpenker
- tanling8334
- gaojingsong
- kaizi1992
- xpenxpen
- 龙儿筝
- jh108020
- wiseboyloves
- ganxueyun
- xyuma
- xiangjie88
- wangchen.ily
- Jameslyy
- luxurioust
- lemonhandsome
- mengjichen
- jbosscn
- zxq_2017
- lzyfn123
- nychen2000
- forestqqqq
- wjianwei666
- ajinn
- zhanjia
- Xeden
- hanbaohong
- java-007
- 喧嚣求静
- mwhgJava
- kingwell.leng
最新文章列表
Oracle11g手动创建数据库
Oracle11g数据库的手工创建
1、参考文档
Oracle11g Release 2 (11.2)
;
2、具体的创建步骤
2.1 指定一个实例ID,即SID
$ ORACLE_SID = orcl1
$ export ORACLE_SID
2.2 环境变量的设定
$ vi .bash_pro ...
HBase Shell 命令
This page describes the JRuby IRB-based HBase Shell. It replaces the SQL-like HQL, the Shell found in HBase versions 0.1.x and previous. Some discussion of new shell requirements can be found in the Sh ...
Eclipse出现failed to create the java virtual machine 错误解决办法
方法如下: 找到eclipse目录下的eclipse.ini,可以看到如下内容:-startupplugins/org.eclipse.equinox.launcher_1.1.0.v20100507.jar--launcher.libraryplugins/org.eclipse.equinox.launcher.win32.win32.x86_1.1.0.v20100503-productorg ...
如何在Oracle中复制表结构和表数据
1. 复制表结构及其数据:
create table table_name_new as select * from table_name_old
2. 只复制表结构:
create table table_name_new as select * from table_name_old where 1=2;
或者:
create table table_name_new like ...
Oracle创建表空间和用户
--创建表空间
create tablespace epet_tablespace
datafile 'E:\app\Administrator\oradata\coolick\coolick.dbf'
size 100M
autoextend on next 32M maxsize unlimited
logging
...
创建Element对象create
api的应用场景是:创建一个Element对象
关于ZYC.dom.g的资料:http://zhangyaochun.iteye.com/blog/1439262
关于ZYC.dom.setAttr的资料:http://zhangyaochun.iteye.com/blog/1461224
/*
*setAttrs-set the attribute value fo ...
创建同义词样例
create or replace procedure synonym_procedure
AS
i_count integer;
begin
select count(*) into i_count from user_objects t where t.OBJECT_TYPE ='SYNONYM' and t.OBJECT_NAME = upper('synonym_name');
...
创建sequence样例
create or replace procedure sequence_procedure
AS
i_count integer;
begin
select count(*) into i_count from user_objects t where t.OBJECT_TYPE ='SEQUENCE' and t.OBJECT_NAME = upper('sequence_name');
...
创建procedure样例
create or replace procedure procedure_procedure
AS
i_count integer;
begin
select count(*) into i_count from user_objects t where t.OBJECT_TYPE ='PROCEDURE' and t.OBJECT_NAME = upper('procedure_name') ...
创建package样例
create or replace procedure package_procedure
AS
i_count integer;
begin
select count(*) into i_count from user_objects t where t.OBJECT_TYPE ='PACKAGE' and t.OBJECT_NAME = upper('package_name');
...