![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
文章平均质量分 55
穆天涯子
这个作者很懒,什么都没留下…
展开
-
SQL中内联方式查询
select a.TestItems,a.TestItemsName,a.TestCarTrackDataAddr,a.TestCarName from VirtualVerificationTree as a inner join select b.TestItem from VirtualVerificationNode as b on a.TestItems=b.TestItems查询获得的结果集为VirtualVerificationTree与VirtualVerificationNode表..原创 2021-03-30 13:57:02 · 190 阅读 · 0 评论 -
数据库用户权限分配
使用管理员用户名密码登陆数据库create user TestOracle IDENTIFIED by Mu3131556; //创建用户 用户名:TestOracle,密码:Mu3131556grant create SESSION to TestOracle; //授予登陆权限grant create TABLESPACE to TestOrac...转载 2018-07-31 21:44:56 · 2088 阅读 · 0 评论 -
Oracle中自增队列、触发器、存储过程
//自增队列出发器create sequence VerticalSecData_seq start with 1 increment by 1; create or replace trigger VerticalSecData_trigger before insert on VerticalSecData for each row begin...原创 2018-07-31 21:58:39 · 549 阅读 · 0 评论 -
Oracle中空间字段创建索引
//创建表CREATE TABLE TestSpatial ( ID VARCHAR2(20) NOT NULL, NAME VARCHAR2(100), ADDRESS VARCHAR2(200), TELEPHONE VARCHAR2(50), LOCATION SDO_GEOMETRY);//插入数据INSERT INTO TestS...转载 2018-08-12 13:28:30 · 1682 阅读 · 0 评论 -
Oracle中快速生成所有表、触发器删除语句
//快速生成用户下所有表delete 语句SELECT 'DELETE FROM '|| table_name || ';' FROM USER_TABLES//执行结果DELETE FROM PARKSPACE;DELETE FROM PARKSPACEDATA;DELETE FROM PIER;DELETE FROM PROTECTEDPIER;DELETE FROM REDLI...转载 2018-08-12 13:34:16 · 1174 阅读 · 0 评论 -
C++ADO连接Oracle连接字符串选择
MSDAORA方式插入中文时有乱码;原创 2018-08-12 14:10:06 · 1010 阅读 · 0 评论