简单就好-怒的博客

整理Centos 8中安装Oracle12c（单机）的命令整理，环境配置好，启动runInstaller.sh，界面安装方式跟Windows一样一、网络配置网络cat /etc/sysconfig/network-scripts/ifcfg-eth0BOOTPROTO=staticBROADCAST=192.168.139.255IPADDR=192.168.1.233NETMASK=255.255.255.0NETGETWAY=192.168.1.1ONBOOT=yes重启网络

存储过程create or replace procedure lcd(lid in number,lname out varchar2) aslock_handler varchar2(128);request_ number;release_ number;begin dbms_lock.allocate_unique('tlcd',lock_handler,3600);

select * from tt as of timestamp to_date('2016-2-15 10:07:00','yyyy-MM-dd HH24:mi:ss')     --查询某个时间点的数据alter table tt enable row movement；--更改行级移动flashback table tt to timestamp to_date('2016-2-

create table dep( deptno varchar2(50) primary key, deptname varchar2(50));insert into dep values ('1','人事部');insert into dep values ('2','技术部');insert into dep values ('3','采购部');commit;cr

create tablespace MyTableSpaceTest datafile 'F:\llccdd2016-8-3\test\mytest_off1.dbf' size 1048K autoextend off;   --创建表空间，数据文件，大小1048K，不自动增长alter tablespace MyTableSpaceTest add datafile 'F:\llccdd2

select * from (select round(10.38764,3) round from dual),(select trunc(10.38764,3) trunc from dual),(select to_char(sysdate,'yyyy-MM-dd hh24:mi:ss') to_char from dual),(select to_date('2000-1-1 1