Example Summary of Oracle Knowledge Points

Article Directory Oracle Knowledge Points Tablespaces, users, roles Tablespace Getting relationships between tablespaces and data files View data block size Query information about tables owned by the current user, accessible tables, and all tables in the current database Query information for all tables ...

Posted on Sun, 10 May 2020 00:00:11 -0700 by sheila

SQL efficient paging (millions of data)

Row | number() over (order by ID) | paging SELECT TOP Page size * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM table1 ) as A WHERE RowNumber > Page size*(Current page-1) --Note: use first Row_number()by table1 Add a row number to each row of the table, a ...

Posted on Fri, 01 May 2020 07:22:56 -0700 by watthehell

Summary of database stored procedures

stored procedure 1: Create stored procedure create proc stu_proc1 as select count(*) from student exec stu_proc1 implement 2: Modify, delete, rename alter proc stu_proc1 as select * from student drop proc stu_proc1 as select * from student rename proc stu_proc1 as select * from student 3: Parameter stored pro ...

Posted on Sat, 18 Apr 2020 10:08:18 -0700 by napier_matt

prepare usage of MySQL

MySQL officially refers to prepare, execute and deallocate as PREPARE STATEMENT, which is used to be called preprocessing statement. The following is a detailed introduction. Sample code PREPARE stmt_name FROM preparable_stmt EXECUTE stmt_name [USING @var_name [, @var_name] ...] - {DEALLOCATE | DROP} PREPARE stmt_name   Here's a chestnut ...

Posted on Sun, 05 Apr 2020 01:42:57 -0700 by dsinghldh

When a new data is inserted into the local database (sql server), it is synchronized to the server database

One of my classmates asked me how to synchronize the local database to the server when inserting new data. At that time, I first thought about the program logic control and corresponding processing. But sometimes our program is not easy to deal with. Can we start from the database? Isn't there a trigger in the database? It should be OK. Let's d ...

Posted on Sat, 04 Apr 2020 04:39:41 -0700 by Katanius

Nutz calls stored procedure

Nutz calls stored procedure Recently, a colleague asked me how Nutz calls stored procedures. Originally, Nutz's documents are super mature, so reading documents can solve the problem,,, Nutz is an alternative to SSH for Java programmers. Of course, it's open source and completely free. Light - the latest version, 910kB in to ...

Posted on Tue, 31 Mar 2020 22:59:39 -0700 by RickChase

. NET execute SQL performance optimization I: execute SQL statements in batches for SQL Server

This paper introduces several techniques for executing multiple SQL statements with one SqlCommand. introduce One of the functions that are often ignored in data storage of SQL Server using ADO.NET is that it can execute multiple SQL statements SqlCommand with a single statement. In general, programs execute statements and / or call stored pro ...

Posted on Sun, 29 Mar 2020 10:12:46 -0700 by csueiras

MySQL must know must know 19-23 chapters

Chapter 19-23 The nineteenth chapter INSERT is used to INSERT (or add) rows to database tables. There are several ways ·Insert full row ·Insert part of row ·Insert multiple rows ·Insert results of some queries MySQL security can be used for each table or user to prohibit ...

Posted on Mon, 24 Feb 2020 03:02:21 -0800 by sathyan

Mybatis source learning (27) - Executor in mybatis

I. Introduction           is one of the most core interfaces of Mybatis. Among them, the functions in the SqlSession interface are based on the exciter. //DefaultSqlSession.java @Override public void select(String statement, Object parameter, RowBoun ...

Posted on Wed, 19 Feb 2020 19:29:20 -0800 by bigsid

SQL Server SELECT enters the existing table

I tried to select some fields from a table and insert them from the stored procedure into the existing table. This is what I'm trying: SELECT col1, col2 INTO dbo.TableTwo FROM dbo.TableOne WHERE col3 LIKE @search_key I think select... Into... Is a temporary table, which is why I get the error that dbo.TableTwo already exists. How to ...

Posted on Tue, 18 Feb 2020 21:59:18 -0800 by michaeru