Object oriented property searching and binding method

1. Attribute search Class has two properties1. Data attribute: the data attribute of a class is shared by all objects2. Function attribute: the function attribute of a class is bound to an object, which is called the method bound to an object #!/usr/bin/env python # -*- coding:utf-8 -*- # Author: vita class Student: school = 'my_school' ...

Posted on Wed, 13 Nov 2019 12:33:01 -0500 by miasma

New feature of Oracle 12c -- LOGTIME parameter of data pump command

concept   The new LOGTIME command-line parameter available in Oracle Data Pump Export and Import allows you to request that messages displayed during export and import operations be timestamped. The valid values are: NONE - no timestamps on status or log file messages (same as the default) STATUS - timestamps on status mes ...

Posted on Mon, 11 Nov 2019 09:47:18 -0500 by LuiePL

(Sql server) create Sql Insert statement with data in existing table

Previously, a stored procedure for creating Sql statements of Insert with data in existing tables was published in Codeproject. Today, it is moved here. Note that this stored procedure is only applicable to SQL SERVER. introduce Sometimes, you want to export Sql scripts for records in existing tables so that you can insert the data into simil ...

Posted on Sat, 09 Nov 2019 15:43:26 -0500 by Warptweet

Export table structure to Excel export stored procedure, sequence, function script (sqlserver, mysql)

Hello, everyone Previously, I took over a project, and I was responsible for the interface development of backstage requirements. However, the customer only provides the test database server and prototype design, and lacks relevant documents. In terms of interface development, I have two points to make sure: one is to ...

Posted on Sat, 09 Nov 2019 10:41:57 -0500 by mark110384

Dynamic PivotTable

Write a perspective stored procedure that meets your requirements. During development, it can be used directly.   SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Insus.NET -- Create date: 2019-05-19 -- Update date: 2019-05-19 -- Description: Dynamic perspective ...

Posted on Fri, 08 Nov 2019 11:32:17 -0500 by mxdan

Repeated batch upload data processing

In this part, learn and practice SQL knowledge, and provide users to upload data in batches in the program. When uploading, there may be network interruption. Upload part of it and then upload again. There will be data duplication. Or how to modify or delete the original data in batches. Here is a simple example of Insus.NET. First, create a ...

Posted on Mon, 04 Nov 2019 11:33:26 -0500 by bagnallc

Realization of Web paging function

Whether it is website or APP paging function is essential. Why paging? 1. The loading speed is fast, which will not occupy too many resources of the server and reduce the pressure on the server. 2. Reduce database pressure. 3. Improve the user experience.   There are two common paging methods. 1. True paging: each page will read a small a ...

Posted on Mon, 04 Nov 2019 05:41:20 -0500 by trufla

The solution to the problem of PLS-00905 object is invalid, statement ignored in oracle PL/SQL stored procedure

Yesterday, while learning oracle stored procedures, I wrote a demo of stored procedures. The statement is as follows:   CREATE OR REPLACE PROCEDURE RAISESALARY(PNAME IN VARCHAR2(20)) AS psssal TESTDELETE.TESTID%TYPE; BEGIN SELECT TESTID INTO psssal FROM TESTDELETE WHERE TESTNAME=PNAME; UPDATE TESTDELETE SET TESTID=(TESTID ...

Posted on Fri, 01 Nov 2019 19:50:00 -0400 by vichiq

Continuous update of MySQL stored procedure tools -- field, index and other operations

The database uses many best written stored procedures that can be reused, so writing scripts according to different businesses can improve many efficiency. Routine business maintenance, upgrade, etc. that can be implemented without background coding do not need background code, because this kind of o ...

Posted on Thu, 31 Oct 2019 01:19:42 -0400 by siko

Database principle stored procedure and trigger

stored procedure A stored procedure is a collection of named SQL statements The collection is stored in the database after compilation and can be recompiled according to the actual situation. Stored procedures run on the server side and can also be called remotely on the client side Advantages of us ...

Posted on Sun, 27 Oct 2019 01:46:48 -0400 by NikLP