Programmer Think

Someone at the interface came to me and said that there was a stored procedure that couldn't run and tried to report errors several times. ORA-12801: Error signal in parallel query server p001, instance xx ORA-04030: Insufficient process memory when attempting to allocate 16328 bytes (xxxx) It also monitors the receipt of spatially increasi ...

1. Index: Two new tables, T1 and T2, are created as follows: When both tables are queried the same way, the T1 table uses an index, but the T2 table does not scan the full table. select * from t1 where id=10; select * from t2 where id=10; This is mainly because the values of the clustering factor in the T1 table ...

Contents of this article:1.update statement2.delete statement　2.1 Form Delete　2.2 Multi-table Deletion3.truncate table 1.update statement update is used to modify records in a table. # Form update syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference [PARTITION (partition_list)] SET col1={expr1|DEFAULT} [,col2={expr2|DEFAULT}] ...

1.SQL protocol 1. Statute of Forms Required three fields: create table `demo` ( `id` bigint(32) not null auto_increment comment 'Primary key', `gmt_create` timestamp not null default current_timestamp comment 'Active Creation Time', `gmt_modified` timestamp not null default current_timestamp on update current_timestamp comment 'Passiv ...

Today, Zhongshan company lets the dispatching arrangement batch be seen remotely, because it is the same source program, making the formal library will not report errors, making the test library will report errors, thinking of the problem of data or database settings, so it debugs the source program, and the program will report errors when it c ...

The Java 8 API adds a new abstraction called Stream, which allows you to process data in a declarative manner. Stream provides a high-order abstraction of Java set operations and expressions using an intuitive way similar to querying data from a database with SQL statements. Stream API can greatly improve the productivity of Java program ...

Label PostgreSQL, imgsmlr, GiST, image eigenvalues, wavelet transform background Continued "PostgreSQL 11 Similar Image Search Plug-in imgsmlr Performance Test 1 - Single Table (400 million images)" Parallel invocation using partition table + dblink asynchronous interface. (It's better to support imgsmlr gist index scan directly at ...

Preface Previous article: Use of Spring-jdbc and 8 ways of managing Spring transactions (declarative + programmatic) Introduces many ways to use Spring transactions, including when it comes to the full comment @Transactional approach, so this article takes the @Transactional approach as a starting point to unravel the mystery of Spring ...

Preface PostgreSQL is an open source object relational database management system (ORDBMS). This paper aims to introduce some basic operations of PostgreSQL (hereinafter referred to as pg) for beginners'reference and reference. It should be noted that all the following operations were performed in Ubuntu 16.04, using version 9.6 of PG. For diff ...

In the form of merge into: MERGE INTO [target-table] A USING [source-table sql] B ON([conditional expression] and [...]...)   WHEN MATCHED THEN       [UPDATE sql]   WHEN NOT MATCHED THEN       [INSERT sql]   Function: To judge whether table B and table A meet the conditions of ON, if they are satisfied, update table A with table B, if not ...