Oracle

Oracle RAC Full name: Oracle Real Application Clusters, that is, Oracle Real-Time ApplicationProgramCluster, so that different applications can access multiple Oracle instances as if accessing one Oracle instance (of course, the performance is

I encountered ORA-28000: the account is locked in this situation because I logged on to Oracle on the remote server and also logged on locally, so Oracle was locked, I read a lot of information on the Internet and looked at my big head, so I finally

Computing time difference is a common problem of ORACLE data types. Oracle supports date calculation. You can create expressions such as "date 1-date 2" to calculate the time difference between the two dates. Once you find the time difference,

I. Databases A database is a collection of data, while Oracle is a software system that manages these data sets. It is an object-relational database management system.  Ii. tablespace Tablespace is the logical ing between Oracle and the data

Some people said that they would first delete a user and then create the user. I want to delete all tables under this user, but do not delete others. 1. query all tables under this user: Executed under this user (no result, because it should not

Tablea Columna columnb A 1 & 2 SSS   Select * from a where Columna like '% 1 & 1000'; ------------------ the system prompts you to enter a variable. What if I want to query SSS Based on the clomna value? Analysis: & is a variable character

This article was transferred from the Oracle website. Although this article is from Oracle, there are some advertisement components, but I think the big-sector content is still true. We will not see from this comparison that the advantages and

This article is based on 17th articles on Oracle architecture and management. Ii. network host structureNetwork host structure, that is, multiple Oracle hosts form an oracle host system. Each host communicates with each other through Oracle Net

Oracle parameter file (1)In Oracle databases, parameter files contain all database configuration information, which is very important. I think that if you want to manage Oracle well, you must be well aware of the parameters and parameter files.

1. Permission OverviewPermission is the user's power to execute a function. In Oracle, permissions are divided into system permissions and entity permissions based on different system management methods. System permission refers to whether

I. system global zone (SGA) Data in the global zone of the system is shared by multiple users. When the database instance is started, the memory in the global zone of the system is automatically allocated. SGA is divided into data buffer, log

Maxactive is the maximum number of activated connections. The value is 20, indicating that a maximum of 20 databases can be connected at the same time..   Maxidle is the maximum number of idle connections. The value here is 20, indicating that 20

Normal equal connections:Select * from a, B where a. ID = B. ID;This is an internal connection. For external connections:"(+)" Can be used in Oracle, and 9i can use left/right/full outer join. Left Outer Join: left Outer JoinSelect E. last_name, E.

Function calls in other languages Java function call   Create a Java resource in the Oracle database, or use the loadjava command to load other Java classes or jar   Create or replace and compile Java sourcenamed mytestjavaPublic class factorial

This article studies the usage of Oracle database objects. Oracle contains five database objects: alias, sequence, view, index, and cluster. the alias and sequence are specific database objects in Oracle. Alias: After setting an alias for an ORACLE

Functions in the database include the following four parts: Declaration, return value, function body, and Exception Handling. Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->1 create or replace

Create a table Create Table atable ( Test1 varchar2 (20 ), Test2 varchar2 (20) ); Create a stored procedure Create or replace procedure testd (para_1 in varchar2, para_2 out varchar2)Begin-- Select into para_2 from atable where test1 =

I. Features of SQL LoaderOracle has many tools for data migration, backup, and recovery. However, each tool has its own characteristics.For example, exp and IMP can be used to export and export data in the database, which is a good tool for database

Oracle tiger trigger instance-- Instance 1 ------------------------ -- Create a trigger. When you execute DML statements on the test table, the related information is recorded in the log table. -- Create a test table Create Table Test ( T_id number (

Reprinted from: http://www.iteye.com/topic/82587   The data dictionary dict always belongs to the Oracle user SYS.1. User:Select username from dba_users;Change PasswordAlter user spgroup identified by spgtest;2. tablespace:Select * From