M_ZONE125的专栏

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表..

使用管理员用户名密码登陆数据库create user TestOracle IDENTIFIED by Mu3131556;   //创建用户    用户名：TestOracle，密码：Mu3131556grant create SESSION to TestOracle;                //授予登陆权限grant create TABLESPACE to TestOrac...

//自增队列出发器create sequence VerticalSecData_seq start with 1 increment by 1;   create or replace trigger VerticalSecData_trigger       before insert on VerticalSecData       for each row       begin...

//创建表CREATE TABLE TestSpatial (    ID VARCHAR2(20) NOT NULL,    NAME VARCHAR2(100),    ADDRESS VARCHAR2(200),    TELEPHONE VARCHAR2(50),     LOCATION  SDO_GEOMETRY);//插入数据INSERT INTO TestS...

//快速生成用户下所有表delete 语句SELECT 'DELETE FROM '|| table_name || ';' FROM USER_TABLES//执行结果DELETE FROM PARKSPACE;DELETE FROM PARKSPACEDATA;DELETE FROM PIER;DELETE FROM PROTECTEDPIER;DELETE FROM REDLI...

MSDAORA方式插入中文时有乱码；