Database Administrator

How Does Oracle limit the process of illegal package calling? How Does Oracle limit the process of illegal package calling? Assume that I have a package P_A, which encapsulates the important process DO_A.Another package P_ B needs to call P_A.DO_A

Oracle dump function DUMPSyntax DUMP (expr [, return_fmt[, Start_position [, length]]) Purpose DUMP returns a VARCHAR2 value containing the datatype code, length in bytes, and internal representation of expr. The returned result is always in the

Data Dictionary related to PL/SQL Sometimes, we encounter the following problems during PL/SQL development:1) What database objects does my program depend on?2) which package calls a subroutine or variable in another package?3) which of the

How to Delete more than 10 million normal heap table data from Oracle Database Delete Requirement: delete an Oracle database to delete 10 million historical records from a common heap table. Impact of direct deletion: 1. The deletion may fail due to

How to use Oracle External tables to import text file data Recently, colleagues are busy with Data Consistency comparison. They need to compare the data in different text files. Some files are large and have many records. If they are opened in a

MongoDB Series 4: MongoDB and Java Because of the different versions, the API may also be different. This tutorial uses version 3.0. 1. The jdbc driver version of mongodb used is: mongo-java-driver-3.0.0.jar 2. This section briefly introduces the

Entity misspelled names, lessons learned, and lessons learned from entity misspelled There was a problem in this project, but it was not a big problem...   In V3.0, we used Hibernate to map objects to databases. At that time, someone misspelled an

SQL table connection basic syntax and SQL connection basic syntax SQL connections can be divided into internal connections, external connections, and cross connections. 1. Inner join: the inner join query operation lists the data rows that match

Understanding the MySQL architecture of MySQL and the mysql ArchitectureCollationRecently, I have been busy with projects, working overtime, and launching projects, so I have no time to study. This is not the case. Just a few days ago, I took some

Oracle section 2nd filters and sorts data, oracle section 2nd LessonAim While retrieving data from the database, you may need to restrict the rows of data that are displayed or specify the order in which the rows are displayed. This lesson explains

MySQL database operation commands and mysql commands Note: MySQL databases are case-insensitive. 1. Create a database:Create database Thinkgamer; 2. delete a database:Drop database Thinkgamer; 3. Select a database:Use Thinkgamer; 4. Create a data

Oracle11g exp export problem: some tables cannot be exported, oracle11gexp An issue found during command exp export from oracle is that some tables cannot be completely exported. After checking, it is found that any blank table cannot be exported.

Common PostgreSQL Functions| String concatenationSyntaxString | stringExample'Post' | 'gresql' -- PostgreSQL is returned.Length () String lengthSyntaxLength (string)ExampleLength ('doo') -- returns 4LIKE pattern matchingSyntaxString LIKE

Differences between Mycat and MySQL -- the core function of Mycat, mycatmysql A friend was asked during the interview: What is the difference between Mycat and MySQL. We can regard the upper layer as an abstraction of the lower layer. For example,

[MySQL] (4) operation data table records, mysql DATA 1. INSERT record Method 1: INSERT [INTO] tbl_name [(clo_name,...)] {VALUES | VALUE} ({expr | DEFAULT },...), (...),...; For example: Create table users (id smallint unsigned primary key

SQL Injection and prevention, SQL Injection preventionSQL Injection: SQL Injection refers to inserting SQL commands into Web forms to submit or enter query strings for domain names or page requests. In this way, the server can finally execute

How to query duplicate data and delete duplicate records in Oracle For example, there is a personnel table (table name: peosons) drop table PERSONS; create table PERSONS (PNAME VARCHAR2 (50), CARDID VARCHAR2 (18), ADDRESS VARCHAR2 (100 )); insert

How to optimize NFS in Oracle databases ?, Nfs Optimization There are a lot of articles on MOS, which basically cannot run the following three points: Setup can make a big difference1. Network topology and load2. NFS mount options (select an

MySQL Study-MySQL common users cannot log on locally, mysql-mysqlMySQL Study-MySQL common users cannot log on locallyAfter installing MySQL, we usually add common users with corresponding permissions to access the database. When you log on to the

Redis Study Notes --- installation, redis Study Notes ---Introduction As more and more Internet companies begin to use Redis for practical projects, and many people have been discussing the architecture design of Redis, it is suitable for learning.