向Oracle插入timestamp类型字段

oracle基础入门教材

建表
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
[default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
[default value] [prima ......

sql语句归纳（oracle）

对日常工作中用到的感觉有用的sql语句做个归纳，用于今后温故知新。
*复制表：
create table tablename as select * from table_src;
create table tablename as select * from table_src where 1 <> 1; --只复制表结构 ......

oracle RAC 底层进程介绍

1.GSD global services daemon
oracle官方文档的描述
The Global Services Daemon (GSD) runs on each node with one GSD process per node. The GSD coordinates with the cluster manager to receive requests from clients such as the DBCA, EM, and the SRVCTL utility to execute administrative ......

ORACLE查询出表中的字段列表

SELECT max(SYS_CONNECT_BY_PATH(COLUMN_NAME, ','))
  from (SELECT A.COLUMN_NAME, ROWNUM AS ROWNO
          from USER_TAB_COLUMNS A
         WHERE TABLE_NAME = 'A_USER'
     ......

ORACLE数据导入到指定的表空间

create user 用户名 identified by 密码 default tablespace 缺省表空间　Temporary tablespace 临时表空间;

grant connect,resource,dba to 用户名;
　　
revoke unlimited tablespace from 用户名;
　　
alter user 用户名 quota 0 on Users;

alter user 用户名　quot ......