Oracle

11.2.0.3 the database crashed due to damage to the ASM disk header block and encountered an incorrect ORA-15196.More detailed error: ORA-15196: Invalid ASM block header [KFC. C: 26076] [endian_kfbh] [256] [0! = 1]Further checks have found that the

To simplify the process, I have created a unified database check account on multiple ORACLE data, and my account can only access several specific views (the SQL statements to be queried have generated views ), the procedure is as follows: Root>

Insert into table (testcol) values ('') The testcol field has been designed as not null during design, but we need to know that in SQL Server, null and space are different, that is, the preceding statement inserts an empty field, but is not null.

I have read a document called "penetration: from application down to OS (Oracle)" over the past few days. It is very interesting. The general meaning of this document is, if the Oracle service is started with the Administrator account, you only need

Use the dbms_random package of Oracle combined with rownum. For example, 499 users are randomly selected: Select * from (Select * From Busi. t_ar_userinfo order by dbms_random.value) Where rownum: References for dbms_random, link:

First, let's talk about MS Server. Because I am a newbie, I first chose to use the Enterprise Manager for task settings and then export the designed task script, in this way, you can directly execute scripts in other databases to create a task (you

The first case is that the returned cursor is the data of a specific table or view, for example: SQL-code: CopyCode The Code is as follows: Create or replace procedure p_testa ( Presult out sys_refcursor ) As Begin Open presult for select * from

1. View Overview A view is actually a query SQL statement used to display relevant data in one or more tables or other views. The view uses the results of a query as a table. Therefore, the view can be viewed as a stored query or a virtual

The original statement is as follows: Select sum (sl0000) from xstfxps2 whereDhao00 in (Select dhao00 from xstfxps1 where trunc (ywrq00) = trunc (sysdate)And khdm00 = '000000 ');Time in use: 00: 02: 49.04Execution Plan-----------------------------

During Oracle database manipulation, an error is prompted when logging on to the Oracle account, and the Oracle account is frequently locked. What are the causes of this fault? This article introduces this process and finds the cause of the fault

Oracle has many locks, and the effects of various locks are different. The following describes Oracle row-level locks. Oracle row-level locks only lock the row that the user is accessing. This ensures data security. If the user is modifying a row,

I recently used oracle rownum for paging display, and made further analysis and research on rownum. This is summarized as follows, hoping to benefit everyone. For rownum, it is the number of the row returned from the query that is sequentially

In PD, double-click a table and view its preview label. Then, the create statement of a table is displayed as follows: Copy codeThe Code is as follows: create table Company_Info ( Company_ID NVARCHAR2 (50) not null, Area_ID NVARCHAR2 (50 ), Mem_ID

1) Check the cluster status: [Grid @ rac02 ~] $ Crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online. 2) All Oracle instances (Database status ):[Grid

Resets the oracle sequence from a specified number. Copy codeThe Code is as follows: declare N number (10 ); V_startnum number (10): = 10000001; -- start from the number V_step number (10): = 1; -- step Tsql varchar2 (200 ); V_seqname varchar2 (200):

Note: 1. If you open it in PL/SQL or other tools, directly modify the [italic bold part] in the following code to execute 2. Make sure that the path exists, for example, [D: \ oracle \ oradata \ Oracle9i \], that is, the path of the file to be

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

The following describes the hard-working processes in the background. System Monitor (SMON), Process Monitor (PMON), Database Writer (DBWn), Log Writer (LGWR) checkpoint Process (CKPT) 1. SMON: Install and open the database. Install the database by

1. ASCII Returns the decimal number corresponding to the specified character; SQL> select ascii (A) A, ascii (a) a, ascii (0) zero, ascii () space from dual; A ZERO SPACE ------------------------------------ 65 97 48 32 2. CHRReturns the

The implementation of Oracle regular expressions is in the form of various SQL functions and a WHERE clause operator. If you are not familiar with regular expressions, this article will show you about this new extremely powerful yet mysterious