Single line function -- PL/SQL
(1) Character function
Concatenate two strings, same as |
Change the first letter of the string to uppercase
Find the position of a string
Give the length of the string in characters
Posted on Sun, 31 May 2020 08:55:23 -0700 by rushenas
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 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
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.
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
Java 9 new features, Java modularization, Java reaction flow Reactive, Jigsaw
Modular application example
Compile and execute
A simple application
Posted on Sun, 17 May 2020 21:08:21 -0700 by beachdaze
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
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
* Error message return process (take SQL errors for example)
Data Piggyback(11) Cursor Close All(69)
Or 03 5e
Return to Marker
Return to Marker
Posted on Sun, 10 May 2020 11:43:31 -0700 by sergeidave
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
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