Oracle PHP JS 学习笔记

CREATE OR REPLACE PROCEDURE myproc(id IN varchar2) //in 输入参数 IS(AS) name varchar2(10); select books_name INTO name FROM books WHERE books_id=id; DBMS_OUPUT.PUT_LINE(name); END myproc;//MYPROC 可以不...

RMAN 基础 数据文件 日志文件 控制文件 参数文件 归档文件 .dbf 后缀名 可修改 归档模式 非归档模式 RMAN 必须是归档模式 非归档模式，RMAN是不能启动的 NLS_TERRYTORY NLS_LANGUAGE 字符集： Initialization Parameter  初始化参数是最高一次 Environment Variable 环境变量 -...

sys default password:change_on_install owner of the database data dictionarysystem default password:manager owner of additional view userd by oralce tools

CREATE SMALLFILE TABLESPACE  mytest DATAFILE 'd:\oracle\product\10.2.0\oradata\orcl10\mytest.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAG...

begin for i in 1000..1050 loop insert into student(id,name) values(i,i||'-小军'); end loop; end; /

CREATE OR REPLACE PROCEDURE MYPROC IS begin for i in 1000..1050 loop insert into student(id,name) values(i,i||'-小军'); end loop; end; /   SHOW ERRORS PROCEDURE myproc    

CREATE OR REPLACE VIEW myview AS SELECT * FROM books where price>50 WITH CHECK OPTION / CREATE OR REPLACE MYVIEW AS SELECT * FROM STUDENT  WHERE SCORE>=50 WITH READY ONLY / DESC DBA_VI...

TO_DATE格式(以时间:2007-11-02   13:45:25为例)            Year:              yy two digits 两位年                显示值:07         yyy three digits 三位年                显示值:007         yyyy four digits 四位年    ...