付首昕 ORACLE 10 学习笔记 第3课 命令。
ORACLE 10 学习笔记-第3课-命令。
1.view 限制
create or replace view my_view01
as select * from emp
with check option
/
2.synonym 同义词
create synonym dept for scott.dept;
select * from dept;
3.sysdba 公共
drop synonym dept;
create public synonym dept for scott.dept;
desc dba_synonyms
4.sequence 序列
create sequence myseq
start with 1
increment by 1
order
nocycle;
select myseq.nextval from dual;
select myseq.currval from dual;
5.
desc dba_sequences
select sequence_name, sequence_owner from dba_sequences;
相关文档：
第一步
对数据库整体做了一个了解
$ORACLE_HOME/bin/sqlplus "sys/sys061201 as sysdba" << EOF
spool peiyz_healthcheck_info.txt
set linesize 200
set pagesize 1000
set time on
set timing on
col owner for a10
col segment_name for a30
col index_name for a30
col table_name for a ......
首先查找目标用户的当前进程：
select sid,serial# from v$session where username='ERP';
查询结果：
sid serial#
222 123
122 233
强行断开用户连接：
alter system kill session 'sid,serial';
例如：
alter system kill session '222,123';
......
在Oracle是提供了next_day求指定日期的下一个日期.
语法 : next_day( date, weekday )
date is used to find the next weekday.
weekday is a day of the week (ie: SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY)
可用于:
Oracle 9i, Oracle 10g, Oracle 11g
For example:
next_day('01- ......
1.绝对值
S:select abs(-1) value
O:select abs(-1) value from dual
2.取整(大)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.取整（小）
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.取整（截取）
S:select cast(-1.002 as int) value
O:selec ......
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 此处插入类型说明。
* 创建日期：(2001/11/30 14:55 ......
