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
# -*- coding:utf-8 -*-
# Author: vita
school = 'my_school' ...
Posted on Wed, 13 Nov 2019 12:33:01 -0500 by miasma
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
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.
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
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
Write a perspective stored procedure that meets your requirements. During development, it can be used directly.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
-- 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
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
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
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))
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
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
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