Database Administrator

I. Switching users To control and manage Oracle, you must first switch to the Oracle user. The following command is generally used: Su-oracle Ii. Start the listener To remotely connect to the database, you must start the listener by using the

Restoration After Oracle Deletion Savepoint; Delete from student; Rollback to; Modify date format in Oracle Alter session set nls_date_format = 'yyyy-mm-dd' Query records with blank or non-empty fields in Oracle Select * from student where

When using the SQL statement generated by powerdesigner to create a table, I do not know how to add a space in the table name. I did not care to directly run it in PL/SQL, it is difficult to use the statement or right-click to delete the file. When

1. After installing the Oracle database, You 'd better back up the entire Oracle folder before installing the application, because it is a "clean" database, similar to after installing the operating system, create a clean ghost. After the

-- MySQL group sorting is the simplest SQL statement for the first N records.USE test;Drop table if exists test;Create table test (Id int primary key,Cid INT,Author VARCHAR (30)) ENGINE = MYISAM;Insert into test VALUES(1, 1, 'test1 '),(2, 1, 'test1 '

Syntax for SUBSTRING: SUBSTRING(expression, start, length)Expression String, binary string, text, image, column, or expression that contains a column. Do not use expressions that contain aggregate functions. Start An integer or expression that can

/* Delete repeated feedback table data */procedure PRO_CZW_DEL_DOU_FEEBACK as begin for rec in (select row_number () over (partition by t. ywlsh/* Specified duplicate column */order by t. id desc) as lev,/* sorting of specified duplicate columns */t.

I will summarize the series of this tutorial and refuse to reprint it without my permission. Function Description: implements the set key value Command provided by redis by modifying the source code. The new command is make key value. Note that all

XML query in SQL SERVER: FOR XML specifies RAWPreface In SQL SERVER, you can specify RAW, AUTO, EXPLICIT, and PATH for XML queries. This article uses some examples to introduce the specified raw xml query in SQL SERVER. Basic for xml query View

Connect C ++/C to the MySQL database in Linux (3) -- Process returned data 1. Number of fields in the returned result set Unsigned int mysql_field_count (MYSQL * connection); // use the value of MYSQL_ROW as an array that stores a row of

I. Partition definition: A partitioned table divides data from a large table into many small subsets, which are called partitions. Ii. Advantages of partitioning: 1. Enhanced availability: If a partition in the table cannot be used due to system

PERCENTILE_CONT and PERCENTILE_DISC in SQL SERVER PERCENTILE_CONT and PERCENTILE_DISC Check the following SQL statements: WITH testas( select N'LeeWhoeeUniversity' as name,10 as score UNION ALL select N'LeeWhoeeUniversity',20 UNION ALL

In Windows, Oracle backs up data every night through EXP and retains the backup data for ten days. 1. Create the backup script oraclebackup. bat Contents: @ Echo offEcho deletes the backup file and log 10 days ago. Forfiles/p "E: \ oraclebackup"/

I still remember the feeling of reading tianshu when I read database system principles for the first time, and the cloud was in the fog. Now I have read this book for the second time, and I suddenly felt something, "Oh, it turned out to be like this

I haven't written anything for a long time. I have been reading some open-source things. Next I will post the installation and configuration of ipvs on linux and the reference for using dblink for readers and their future reference: 1, download

Sqlplus can recover a part of the data file when archiving is complete. However, RMAN is specialized in restoring the backup.The following describes how to restore damaged data files.1. The data file in the tablespace is damaged, but the storage

Because only mysql is used for data storage, it takes a long time to complete complex data statistics. Therefore, you need to import part of the data to redis and save the result to mysql after completing data statistics. After checking the data,

1. first, I will use the decimal type for high-precision items, such as money, and will not consider float and double, because they are prone to errors. numeric and decimal are synonymous, and numeric will automatically convert to decimal. DECIMAL

Environment:Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0VBOX Virtual MachineHost Name, database instance, database name, and IP address planning:Source Host IP Address: 192.168.1.213 HOSTNAME: bys001.oel.comTarget Host

Previously, the Department used the transform to implement row_number. I think it is more convenient to use it after UDF implementation, eliminating the hassle of the transform syntax. The test table used is: Hive> desc row_number_test;OKId1 intId2