Database Administrator

1. view all objects currently SQL> select * from tab; 2. Create an empty table with the same structure as Table SQL> create table B as select * from a where 1 = 2; SQL> create table B (b1, b2, b3) as select a1, a2, a3 from a where 1 = 2; 3. Check

1. having clause usage The having clause controls the row groups determined by the group by clause. The having clause conditions allow only constants, clustering functions, or columns in the group by clause. 2. Usage of external join "+" External

Attracting customersBlog of Oracle: instances and databases Instances are composed of the following: SGA, Sharedpool, Databasebuffercache, and Redologbuffercache. A database consists of physical files. The required files include data files, control

Nested SELECT statements are also called subqueries, for example: SELECT name FROM bbc WHERE region = (SELECT region FROM bbc WHERE name = 'Brazil ') The query result of one SELECT statement can be used as the input value of another statement. The

# Valid Oracle identifiers 1. It cannot be a reserved keyword. 2. It must contain 1 to 30 characters. The database name cannot exceed 8 characters. 3. It must start with a letter in the database Character Set 4. Only letters in the database

The following operations are successful in Oracle9i and 10g. Step 1: create a directory object for storing XML files SQL>createorreplacedirectoryexp_diras'/opt';/ -- Note that the directory must have the write permission of the

Introduction Let's skip the concepts, steps, and syntax of the cursor. Let's look at an example: Table 1 OriginSalary Table 2 AddSalary There are now two tables, one of which is OriginSalary table-payroll, with three fields: 0_ID employee id

Writing SQL statements is inferior to writing. NET programs. There are no smart prompts. You need to remember keywords, functions, or constantly Copy table field names, user-defined functions, stored procedures, and so on. However, in VS2010, we can

In the past, I was often confused by the user name and login name in SQL Server, because I used the sa Login Name to fix everything. Of course, this would pose some security risks. The online articles seem to be very good, but still do not

If the SQL Server database engine is not started, a troubleshooting step is executed to start the database engine from the command prompt. This topic describes how to start a database engine instance. Note: For troubleshooting, SQL Server should

1. Create an INFORMIX user group and an informix user home =/usr/informix 2. Add password to informix 3. Expand the informix Installation File: rpm-I *******************. rpm (three in total) 4. Modify the root profile and addINFORMIXDIR

Preface Human errors are one of the major causes of database system failures. According to the investigation, about 40% of system problems are caused by Operation errors or user errors, which are especially difficult to avoid. Traditionally, when

Basic Principles 1. Use the DBMS_JOB package to submit the primary processing stored procedure as a task to the task queue. 2. The main processing and storage process puts the processing situation in the pipeline through the DBMS_PIPE package

The principle of user authentication is simple: first, you need to enter the user name and password on the page. Of course, users who are not registered must first register. Then, you can call the database to search for users. If yes, confirm it. If

With the popularization of networks, more and more network-based applications are available. Network databases are one of them. One or several servers can provide services to many customers. This method brings a lot of convenience to people, but it

Multi-Table operations Multiple tables may exist in a database, which are associated with each other. We will continue to use the previous example. The preceding table contains basic information about an employee, such as name, gender, date of

The lifecycle of a database system can be divided into three stages: design, development, and product. The lowest cost and maximum benefit of database performance optimization during the design phase. In the final stage, database performance

1. Introduction Today's IT environment is experiencing dramatic changes, and companies that rely on a single relational database management system (RDBMS) to manage data are gradually decreasing. Analysts report that more than 90% of companies today

Summary ASE has become a high-performance leader in OLTP (on-line transaction processing, online transaction processing) systems. However, users now need not only high transaction processing performance, but also Analysis of the transaction data of

The key reason for upgrading the storage capacity of Large objects (LOB) is that the data security requirements are getting higher and higher in Oracle 11g, this article mainly studies how to extend the Transparent Data Encryption (TDE) feature of