Database Administrator

Use PL/SQL to connect to Oracle without installing the Oracle client Want to connect to the Oracle database? Install the client. OH ~ NO !, A few hundred megabytes are missing. Now you only need to download a software named Instant Client Package

Linux installation setup VNC Remote Desktop Connection to install Oracle 11g Preface:To install Oracle in Linux, you need to start the swing interface of Java. Therefore, the x-window is required. Therefore, it is difficult to directly go to the

Use trigger to call shell in MysSQL & MariaDB In Windows: Drop function if exists lib_mysqludf_sys_info;Drop function if exists sys_get;Drop function if exists sys_set;Drop function if exists sys_exec;Drop function if exists sys_eval; Create

While I was unable to upgrade my laptop to 1 GB of memory, I was suffering from installing Sun Solaris 10 U3 + Oracle 10g R2 in my current book, I got a laptop for the competition, haha ...... Comfortable. The following is my Installation Record

How to build an Oracle 11g license uard   I. PreparationsI have read many tutorials when preparing to build a tracing uard. I followed the tutorials and encountered problems. Then I don't know how to proceed to the next step.Later, I went to the

Install the Visual Database Browser SQLite Browser 16.04 on Ubuntu 3.8 SQLite Browser 3.8 was released at the end of last year. SQLite Browser is a visual database Browser that can be installed through PPA. SQLite Browser is a visualization tool

Oracle snapshot standby database's scheduler jobs are not executed In Oracle 11g, the snapshot backup snapshot standby database feature of data guard is more suitable for rapid deployment of a temporary test database that is the same as the online

Microsoft introduced a new tool to help MySQL users migrate their data to Microsoft's SQL Server database. This tool is called the SQL Server migration assistant (SSMA ). The future of MySQL was unknown due to the Oracle-SUN purchase case. Microsoft

Alter table tablename add (column datatype [default value] [null/not null],...); Alter table tablename modify (column datatype [default value] [null/not null],...); Alter table tablename drop (column ); Alter table is used to add, delete, and

MongoDB database installation details (2). mongodb details How to change mongodb in java Java-based mongodb insert, read, modify, and delete operationsThis article describes how to operate MongoDB in Java and how to perform routine

Oracle goldengate bi-directional active-active configure 1. Install the golden gate software. After creating the installation directory, decompress it under the directory. (Both the source and target are executed)Note: We recommend that you use

In the process of installing Oralce in Linux, if the Linux release version is not the recommended version of 0racle, the following error may be reported, causing the runInstaller to fail:Java code [Oracle@ LocalhostDatabase] $./runInstaller

1. The control file contains the data to be loaded. First, create a test table. SQL> showUser USERIs"ING" SQL>Create TableDept 2 (deptno number (10)ConstraintDept_pkPrimary Key, 3 dname varchar2 (20 ), 4 loc varchar2 (20 )); The table has

I wrote a piece of code when I used SQL statements to create a table yesterday. I am not sure about the logic and content of the code. I did not hesitate to execute the code, there were several errors in the process. At that time, I didn't care too

Speaking of mysql, we immediately think of its small size, fast speed, and open source features, so it is widely used. Today, we will summarize the two most frequent mysql operations: insert and query, and the optimization methods. Insert: I. Text

Requirements for installing oracle database 12c on RHEL7 or OL7, rhel7ol7 This article comes from: Requirements for Installing Oracle Database 12.1on RHEL7 or OL7 64-bit (x86-64) (Document ID 1961997.1)   This article is not translated and is only

Powershell Mail module, which sends all the emails in outbox (A. CSV file represents an email ), Write the creating mail code to the calling place and write the mailxxx.csv file to the outbox. The main content of the email is recorded in the

Introduction to jdbc and jdbc connection to databasesThis document can be used as a learning note for the jdbc course of Beijing shangxue;What is jdbc?Jdbc full name (Java Database Connectivity java Database connection)What does it do?As for what it

C # synchronize data in the SQL Server database-Database Synchronization tool [synchronize new data],C # synchronize data in the SQL Server database 1. Write an SQL processing class first: using System;using System.Collections.Generic;using

Auto-configuration database_console version Restore database, Database Console Error message: Configuration: Cause: the database name "5" is not the actual logical name of the database backup file named "Sdzn" View the actual logical name of the