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 $

Recently, a field-based query function is provided for each table in our system. The foreground sends json data to the backend, And the backend performs Fuzzy Matching by %, query by field. the result is rejected. another colleague used Hibernate

**************************************** ******* Oracle database instance startup and Shutdown Process **************************************** ******* The Oracle database instance should be started strictly. The database is only loaded after the

1: Redis is a DSL tool for operating data structures. It provides TCP-based protocols to operate on rich data structures. 2: Redis is a memory database. It is precisely because of the fast access to memory that Redis can have such high performance.

For more information about rownum and rowid, see: For details about how to use rownum paging, refer to the following SQL Select*From (  SelectT1.*, RownumRnFrom ( Select*FromScott.EmpOrder BySalDesc --Here is the sorted table  )T1Where Rownum 8

I,ASM(Automatic Storage Management) reason: ASMYesOracle 10g R2To simplifyOracleA new feature introduced by database management, which isOracleThe volume manager provided by Alibaba Cloud is mainly used to replace the volume manager provided by the

I. Fault occurrence: This morningQQSend a friend to me and sayOracleSoftware Installation Error: Ii. Fault Analysis: The fault is caused by failure.OracleThe official documentationLinuxAs a result: Iii. UseRootUser Logon editing/Etc/security/limits.

1. user_source Process Code of the current user2. user_objects contains all database objects owned by the user3. user_segments4. user_tables tablespace and tablespace Information5. user_tab_partitions partition information6. user_views7.

Restore with RMAN 1. Use the restore command Read the data blocks in the backup file, and store the data blocks in the corresponding data files according to the data files to which the data blocks belong, so as to restore the data. 2. Use the

Background:Just a netizen asked the ORA-30009 error, the database version is 10.2.0.5, the operating system version is RedHat 4; then I took into account the hardware and buffer constraints, the verification, the details are as follows: Error

1. Prepare the system environment before installing Oracle 11g R2 database   1. view the system version, kernel version, number of operating system digits, memory and swap partition size, file system space, host name, IP address, and so on. [Root @

Summary The data storage method has a great impact on the overall performance of the application. Is Data Access smooth or random? Are data stored on disks and stored on flash cards? Does multi-threaded read/write affect performance? How can we

1. Add a user to Mysql Format: grant select on database. * to "username" @ "Login host" identified by "password "; Example 1: Add a user named "test1" with the password "abc" so that the user can log on to any host and have the permission to query,

The control file records important information about the DATABASE, including the DATABASE identifier (the DB_NAME parameter or the name used when the create database statement is used) name and location of data files and redo log files, timestamp of

1. Create a table: Create table test (id int, name varchar (20), quarter int, profile int )) Insert into test values (1, 'A', 1,1000 );Insert into test values (1, 'A', 2,1000 );Insert into test values (1, 'A', 3,1000 );Insert into test values (1, 'A'

Install Mysql under Fedora 16 1. Download the MySQL Installation FileThe following two files are required to install MySQL:MySQL-client-5.1.55-1.glibc23.i386.rpm MySQL-server-5.1.55-1.glibc23.i386.rpm For:

Function: The purpose of using a function is to operate data. Process the input variable and return a result. There can be many variables. The input variables can be column values or expressions. Functions can be nested. The result of the inner

MongoDB is a scalable and high-performance open-source NoSQL document database. It is mainly developed using C ++. For document storage, full index support, replicable and high availability, automatic sharding, and other features. Among

When I was reading CU today, I found someone asking about optimize's table optimization problem. It was a long time because of this problem. Today I am free to ask this question, we can use the actual data to show it, so that you can see with your

Notice: written based on Ubuntu1. About MySQL Character Set MySQL Character Set Support has two aspects: Character set and Collation ). MySQL supports character sets in four layers: server, database, table, and connection ). MySQL can refine the