Oracle complex query

Preparation: start two services of Oracle - database instance service and monitoring service     1, Basic table - department table and employee table 1. sector table drop table dep; create table dep( d_id varchar2(11) primary key not null, d_name varchar2(50) not null, d_remark varchar2(20 ...

Posted on Sun, 23 Feb 2020 03:34:58 -0500 by dennissanche

The second part of common API for Java se foundation strengthening

Summary (1) Object class(two) class Date(3) Calendar Class(4) System class(5) StringBuilder class(6) Basic type packaging (1) Object class demo01: Summary The java.lang.Object class is the root class in the Java language, that is, the parent class of all classes. All method subclasses describ ...

Posted on Sun, 23 Feb 2020 03:09:06 -0500 by burhankhan

[str string built-in function] from python

String built-in function – capitalize str.capitalize(): converts a string to uppercase and other letters to lowercase capitalize meaning capitalize(...) | S.capitalize() -> str #Output is a string | | Return a capitalized version of S, i.e. make the first charact ...

Posted on Sun, 23 Feb 2020 03:00:33 -0500 by bigdaddykraven

WHERE clause - filter data

Chapter 6 filtering data Article directory Chapter 6 filtering data 1. Use WHERE clause 2. WHERE clause operator 2.1 check single value 2.2. Mismatch check 2.3 range value inspection 2.4. Null value check 3, summary Simple record - MySQL must know must know - [English] Ben Forta Learn how to u ...

Posted on Sun, 23 Feb 2020 02:38:23 -0500 by fahhem

Ffmpeg video filter fat test process introduction

Fat (FFmpeg automated testing environment) is an automated testing framework developed by FFmpeg community. It supports the testing of FFmpeg API and FFmpeg internal functions. The test of FFmpeg video filter belongs to the test of API. In order to add a fast test to a video filter, I have studied it fo ...

Posted on Sun, 23 Feb 2020 02:31:10 -0500 by eugene2008

The basic operation of Pandas in excel

0x01 background Recently, I helped someone to deal with financial related excel forms. By the way, I learned how to deal with Excel in panda, which is summarized as follows. I hope it can be used directly later. The biggest feeling is that python deals with Excel, which is a blow to reduce the dimension of Excel formula. 0x02 operation 2.1 ...

Posted on Sun, 23 Feb 2020 01:56:25 -0500 by Kookedoh

A simple explanation of the implementation of pure linked list in Linux kernel in C language

A simple explanation of the implementation of pure linked list in Linux kernel in C language Various types of linked list are widely used in the operating system. As one of the most important data structures of the operating system, linked list is the cornerstone of the operating system. In the Linux ...

Posted on Sun, 23 Feb 2020 01:38:22 -0500 by galvin

Getting started with Delta Lake with Jupiter Notebook

The example of this article comes from Delta Lake Official course . Because the official tutorial is based on the commercial software Databricks Community Edition. Although the software features used in the tutorial are all possessed by the open-source Delta Lake version, considering the domestic network environment, the threshold for register ...

Posted on Sun, 23 Feb 2020 00:35:26 -0500 by GroundZeroStudios

13. The use of interceptors in SpringBoot

1.1 defining interceptors To define an interceptor, you only need to implement the HandlerInterceptor interface, which is provided by all custom interceptors or Spring Boot The ancestor of interceptor, so let's first understand the interface. There are three methods in the interface: preHandle, postHandle and afterCompletion 1) preHandle meth ...

Posted on Sun, 23 Feb 2020 00:05:37 -0500 by artic

CTFHub Boolean blind note

CTFHub Boolean blind note The topic has been shown to be Boolean blind. It is found that it is not closed, but also filtered. It is also a basic problem, but it is found that the echo is not right: payload:?id=1 and 's'='p'Echo is query < success This problem is different from the common Boolean bl ...

Posted on Sat, 22 Feb 2020 22:57:42 -0500 by Toxinhead