Database Administrator

PostgreSQL cursor example (create a cursor and traverse it in the function) -- Drop function top100cur (refcursor ); Create FunctionTop100cur (refcursor)ReturnsRefcursorAs$ Begin Open$1For Select*FromPersons limit 100; Return$1; End $

1. Create required data CREATE TABLE "TEST" ( "ID"NUMBERNOT NULLENABLE, "NAME"VARCHAR2 (50 BYTE)NOT NULLENABLE, "AGE"NUMBERNOT NULLENABLE, "DEPT"VARCHAR2 (50 BYTE)NOT NULLENABLE, CONSTRAINT "TEST_PK" PRIMARY KEY("ID") ENABLE ) XML

The period-over-period ratio is the nth month of the year and the nth month of the year, or the nth month of the year. Create a test table, which is assumed to be a sales quantity table: Create table t (dt date, cnt number ); Insert some test data.

The previous article on how to store Distributed Data Based on MongoDB describes how to store Distributed Relational Data Based on Mongodb. Although it can be queried in a common way, we will introduce how to use the MapReduce function provided in

During routine database maintenance, we need to check the invalid object information in the database in time and re-compile the abnormal object. For various object types, see the following compilation method: Check the name of the generated Invalid

1. If the default port 1521 is used and the instance is automatically registered to the listener, you do not need to set local_listener. The listener. ora file can be configured as normal. 2. If a non-default port 1521 is used to enable the instance

Oracle's rownum is a pseudo-column, and its principle has a lot to do on the net, but we are still very confused. In fact, we just need to understand its principle. What's important is to use it, therefore, we only need to ensure that we do not make

Environment: PLSQL Developer 7.1.5 Oracle 11.2.0 Oracle does not specify an auto-increment column as MYSQL or MSSQLServer does. However, in Oracle, the SEQUENCE can be used to automatically increase fields. In Oracle, SEQUENCE is called a SEQUENCE.

Create Table, prompting ORA-00959: tablespace 'mc _ data' does not exist. First, confirm the current user's tablespace. Select username, default_tablespace, temporary_tablespace from dba_users where username = 'mcmidyl '; The default tablespace

Partitions by the range of values of one or more columns in a table.Syntax: PARTITIONBYRANGE (column_name) ( PARTITION part1 value less than (range1 ), PARTITION part2 value less than (range2 ), ... [PARTITION partN value less than (MAXVALUE)]

[Root @ www.bkjia.com ~] # Yum-y install mysql-server[Root @ www.bkjia.com ~] #/Etc/rc. d/init. d/mysqld startInitializing MySQL database: Installing MySQL system tables...OKFilling help tables...OK To start mysqld at boot time you have to

Study mysql master-slave replication. During the Database Import and Export process, it is okay to export the master data, but the error mysqldump 1449 is returned when importing the master data from the database, then I searched for the solution on

Oracle em grid control 10.2.0.2 is installed on a windows Server, and an existing database is used as the database. The oracle emgrid agent software is installed on various linux servers for monitoring the oracle database and rac system. The agent

I. Prerequisites for Migration:1. The operating system meets the installation conditions of the Oracle database version.2. database versions are consistent 2. operations on the source database: 1. Check whether the database is archived. If not,

Soaptest in Oracle DeclareSoap_request varchar2 (30000 );Soap_respond varchar2 (30000 );Http_req utl_http.req;Http_resp utl_http.resp;BEGINSoap_request: = ' f001 ';Http_req: = utl_http.begin_request ('HTTP: // 127.0.0.1:

How to view the parameter of the Oracle database Method 1-show parameter SQL> show parameter NAMETYPE VALUE ----------------------- Background_core_dump stringPartial Background_dump_dest string D: \ ORACLE \ PRODUCT \ 10.2.0 \ ADMIN \

If exists (Select*FromDbo. sysobjectsWhereId = object_id (N'[Dbo]. [sp_who_lock]')AndOBJECTPROPERTY (id, N'Isprocedure') = 1) Drop Procedure[Dbo]. [sp_who_lock] GO /*************************************** ************************************ //

In the database synchronization process, both the Database loading efficiency and the atomicity of each transaction in the database must be ensured, that is, the execution of Multiple SQL statements in a transaction must be successful for the above

CouchDB is very easy to implement distributed data replication. We only need to send the POST request to the specified database_ ReplicateThe request Body is a JSON string. Wiki.apache.org/couchdb/Replication To continue copying, you only need to

Connect to Oracle with Java, run a period of time, the Program reported an error, connection failed, ora-28000 the account is locked, this reason is because the user is locked, generally this situation, there are several reasons: 1. The reason is