oracle使用
ylm-sigmund
这个作者很懒,什么都没留下…
展开
-
Oracle start with 存储树状结构
建表语句create table priortest( id NUMBER not null, fatherid NUMBER, name varchar2(4000) not null);insert into priortest (ID, FATHERID, NAME)values ('1000', null, '一级分组');insert into priortest (ID, FATHERID, NAME)values ('1001', '1000', '原创 2020-12-24 21:00:14 · 235 阅读 · 0 评论 -
Oracle批处理insert性能比较
github地址建表语句create table TESTBATCH( userid NUMBER not null, username VARCHAR2(4000), age NUMBER, phone NUMBER, currencyone VARCHAR2(4000), countone NUMBER, currencytwo VARCHAR2(4000), counttwo NUMBER, create原创 2020-12-11 00:04:53 · 936 阅读 · 0 评论 -
Oracle 行转列,列转行 11.2.0.4
字段拼接成字符串SELECT userid||username FROM manager;SELECT concat(userid,username) FROM manager;字符串转多行SELECT '1' FROM dual union all SELECT '2' FROM dual;列转行 wm_concat()drop table test;create table test(id number,username varchar2(20));insert into test原创 2020-10-10 21:02:54 · 172 阅读 · 0 评论 -
Oracle存储过程
建表语句create table manager(userid number not null primary key,username varchar2(4000) not null,age number not null,phone number not null );for循环入表测试数据--1、声明ylm_managercreate or replace procedure ylm_manager(startIndex in number,原创 2020-09-13 23:25:54 · 162 阅读 · 1 评论 -
spring-boot 2.3.3.RELEASE 整合oracle、mysql多数据源
pom文件<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven原创 2020-08-19 23:45:33 · 687 阅读 · 0 评论 -
oracle创建表空间、用户
sysdba连接上oralce创建临时表空间,名称是web_temp注意tablespace、tempfileselect name from v$tempfile;--查出当前数据库临时表空间,下面创建临时表空间会使用里面的存放路径;/opt/oracle/oradata/orcl/temp01.dbf[oracle@ylm-100 ~]$ cd /opt/oracle/oradata/orcl[oracle@ylm-100 orcl]$ lltotal 2103560-rw-r.原创 2020-08-11 21:50:35 · 95 阅读 · 0 评论