View View (View) is a virtual table. The data in the view does not actually exist in the database. The row and column data come from the tables used in the query of the custom view and are dynamically generated when the view is used. The view value saves the SQL logic of the query […]
Tag: procedure
Windows window procedure
1. Window class (WNDCLASS) Definition: A window class is a set of attributes and a template used to create windows in Windows programming. The window class contains the data structure of various information about the window. Each window has a window class, and each window creates a window based on its own window class. Each […]
[MySQL]Views, stored procedures, triggers
Article directory 1. View 1.1 Basic operations of views 1.2 Inspection options for views 1.3 View update 2. Stored procedures 2.1 Basic syntax of stored procedures 2.2 Variables 2.2.1 System variables 2.2.2 User-defined variables 2.2.3 Local variables 2.3 Keywords 2.3.1 Judgment 2.3.2 Loop 2.4 Cursor 2.5 Stored functions 3. Trigger 1. View A view is […]
SpringBoot calls stored procedures (input parameters, return parameters) (personal test works!!!)
There is a difference between stored procedures and functions! ! ! Create functions, just for demonstration, the following functions are incomplete! ! ! (Just look at the P_xxx parameters) CREATE OR REPLACE PROCEDURE SP_TICKET_CHECKE_ONLINE_TEST (p_transcode IN OUT VARCHAR2, p_ip IN OUT VARCHAR2, p_barcode VARCHAR2, p_managercard VARCHAR2, p_checkdatetime VARCHAR2, p_haspic OUT VARCHAR2, p_rescode OUT VARCHAR2, p_resmsg […]
Use annotations to call the stored procedures of Oracle database;
Table of Contents Project creation Overall project structure stored procedure Configuration items Return result type *Write the dao layer [key to this blog] service implementation layer control layer Test the interface and debug it Project creation Use spring’s official initialization tool spring initializr (website is https://start.spring.io/) to create a springboot project (You can also use […]
SQL/stored procedures and functions
Stored procedures and functions #Stored procedures and functions /* Stored procedures and functions: similar to methods in java benefit: 1. Improve code reusability 2. Simplify operations */ ### Stored procedure /* Meaning: a set of pre-compiled SQL statements, understood as batch statements benefit: 1. Improve code reusability 2. Simplified operation 3. Reduce the number of […]
Mysql advanced statements (view tables, stored procedures, conditional statements, loop statements)
Mysql advanced statements (view tables, stored procedures, conditional statements, loop statements) 1. CREATE VIEW (view) 1.1. Overview of view table 1.2. Can the view table be modified? (Interview question) 1.3. Basic syntax 1.3.1. Create 1.3.2. View 1.3.3. Delete 1.4. Find non-intersection values through view tables 2. case statement 3. The difference between null value (null) […]
MySQL forces the use of two methods of indexing and optimizes the index, and uses MySQL stored procedures to create test data.
1. Two ways for MySQL to force the use of indexes 1. Use the FORCE INDEX statement: explain select * from tbl_test force index (index_item_code) where (item_code between 1 and 1000) and (random between 50000 and 1000000) order by random limit 1; Use FORCE INDEX (index name) to index: 2. Use the USE INDEX statement: […]
MySQL advanced statements Part2 (view table + stored procedure + conditional statement + loop statement)
Write the directory title here 1. View table create view 1.1 Overview of view tables 1.2 Can the view table be modified? (Interview question) 1.3 Basic syntax 1.3.1 Create 1.3.2 View 1.3.3 Delete 1.4 Find non-intersection values through view tables 2. case statement 3. The difference between null value (null) and no value (‘ ‘) […]
Two stored procedures related to JLBANK-IRS statistical reports
1. Debt rating statistical report CREATE OR REPLACE PROCEDURE SP_DEBT_RATING_RESULT_QUERY( P_RATING_TIME VARCHAR2, P_ORGSEQ VARCHAR2, P_SMALL_CORP_LOAN_CD VARCHAR2, P_CUR OUT IRS_REF.T_CURSOR) AS V_ORGSEQ VARCHAR2(12) := NVL(P_ORGSEQ,’99999′); V_SMALL_CORP_LOAN_CD VARCHAR2(12) := NVL(P_SMALL_CORP_LOAN_CD,’!’); BEGIN /****************************************************** **********************/ /****************Construct a new customer information table************************************ **********/ /****************************************************** **********************/ –Get the latest records from the customer table INSERT INTO T_CUSTOMER_NEWEST SELECT A.POINT_CMIS_ID FROM CUSTOMER […]