9 李明

瀚高基础软件股份有限公司 - 技术支持/维护工程师

我要认证

前行路上的我,期待不一样的精彩。

等级
TA的排名 2k+

DBMS error [ORA-20005: Invalid (NULL) Lob locator (points).

在实时增量同步GIS数据的时候,使用了gis相关函数解析gis数据,在抽取端,报错如下:DBMS error [ORA-20005: Invalid (NULL) Lob locator (points). ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 204 ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 104].此为相关BUG,可以使用如下配置解决此问题:SELECT CASE...

2020-08-10 23:28:27

SQL Server周期性备份某一张表

需求:在MS SQL Server数据库中,周期性备份某一张表,用作备份及查看数据。处理:通过SQL Server自带的代理实现。步骤:1. 代理右键->新建->作业2. 在弹出对话框中,常规选项卡命名、选择类别及添加适当说明:3. 在步骤选项卡,点击新建,在对话框中,命名步骤,选取数据库,并填写相应的SQL语句:此处的SQL语句文本为:注:备份表根据表名+备份时间点命名declare @tblname varchar(200),@createtab

2020-07-17 13:56:41

GIS基础

GIS:geographicinformationsystem,地理信息系统是对地理空间信息进行描述、采集、处理、存储、管理、分析和应用的一门交叉学科。美国ESRI公司推出的ArcGis地理信息系统平台是最具代表性的GIS软件平台。一个完整的地理信息系统主要由四个部分构成,即硬件系统、软件系统、地理空间数据和系统管理操作人员。不同用途的GIS,其地理空间数据的种类...

2020-04-20 15:19:04

PostgreSQL usermanual翻译暂停20200420

因工作需要加快pg usermanual的阅读速度,故今日起暂停翻译,待阅读完成后有时间再继续进行翻译。感谢关注。

2020-04-20 15:17:50

Python是什么

Python是一种面向对象的解释性高级编程语言,具有动态语义。虽然Python的速度可能没有C、C++等编译型语言那么快,但它能够节省编程时间。官方网站:www.python.orgPython提供自带推行交互编译器:IDLE启动python:在命令行执行命令: pythonPython中,除法的时候是小数,如果想要整除运算(丢弃小数部分,而不是四...

2020-04-02 09:34:58

9.7.2. SIMILAR TO Regular Expressions

9.7.2. SIMILAR TO Regular Expressions9.7.2.SIMILAR TO正则表达式string SIMILAR TO pattern [ESCAPE escape-character]string NOT SIMILAR TO pattern [ESCAPE escape-character]The SIMILAR TO ope...

2020-03-24 11:14:22

9.7.1. LIKE

9.7.1. LIKE9.7.1. LIKEstring LIKE pattern [ESCAPE escape-character]string NOT LIKE pattern [ESCAPE escape-character]The LIKE expression returns true if the string matches the supplie...

2020-03-24 10:45:29

9.7. Pattern Matching

9.7. Pattern Matching9.7. 模式匹配There are three separate approaches to pattern matching provided by PostgreSQL: the traditional SQLLIKE operator, the more recent SIMILAR TO operator (added in SQL:1...

2020-03-24 09:54:12

9.6. Bit String Functions and Operators

9.6. Bit String Functions and Operators9.6.位串函数和操作符This section describes functions and operators for examining and manipulating bit strings, that isvalues of the typesbitandbit varying. Aside...

2020-03-23 11:07:33

9.5. Binary String Functions and Operators

9.5. Binary String Functions and Operators9.5.二进制字符串函数和运算符This section describes functions and operators for examining and manipulating values of type bytea.本节介绍了用于检查和操作bytea类型的值的函数和运算符。SQL...

2020-03-19 16:47:55

9.4.1. format

9.4.1.format9.4.1.formatThe functionformatproduces output formatted according to a format string, in a style similar tothe C functionsprintf.函数format产生的输出根据格式字符串格式化,格式类似于C函数sprintf。...

2020-03-19 16:36:56

9.4. String Functions and Operators

9.4. String Functions and Operators9.4.字符串函数和运算符This section describes functions and operators for examining and manipulating string values. Stringsin this context include values of the types cha...

2020-03-19 15:30:33

9.3. Mathematical Functions and Operators

9.3. Mathematical Functions and Operators9.3.数学函数和运算符Mathematical operators are provided for many PostgreSQL types. For types without standard mathematicalconventions (e.g., date/time types) we d...

2020-03-19 10:41:11

9.2. Comparison Functions and Operators

9.2. Comparison Functions and Operators9.2.比较函数和运算符The usual comparison operators are available, as shown in Table 9.1.常用的比较运算符可用,如表9.1所示。转存失败重新上传取消转存失败重新上传取消Note注The!=operator is c...

2020-03-19 10:11:22

9.1. Logical Operators

9.1. Logical Operators9.1.逻辑运算符The usual logical operators are available:常用的逻辑运算符均可用:ANDORNOTSQL uses a three-valued logic system with true, false, and null, which represents “...

2020-03-19 09:12:58

9. Functions and Operators

Chapter 9. Functions and Operators第九章.函数和操作符PostgreSQL provides a large number of functions and operators for the built-in data types. Users canalso define their own functions and operators, as d...

2020-03-19 09:04:57

8.21. Pseudo-Types

8.21. Pseudo-Types8.21.伪类型The PostgreSQL type system contains a number of special-purpose entries that are collectively calledpseudo-types. A pseudo-type cannot be used as a column data type, but...

2020-03-18 16:15:49

8.20. pg_lsn Type

8.20. pg_lsn Type8.20.pg_lsn类型The pg_lsn data type can be used to store LSN (Log Sequence Number) data which is a pointer toa location in the WAL. This type is a representation of XLogRecPtr and ...

2020-03-18 15:57:39

8.19. Object Identifier Types

8.19. Object Identifier Types8.19.对象标识类型Object identifiers (OIDs) are used internally by PostgreSQL as primary keys for various system tables.OIDs are not added to user-created tables, unlessWIT...

2020-03-18 15:45:17

8.18. Domain Types

8.18. Domain Types8.18.域类型A domain is a user-defined data type that is based on another underlying type. Optionally, it can haveconstraints that restrict its valid values to a subset of what the ...

2020-03-18 14:59:10

查看更多

CSDN身份
  • 博客专家
勋章 我的勋章
  • 签到新秀
    签到新秀
    累计签到获取,不积跬步,无以至千里,继续坚持!
  • 专栏达人
    专栏达人
    授予成功创建个人博客专栏的用户。专栏中添加五篇以上博文即可点亮!撰写博客专栏浓缩技术精华,专栏达人就是你!
  • 持之以恒
    持之以恒
    授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里,不积小流无以成江海,程序人生的精彩需要坚持不懈地积累!
  • 勤写标兵Lv4
    勤写标兵Lv4
    授予每个自然周发布9篇以上(包括9篇)原创IT博文的用户。本勋章将于次周周三上午根据用户上周的博文发布情况由系统自动颁发。