NAV: SLTechnology News&Howtos > Database >

• 

  AText for Mac (typing Accelerator) v2.36.3

  AText for Mac is a typing accelerator. With aText mac, you can easily avoid typing the same content over and over again, speed up typing, save users time, and improve productivity by replacing abbreviations with custom common phrases. AText for

  2022-06-01 06:25:31 Views: 293
• 

  Install mysql4.1.15.tar.gz under linux enterprise 3.0

  # tar zvxf mysql-4.1.15.tar.gz#mv mysql-4.1.15 mysql installs Mysql. (# cd mysql#./configure-prefix=/data/mys

  2022-06-01 06:25:30 Views: 216
• 

  What's the difference between where and on in the external connection of Oracle after and?

  1. When the table is associated, some conditions are written in where, and some are written in the and of the association condition after on. So what's the difference. 2. Under our guidance, table relevance is generally divided into two types: inline and outreach. 3. Let's look at the inline first. 4. Prepare two tables for connection. Table A:test

  2022-06-01 06:25:28 Views: 254
• 

  New In-Memory features Spatial and Text support for Oracle 20c

  Aiming at the built-in multi-mode characteristics of Oracle database, geographic information-Spatial and full-text search-Text components, through the memory characteristics of In-Memory in Oracle Database 20c,

  2022-06-01 06:25:27 Views: 286
• 

  The difference between Oracle date and timestamp

  We are so familiar with the https://www.cnblogs.com/java-class/p/4742740.html1.DATE data type that we think of the date type when we need to represent the date and time.

  2022-06-01 06:25:21 Views: 205
• 

  Dynamic desensitization of database

  The product introduction database dynamic desensitization system (VS-DM) intercepts and modifies the communication contents of the database, and carries out online shielding, deformation, character replacement, random replacement and other processing of the sensitive data in the database, so as to achieve the access control of users to the real content of the sensitive data. To Stora

  2022-06-01 06:25:12 Views: 209
• 

  Mysql's understanding of redo transaction log ib _ logfile

  Summary 1. The redo transaction log is ib_logfile, the two files at the beginning of ib_logfile, they are redo logfile in log group, and their sizes are exactly the same and equal to the variable innodb_log_f.

  2022-06-01 06:25:12 Views: 271
• 

  PostgreSQL Source Code interpretation (41)-query statement # 26 (query_planner function # 4)

  The last section introduced the implementation logic of the subfunction add_base_rels_to_query of the function query_planner, and this section continues to introduce the subfunction build_base_rel_tlists/find_placeho

  2022-06-01 06:25:12 Views: 205
• 

  How To Use Virtual Column-Based Partitioning

  In the previous article, I introduced and tested the new virtual column feature introduced by the 11g version of oracle. This article continues to test the partition key-based virtual column: Prior releases of Oracle only allowed a table to be

  2022-06-01 06:25:08 Views: 274
• 

  MySQL 4.1 + support for multiple characters

  MySQL 4. 1 character set support (Character Set Support) has two aspects: character set (Character set) and sorting method (Collation). Support for character sets is refined to four levels: server s

  2022-06-01 06:25:08 Views: 235
• 

  Oracle interview Treasure Book-process structure

  Oracle interview Treasure Book-process structure does the Oracle database run in a single-process or multi-process manner? Under the Windows platform, the Oracle database runs in a single-process (oracle.exe) multi-thread mode. In Lin

  2022-06-01 06:25:08 Views: 230
• 

  The pits of oracle 12.1

  1. Even if the database is not restarted, some startup information will be typed on the log, which makes you wonder if the library is restarted unreasonably. The most important thing is that there are no other related logs, which makes you wonder if you should not do DBA. 1.1 prohibit parameter information from dump to the Alert log _ log_seg.

  2022-06-01 06:25:07 Views: 292
• 

  MySQL double write

  The introduction of double write technology is to improve the reliability of data writing. When writing part of the data, such as 512bytes. Why didn't Oracle solve the problem, while MySQL solved it through double write?

  2022-06-01 06:25:02 Views: 262
• 

  DM7 modifies database parameters

  In DM7, DBA can execute SF_GET_PARA_VALUE, SF_GET_PARA_DOUBLE_VALUE and SF_GET_PARA_STRING_VALUE functions while the DM database is running to get the

  2022-06-01 06:25:01 Views: 203
• 

  Analysis of the problem of MySQL access restriction

  Today, I looked at a MySQL connection problem for my colleagues. It was interesting that there were two users, one with a normal connection and the other with a wrong connection. The error log provided by the developer is as follows: {resin-33} java.net.SocketException {r

  2022-06-01 06:24:59 Views: 245
• 

  Divide a delimited line into multiple lines

  Today, we encounter a demand that has not been done before. To divide the delimited data into multiple rows and columns into another table according to the delimiter, while the other columns remain the same, I have thought for a while that it is more difficult to associate the changed data with the one before the change. I read the next few cases on the Internet, feeling: https://bl

  2022-06-01 06:24:54 Views: 263
• 

  Some of the best networking experiences when running RAC on AIX

  Some network best practices when running RAC on AIX some network best practices when running RAC on AIX 1. Oracle recommends using Etherchannel to configure network card binding, recommend primary / standby mode network card binding, master / master (Active)

  2022-06-01 06:24:53 Views: 262
• 

  Mysql ibdata file erroneous deletion recovery

  1 do not panic when we delete the ibdata file by mistake. At this time, as long as you do not restart the service mysql database can still be used how to restore the premise do not kill the mysqld process, and can not shut down the mysql service to find the mysqld pid [mysq

  2022-06-01 06:24:53 Views: 256
• 

  Oracle EBS payable module batch payment

  CREATE OR REPLACE Package xxx_STD_AP_AutoPMTs_pkg Is/*=

  2022-06-01 06:24:53 Views: 243
• 

  Redhat9.0 Apache2+Php5.0+Mysql4.0 configuration (transfer)

  Redhat9.0 Apache2+Php5.0+Mysql4.0 configuration (transfer) [@ more@] We do not use the above services that come with the system. Before installation, uninstall the programs that come with the system and use rpm-e name to uninstall the software source: h

  2022-06-01 06:24:53 Views: 212