Database Administrator

Common Oracle ebs dba SQL-installation/patch Common Oracle ebs dba SQL-installation/patch Check whether the application patch is installed:Select bug_number, last_update_date from ad_bugs where bug_number = '& bug_num '; Check which languages are

Blob field value for accessing the Oracle Data Link Access photo table Select * from zp @ dblink1 where a1 = '201312 '; Error: The ora-22992 cannot use the LOB locator selected from the remote table Change to the following method: Method 1:Drop

Create partitions on the 11g virtual column of Oracle On Oracle 11g, partitions can be performed on virtual columns. This feature is useful. Let's perform a test: SQL> select * from v $ version; BANNER-------------------------------------------------

ORA-01861: Text and format strings do not match error handling An error is returned when the following materialized view is created.Create materialized view BBBRefresh complete on demandAsSelect a. vbillcode,B. invname,Del. exchdateFrom AA @ AAInner

Experience 30 -- create a user in sqlserver and create a user in sqlserver When it comes to database security issues, you should create a new user to connect to the database without using sa. 1. log on.2. Security-Logon Name-right-click Create

Database management system, database Today, I summarized database and drew two diagrams. The following describes the learning knowledge based on my diagram. Figure 1 Figure 2 1. The database lifecycle is divided into three major stages: planning,

WAS cluster series (8): cluster creation: Step 6: create a profile, cluster Overview(1) host resolution address Modification WAS Node 1, WAS Node 2, modify the hosts file under the Database Server Map the IP addresses of all hosts to various hosts

DbUtils database, dbutils Database1. What is O-R Mapping (Object-link ing) Commonly used O-R Mapping tools Hibernate (fully automated framework) Ibatis (semi-automatic framework/SQL) Commons dbutils (simple encapsulation of JDBC) There are also JPA

SQL advanced (10) function, sql10 FunctionSQL advanced (10) function the SQL GROUP BY statement is used in combination with the aggregate function to GROUP the result set based on one or more columns.SQL GROUP BY syntax SELECT column_name, aggregate_

C # ADO. NET Help class, Using System; using System. collections. generic; using System. linq; using System. text; using System. data; using System. data. sqlClient; namespace DBComm {static class DBCommand {public class DBParameters {private

An error occurred while querying all database tables in MySQL. An error occurred in the MySQL database table. 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: show tables error code: 1046No database selected

Kettle and kettleZookeeper Access the previous row of data in kettle In kettle, many users use the features of javascript steps when they need to access the first row of data in the data stream. In fact, it is not necessary to say that the

C3P0 database connection pool, Use the C3P0 database connection pool 1. Copy jar package: c3p0-0.9.1.2.jar c3p0-0.9.1.2-jdk1.3.jar c3p0-oracle-thin-extras-0.9.1.2.jar (oracle required) 2. Write the preparation file under the src directory:

Help! How to batch Delete the same segment of characters in a field in a database table !, Batch Delete How do I batch Delete AN01-1 strings in the Site_A field in a table? How does mysql batch remove the same part of strings under a field in a

SQL or HQL pre-compiled statements can prevent SQL injection, but cannot process % and _ special characters, hqlsql Recently, the project is working on rectification. It directly Concatenates the SQL string code of all DAO layers and converts it

UDE-00008 ORA-31626 ORA-06512 ORA-25254, ude-00008ora-31626 When exporting a mode today, it is about 140 GB and the following error occurs: UDE-00008: operation generated ORACLE error 31626ORA-31626: job does not existORA-06512: at "SYS. KUPC $

Simple MySQL database operations, mysql database operations For children who want to engage in or love mysql-related work, it is necessary to implement some simple operations on mysql under the command line. This article describes how to log on to

Summary of common grep usage and grep Grep-E 'l \ {2, \} '2.txt grep-E' h (ell | a) o 'test.txt grep '[a-z] \ {5, \} 'test.txt grep-xf a.txt B .txt // query the row grep-vxf B .txt a.txt that a and B exist together. // The row that queries a is not

WAS cluster series (1): unmount, was Cluster Note: The "arrow indicates" trajectory is "Click order", which is the effect after clicking Environment Project point Metrics WAS version 7.0 Operating System Windows 2

WAS cluster series (4): Cluster Construction: Step 2: Install was nd software, cluster nd Click Start Installation Wizard, as prompted: Step by step, click "Next" to install the SDK. Pay attention to the following steps: (1) The sample is not