Oracle

With the previous effort, all the jobs in the database are back to normal, there are no long-running sessions that hold locks, and there are no long-running transactions in the transaction view: Sql> SELECT instance_name from v$instance;

1. Display user Information (1) Display the current session user 10:16:18 sql> Show user; USER is "SYS" (2) Show privileged users 10:17:07 sql> Conn sys/oracle as SYSDBA; Connected. 10:17:09 sql> SELECT * from V$pwfile_users; USERNAME Sysdb

Oracle provides us with very rich aggregate functions, such as Sum\avg\max. In addition, we can write our own aggregate functions, of course, custom aggregate functions can also be used as analytic functions. Custom aggregate functions are not much

The connections between Oracle tables are divided into three types: 1. Inner connection (natural connection) 2. Outer connection (1) Left OUTER join (the table on the left is unrestricted) (2) Right outer join (the table on the right is

Create or Replace package p_page is --Author:pharaohs --Created:2006-4-30 14:14:14 --Purpose: Paging process TYPE Type_cur is REF CURSOR; --Define a cursor variable to return the recordset PROCEDURE Pagination ( Pindex in number--Paging index

Introduction to custom aggregate function interfaces Oracle provides a number of predefined aggregate functions, such as Max (), Sum (), AVG (), but these predefined aggregate functions are basically adapted to scalar data (scalar), for complex

The format of the timestamp data is the same as the date data. Note that the TO_CHAR function supports date and timestamp, but Trunc does not support timestamp data types. This has made it clear that using the timestamp data type is more accurate

The database system itself is a multi-user concurrent processing system, at the same time, there may be more than one user can operate the database simultaneously. Here are two very important questions to be addressed. The operations between these

Oracle Audit is an afterthought, that is, after the database security problems, in order to locate, find the root cause of the problem, can be traced back through the audit. The Oracle audit consists of the following 3 sections: trigger-based

Summary: In a large number of business data processing projects, you can consider the use of partitioned tables to improve the performance of the application system and facilitate data management, this article describes the use of partitioned tables

A sequence of values is often used in database tables. Whether it is naturally generated as the data itself or by an Oracle sequence object, its purpose is to number each row with a unique, incremental number. In the process of numbering, the

Oracle local time 18th released a July security update to repair 65 software deficiencies, including a number of serious cross product issues. The repairs include many serious weaknesses. Darius Wiles, Oracle's senior manager responsible for

Oracle|word Database-built users cannot authenticate to the database until the database is started. The password file holds the username and password of the Sysdba/sysoper user, allows the user to authenticate by password file, log in before the

oracle| Data | database first, some concepts of relational databases 　　 1, the value of the primary key can not be changed generally 　　 2. Foreign key: A field that points to another table or to the primary key or unique key of this table. The

oracle| Safety | Safety Problems | Problem database security problem has been one of the focus of attention, we know that a business or organization of the database if the hacker attacks, and these databases and the preservation of very important

oracle| Data | database | index Analysis of the application of index in database Indexing is the most effective way to improve data querying and is the most difficult technology to master, because proper indexing can increase efficiency by 10,00

oracle| Data | database Finishing: Fenng Date: 25-oct-2004 Source: Http://www.dbanotes.net Version: 0.91 Sometimes, as a DBA, you may need to collect the deployed Oracle database information. Hardware configuration, operating system conditions,

Sql*loader is an Oracle data-loading tool that is typically used to migrate operating system files to an Oracle database. Sql*loader is a large data The Load method that the warehouse chooses to use. Under NT, the Sql*loader command is Sqlldr,

Objective Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of

There are also many ways to search for text in an Oracle database without using the Oracle text feature. You can use the standard InStr function and the LIKE operator. SELECT　*FROM　mytext　WHERE　INSTR　(thetext,　 'Oracle')　>　0;