Database Administrator

An example of ORA-28547 Fault Handling Last week to the customer training Oracle, talked about the DG part of the actual configuration demonstration, encountered a ORA-28547 fault, the customer database 11.2.0.1 version, Window platform. Previously,

Hive UDF, UDTF, and UDAF This topic describes the basic knowledge of Hive udfs, UDTF, and UDAF. To get started, first create a table "apache_log" in Hive" Create table apachelog (Host STRING,Identity STRING,User STRING,Time STRING,Request

MongoDB 4.0 is expected to support cross-document transactions Since MongoDB acquired WiredTiger and its relational database storage engine, many technical experts have been waiting for MongoDB to provide support for multi-document transaction.

Oracle index organization table I learned how to index organizational tables in Oracle today. Through this article, you can understand what is an index Organizational table? Under what circumstances can I use the index organization? What are the

MySQL database Optimization How should we optimize the MySQL database? Next I will explain this problem from MySQL's hardware selection, MySQL installation, my. cnf optimization, MySQL architecture design, and data splitting. Optimization of server

You cannot read the list of previously registered servers on this system. Please register your server again in the "registered servers" window, and then register again in the window Environment: Server System: Database Version: Microsoft SQL Server

Oracle uses a single cursor to insert data. For example, oracle cursor Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/47143731Background Recently, some friends asked me how to insert

Use SQL server to add a system administrator account and an SQL System Administrator Account To add a system administrator account through SQL SERVER, you must have sufficient permissions to remotely connect to the database and execute the script

Database questions-higher than the average department salary query problem, the average department salaryQuestion: find out the name, salary, Department number, and average salary of the employee higher than the average salary of the Department 1.

Mysql administrator password retrieval, mysql administrator passwordWe may forget the ROOT password for various reasons when using MYSQL. If so, the database may be discarded, however, I would like to share with you today how to retrieve the ROOT

Mysql explores not null constraints and null values, and mysqlnull Yesterday, a front-end developer suddenly asked me a basic question: "My table columns have the not null constraint. Why can I insert null values? What's more strange is that you can

Oracle 11g audit file and oracle11g audit file Audit: The audit option enabled by default for 11g. The default value of the AUDIT_TRAIL parameter is DB, which indicates that audit data will be recorded in the base table of the audit dictionary in

MySQL loads the JDBC driver and mysql loads the jdbc driver. First, install the MySQL database. MySQL5.5 is installed. The installation steps are not described here. Please note that if the installation process stops at the start service and cannot

Multiple result sets of report data sources and report data sources Diverse data sources are becoming more and more common in report development. the effective support of the collection and computing reports for diverse data sources makes the

Path to mathematics-sas memo (13), path to sas memo 13Libname sastemp 'e:/sastemp /';Option user = sastemp; * specifies the reference name of the next logical database;Page; * The log starts from a new page;Data sales;Input id $ price;Skip 6; * Five

Toad for oracle, formatting configuration backup FmtPlus. opt, toadfmtplus. opt Toad for Oracle 11.6 (win7 64) File Path: C: \ Users \ Administrator \ AppData \ Roaming \ Quest Software \ Toad for Oracle \ 11.6 \ User Files \ FmtPlus. opt Remarks:

PostgreSQL operations-Basic psql commands and postgresql operations-psql 1. Establish a database connection----------------Access PostgreSQL database: psql-h IP address-p port-U Database Name Enter the Database Password.   2. Access the database

Com. microsoft. sqlserver. jdbc. SQLServerException: The result set does not have the current row, and the result set is exhausted.Refer to blog com. microsoft. sqlserver. jdbc. SQLServerException: The result set does not have the current row. Java

PL-SQL package creation and application, pl-SQL CreationZookeeper Creating and applying PL-SQL packages ① IntroductionA package is a combination of PL/SQL programming elements, such as related processes, functions, variables, constants, and cursors.

When considering subjects such as primary Data Management (MDM) and Master Data Management, it is the only natural way to seek consultations from people who have already experienced or experienced primary Data Management. However, the best practices