Tag：oracle
-
DBASK Q&A Collection Issue 5
introductionRecently, we have newly associated public accounts in the data field such as Hanfeng Channel, Internet Scouting, Database SQL, SQL Database Development, Cross-Border Architect, Shi Shan’s Architecture Notes, etc. in the DBASK applet. The aggregated updates are displayed, and everyone is welcome to read and share. Questions and AnswersNext, we share the problems and diagnosis […]
-
“Oracle” Oracle database backup and restore
Author: threedayman source:Hang Seng LIGHT Cloud Community theoretical preparation The oracle database provides expdp and impdp commands for backing up and restoring the database. For details, please refer to the official oracle documentationhttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/database-utilities.pdf Backup and restore are mainly FULL_MODE: The entire database is backed up and restored. Schema Mode: Default export mode, Schema mode. Table […]
-
Improve the sql level, record 50 classic sql questions [including table building sql, answer sql, highly recommended for those who want to improve sql level]
I left school in June this year, and I will summarize some things every once in a whileI firmly believe that time will witness the pace of hard workThis article is hereby written to review the 50 most popular sqls on the Internet. The ideas and sqls in them are all records on my way […]
-
Tapdata Cloud version is new! Added support for 5 data sources such as ClickHouse, ADB MySQL, etc.
Tapdata Cloud cloud.tapdata.net Tapdata Cloud is the first heterogeneous database real-time synchronization cloud platform in China, currently supports Oracle, MySQL, PG, SQL Server, MongoDB, ES, Dameng, Kafka, GP, MQ, ClickHouse, Hazelcast Cloud, ADB MySQL, ADB PostgreSQL, KunDB The data synchronization between, will soon support DB2, Sybase ASE, Redis, GBase, GaussDB, etc., and will be permanently […]
-
Ex-Oracle engineer posted an article “slandering” MySQL: “It’s terrible! Postgres is strongly recommended”? The truth is surprising
Recently, an Oracle engineer who is about to leave his job and switch to Google posted an “attack” on MySQL in his blog. He claims that PostgreSQL is a better choice for an open source RDBMS, “MySQL is a ‘pretty bad’ database and you should strongly consider using Postgres”. It is reported that the engineer […]
-
Oracle automated daily inspection
In order to ensure the normal operation of the system, daily inspection is essential. The full-data AI smart management and control cloud platform (DB Captain) is a B/S structure, mainly capable of data migration, operation and maintenance management and control, automatic operation and maintenance inspection, web page SSH and automatic publishing. Let me tell you […]
-
Summary of high-quality articles on database troubleshooting (including Oracle, MySQL, MogDB, etc.)
Projects such as database alarms and emergency problem handling should be familiar to most friends. Organized from Motianlun community“The Most Popular Technical Documentation Collection by DBAs” Seriescan be found in the“Troubleshooting Topics”The enthusiasm remains high, which shows that everyone often encounters various emergency troubleshooting problems. Although the reasons for each database failure may be different, […]
-
[Teacher Zhao Yuqiang] Employment salary statistics of previous students, looking forward to the 01st course of Oracle
[Teacher Zhao Yuqiang] Employment salary statistics of previous students, looking forward to the 01st course of Oracle
-
“Oracle” client PL/SQL DEVELOPER installation and use
Author: threedayman source:Hang Seng LIGHT Cloud Community background Compared with the command line, the client has richer visual interface information. At the same time, in order to run large sql files more conveniently, choose to install the client. Download and install PL/SQL DEVELOPER download addresshttps://www.allroundautomations.com/registered-plsqldev/Choose the appropriate version to install. Download Instantclient download addresshttps://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html After […]
-
“Oracle” database character set encoding modification
Author: threedayman source:Hang Seng LIGHT Cloud Community background The project needs to use ZHS16GBK by default. When UTF8 is used for encoding, there will be a problem that the inserted data exceeds the field length limit. Reason: gbk encoding Chinese characters occupies two bytes, and utf8 encoding Chinese characters occupies three bytes. In order for […]
-
Detailed explanation of garbled characters from Oracle data to MaxCompute
Introduction: Integrating Oracle data into MaxCompute, analysis of garbled characters; Why, the data in Oracle is not garbled, but it is garbled when integrated into MaxCompute? What is the problem? 1.1 Garbled characters The data offline integration (DataX) of DataWorks integrates Oracle data to MaxCompute. The data has garbled characters, but the source database is […]
-
Oracle database business SQL optimization practice – time interval query case
background There are actually many query fields, I choose to focus on the bottleneck point, let’s get started Functional Background Brief: We set up a machine at the entrance of the data center to record the entry and exit of personnel, and the guards will operate and record the entry and exit of personnel […]