Database Administrator

IT Ninja Turtles oracle stored procedure simple data extraction from ODS _ Object-oriented Thinking, oracleods Step 1: Create a package interface similar to the interface definition in java Create or replace PACKAGE pack_ SC _hmd_khIS --

[MongoDB] The high Query operation of MongoDB (1), mongodboperation In the last blog, we talked about the basic operation of MongoDB, including insert, query, remove and update. Now in this blog, we will further hava a good understanding of querying

Mysql development practice 8 Q: How many can you hold ?, MysqlholdRecently, the project has been heavily reliant on databases. I sorted out the eight representative questions that Mysql encountered during this period. The answers are also biased

Hibernate main configuration file attributes, The show_ SQL value is TRUE or FALSE. Indicates whether to display the executed SQL statement The value of format_ SQL is TRUE or FALSE. Whether to format the executed SQL statement The value of hbm2ddl

The last row of plsql cursor is duplicated.Let's take a closer look at the first Stored Procedure test01. Is there a problem? It seems that there is no problem, but it will actually cause repeated rows. test02 puts the exit when statement in the

Crsd. log: th_select_handler message repeated [ID 338693.1], handlermessage Crsd. log: th_select_handler message repeated [ID 338693.1]---------------------------Modified 29-JUL-2008 Type PROBLEM Status MODERATEDIn this

Hibernate operation Clob type data, hibernateclob type In POJO, a large String object can be declared as a java. lang. String or java. SQL. Clob type. When a program loads Clob data from a database, it only loads a logical pointer of Clob data. You

Oracle creates a tablespace and users to test it. oracle creates a tablespace. First, describe the table space as follows: Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed

SQL Server writes automatically-increasing string-type primary keys. SQL Server 1. Compile the scalar value function ICONVERT2STRING CREATE FUNCTION ICONVERT2STRING(@N INT,@F INT) RETURNS VARCHAR(10) ASBEGINDECLARE @M INTDECLARE @L0 INTDECLARE @CH

User 'nt AUTHORITY \ NETWORK service' Login Failed ., Authoritynetwork Step 1: Add 'nt AUTHORITY \ NETWORK Service' to the Administrator GroupMy computer --> right-click --> Manage --> local users and groupsSelect "group" --> double-click

Various Oracle backup terms, Oracle backup terms TermsFull database backup: includes all data files and at least one control file (remember that all control files in the database are the same) Partial database backup: It may include zero or multiple

MySQL basics-create databases and tables, mysql Databases MySQL basics-creating databases and tables Show database overview show databases; (SQL commands are case insensitive) Mysql> show databases; Database Information_schema Mysql Test

Implement data verification and check in kettle, and kettle implement data verification Implement data verification and check in kettle In ETL projects, input data usually cannot be consistent. There are some steps in kettle for data verification

Encrypting Goldengate Password, goldengateSpecify the user password in the OGG parameter file. In this case, we need to encrypt the password: [oracle @ ogg1 ogg] $ ls-l keygen-rwxr-x-1 oracle oinstall 327034 Apr 23 2012 keygen [oracle @ ogg1 ogg] $.

Summary of mysql Installation Problems and mysql Installation ProblemsWhen MYSQL is installed, cocould not start the service mysql error: 0 is processed.When you encounter the cocould not start the service mysqlerror: 0 error during installation and

Docker init started, dockerinit # Yum install WgetHttp://fedora.mirror.nexicom.net/epel/6/x86_64/epel-release-6-8.noarch.rpm Yum-y install epel-release-6-8.noarch.rpm Yum-y install docker-io # Wget install Yum install-y libcgroup lxc Service

Oracle Basic Data Change Principle Analysis (redo and undo) -- oracle Core Technology reader I, redo -- oracle In oracle, we have made some update operations. How does the bottom layer of oracle flow? This is what we will explain in this article.

Analysis of exists and in, analysis of existsin Exists and in do the same thing, so why do we need to get two more? It is actually a matter of efficiency. For example, the following two examples 1. select * from t1 where exists (select 'x' from t2

Oracle Performance Analysis 7: Use of indexes and oracle performance indexes This section describes how to use indexes. First, it describes how to avoid using indexes in queries, then how to determine whether the optimizer uses indexes, and how to

Oracle alter index disable/unusable, alterunusable Alter index index_name disable, enable for function indexes. SQL> create table test as select * from all_objects;SQL> create index ind_t_object_id on test (object_id) nologging; SQL> exec dbms_stats.