Programmer Group

Business description: table A is the detailed statement of table B. now it is required that table B has millions of records. Insert the relevant records of table B in table A. Preparation: oracle database, database tool pl\sql, stored procedures written in the package. Implementation ideas: 3.1 get the total data volu ...

The second day of GO learning, today I mainly learned some data types of GO. The common data types of go are as follows 1 int (int, int8, int16, int32, int64) 2 float (float32, float64) 3 string 4 byte 5 bool 6 array 7 slice 8 map 9 channel 10 interface 11 strcut Common data types ...

oracle 11g single instance silent installation AURHOR: Oracle_Ran Environmental Planning: OS Version : Red Hat Enterprise Linux Server release 6.7 (Santiago) Oracle Version: 11.2.0.4 Please refer to Oracle single instance installation document for operating system environment configuration   1. Upload the Oracle installation media, enter the ...

Sometimes we need to create indexes for some partitions. Oracle 11g provides this function. You can create local and global indexes on partial partitions. Global partial index: only those partitions that need to be indexed will be indexed, and other partitions will not be created. Local index: if index is turned on fo ...

Due to the loss of control file caused by a power failure, the startup database reported ORA-00205 error: SQL> startup ORACLE instance started. Total System Global Area 419430400 bytes Fixed Size 2925120 bytes Variable Size 285216192 bytes Database Buffers 125829120 bytes Redo Buffers ...

Oracle - > auto send AWR Report September 21, 2016 09:31 Requirement Description: Daily or regular manual use of AWR reports to check the status of Oracle database is not only time-consuming but also labor-intensive, requiring the use of scripts to automatically collect AWR reports.    Analysis scheme: Script to collect AWR report: $o ...

Write before: Recently, the old project has added the need of daily report optimization. Li Jie asked me to use triggers to update the daily report data when inserting or updating data. Mm-hmm-hmm. when I was learning database, I met triggers, but they all jumped by, and I didn't really practice them. This time, I have the right to learn again~ ...

1. PlSql programming procedure language In the sql statement of database, the common definition of variable condition judgment cycle structure is added to the statement of process 1) . basic grammatical structure declare – declaration part – similar to defining variables begin &nda ...

Some very good enterprise level functions of the database are "military for a thousand days, military for a while". For example, the Recycle Bin function in Oracle 10g can play the role of special soldiers in special circumstances. For example, when you delete a table space or a user schema, you may delete many tables, including some ...

MySQL introduction /* MySQL database management system (file management system in essence) Advantages over ordinary files: 1. Easy to manage data; 2. Suitable for complex multi-threaded operations In MySQL: database database (essentially folder) Create database: name of create database; Display dat ...