Oracle

1. Unlock the user Alter user Scott account unlock; 2. log out, disconnect, and switch the current user connection Quit Conn Scott/Tiger 3. user permission Query A. View All Users: Select * From dba_users; Select * From

By default, a PL/SQL external is installed.Program(EXTPROC) Entries in listener. in ora, It is a listener that Oracle calls the default configuration of external programs. Its name is EXTPROC or plsextproc, but it is generally not used and can be

1. Whether it is configured as a shared server. The most important parameter is8i mts_servers9i shared_serverShow parameter shared_server mts_serversIf the value is greater than 0, the Shared Server is enabled. 2. When configured as a shared

Oracle Spatial: spatial concepts1 What is Oracle Spatial?Provides SQL schema and functions to facilitate the storage, retrieval, update, and query of a set of spatial features.MDSYS provides the type of geographic data2 object-relational

If you directly execute SQL statements or bind parameters, you don't have to worry too much, See the following Oracle stored procedures Create or replace procedure kjdatepoc (date D) As Begin Insert into kjdatetable values (d ); Commit;

Respect copyright for any reposted content. (Author: iihero on csdn) 1. How to Create a Java stored procedure? There are usually three methods to create a Java stored procedure. 1. Use Oracle SQL statements to create: E.g. Use create or replace and

How is the Oracle consistent gets calculated? 1. Single Table Scan SQL> execute show_space ('test1', 'wwj '); Unformatted Blocks ...... FS1 Blocks (0-25) ...... FS2 Blocks (25-50) ...... 1 FS3 Blocks (50-75) ...... FS4 Blocks (75-100) ......

Database Version: Oracle 10.2.0.5-64Number of nodes: 2Operating system version: centos 5.6-64 Awr report today finds gc buffer busy wait time Gc buffer busyThis wait event, also known as global cache buffer busy prior to Oracle 10g, specifies the

The quick refresh mechanism of Oracle materialized view is completed by materialized view logs. How can Oracle quickly refresh multiple materialized views through a materialized view log? This article briefly describes the refresh principle.        

DBAs often encounter unlocking Oracle users in their daily work. This article describes how to unlock Oracle users using the command line, you can use several simple unlock statements to complete this task. The specific process is as follows: Scott

Method 1: use SQL * LoaderThis is a lot of methods, as long as the target table already exists in oracle Data. The general steps are as follows:1. Compare the excelfile with a new file. For example, the file name is text.txt. Select a text file for

DBAs often encounter unlocking Oracle users in their daily work. This article describes how to unlock Oracle users using the command line, you can use several simple unlock statements to complete this task. The specific process is as follows: Scott

1. view the currently unlocked object Example: Execute select * from aa for update to lock the table aa; Method 1: query by SQL Select 'alter system kill session ', ''' | trim (t2.sid) |', '| trim (t2.serial #) | ''';' From v $ locked_object t1,

1. The case when expression has two forms: Copy codeThe Code is as follows: -- simple Case Function CASE sex WHEN '1' THEN 'male' WHEN '2' THEN 'female' ELSE 'others' END -- Case search function CASE WHEN sex = '1' THEN 'male' WHEN sex = '2' THEN

1. transactions are used to ensure data consistency. They are composed of a group of related DML statements. The operations performed by the group of DML statements are either confirmed or canceled.2. When a transaction (DML) is executed, Oracle

Problem description: when creating a view under the scott user, an error is reported: the permission is insufficient. (Other users and so on) Solution:Log On As A dba user[SQL]Copy codeThe Code is as follows: sqlplus/as sysdba Grant scott the

The following error is always reported when you manually configure the EM of Oracle11g: WARNING: ORA-00001: uniqueconstraint (SYSMAN. PARAMETERS_PRIMARY_KEY) violated ORA-06512: at "SYSMAN. EMD_LOADER", line4986 ORA-06512: atline1. No solution was

When two concurrent transactions access the same row in the database table at the same time, there may be three problems: 1. Fantasy read: Transaction T1 reads a statement that specifies the where condition and returns the result set. At this time,

In a project, may use two types of data, such as ORACLE, MS_SQLSERVER at the same time to use, MS-SQL data generic class in many tutorials there are ready-made examples and code, but ORACLE is rare, however, this project is very useful and shared

Buffer: the buffer for downloading data, in bytes. It is dependent on the operating system by default. Consistent: the data involved during the download process is read only. The default value is n. Direct: Use the pass-through method. The default