Detailed explanation of single line function operation in Oracle

Single line function -- PL/SQL (1) Character function Function number Say clearly  CONCAT Concatenate two strings, same as |  INITCAP Change the first letter of the string to uppercase  INSTR Find the position of a string  LENGTH Give the length of the string in characters   ...

Posted on Sun, 31 May 2020 08:55:23 -0700 by rushenas

[12c] new features: This article will give you a detailed understanding of the automatic data optimization (ADO) of Oracle 12c database

Write in front Oracle 12c can realize information lifecycle management (ILM) through heat map and automatic data optimization (ADO). The first chapter introduces heat map. This chapter will expand automatic data optimization, and finally realize information lifecycle management through heat map and automatic data optimization. 1 automatic d ...

Posted on Wed, 27 May 2020 04:47:19 -0700 by Karamja

Mysql_5.7 binary compile free installation

Mysql_5.7 and Mysql_5.6 large difference Mysql_5.7 installation steps 1. In the / usr/local/src directory, download the MySQL 64 bit package and extract it [root@dl-001 src]# wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz [root@dl-001 src]# tar zxvf mysql-5.7.17-linux-glibc ...

Posted on Sun, 24 May 2020 08:07:19 -0700 by JWitness

Mysql paging statement Limit usage

1. limit usage of Mysql When we use query statements, we often need to return the first few or some middle rows of data. What should we do at this time? never mind, mysql We have such a function. Sql code SELECT * FROM table LIMIT [offset,] rows | rows OFFSET offset The LIMIT clause can be used to force a SELECT statement to return the spec ...

Posted on Thu, 21 May 2020 01:00:12 -0700 by jpopuk

Explore Java 9 module system and reaction flow

Java 9 new features, Java modularization, Java reaction flow Reactive, Jigsaw catalog Modular system Module descriptor Modular application example Compile and execute Backward compatibility Reaction flow Flow class Internal implementation A simple application Application Processor API usage summary ...

Posted on Sun, 17 May 2020 21:08:21 -0700 by beachdaze

C ා data operation series - 5. Introduction to ef core

0. Preface The previous chapter introduced the ORM framework briefly, and wrote a tool class similar to orm. This chapter will introduce the Core version of Entity Framework, a famous ORM framework in the C ා world. The non Core version of Entity Framework has been updated to 6 generations, which is a proven ORM framework. Here is a brief intro ...

Posted on Thu, 14 May 2020 03:05:51 -0700 by rebelo

Getting Started with Spring Boot: Integrate Hasor's Dataway module, wipe out the background, and automatically configure interfaces

Finally out of Hubei, closed for 2 months, no computer at home, feel independently code Ah Ah Ah Ah Ah Ah Ah Ah Ah Ah. Connect to previous article Getting Started with Spring Boot (12): Report Export, Comparing the Efficiency of poi, jxl, and esayExcel Continue from the beginning to the pit. dataWay is just open source, you can go to the offici ...

Posted on Wed, 13 May 2020 11:00:31 -0700 by matt1

Oracle TNS 314 Protocol Analysis-5, Error Return

* Error message return process (take SQL errors for example) Client       Server 1 ------- Data Piggyback(11) Cursor Close All(69) Or 03 5e -----> Specific statements 2 <----- Marker(0C) ------- Return to Marker 3 <----- Marker(0C) ------- Return to Marker 4 ------- Marker(0C) - ...

Posted on Sun, 10 May 2020 11:43:31 -0700 by sergeidave

015. Class loading mechanism

1. Runtime data area The JVM is used to store loaded class information, constants, static variables, compiled code and other data. This is a logical partition in the virtual machine specification. The specific implementation is based on different virtual machines. For example, oracle's HotSpot is placed in the permanent generation in java7, ...

Posted on Wed, 06 May 2020 22:02:52 -0700 by reinaldo

Common SQL statements of oracle

1. Merge a field (multiple documents) of a table into a string output (comma separated)   + ",(select LISTAGG(mo.model_code,',') within group(order by mo.model_code) from srm_pos_resource_model mo where mo.supplier_id=t.supplier_id) modelCodeList\n" 2. Query the latest document according to a field in the table   -according to su ...

Posted on Wed, 06 May 2020 07:37:41 -0700 by sspatel82