Oracle

The oracle wm_concat (column) function is frequently used. The following describes how to use the oracle wm_concat (column) function to merge fields. If you use the oracle wm_concat (column) function) if you are interested in function usage, take a

Oracle stores data through corresponding algorithm conversion in the database. This article briefly introduces the Number-type data storage and conversion of Oracle. This article aims to answer question No. 2119 on the message board.We can use the

SQL codeCopy codeThe Code is as follows:Select count (*) from user_objects where object_name = upper (p_table_name );Select count (*) from user_tables where table_name = upper (p_table_name );Create or replace procedure p_drop_table_if_exist_v1

The server is windows server 2003. After the oracle client is installed normally, when data is inserted, all Chinese characters are displayed ?. Exception: Enter select userenv ('language ') From Dual in the PLL/SQL statement, and the result is

During work, you need to import data from the GIS_WEICHAI_DATA_1S table in one database to the GIS_WEICHAI_DATA_1S table in another database. The database servers are all remote ! My implementation method is to use PL/SQL locally to operate two

UPDATE1. Back up data first (security and performance improvement ).2. Batch update and batch commit to prevent lock tables.3. If the updated index automatically has a large volume of data, the index will be canceled first and then re-created.4.

 Automatic Workload RepositoryIt is an important component introduced by 10 Gb.Stores the detailed information and information about the database activity status in the recent period. The default value is7DaysThe predecessor of AWR is Statspack,

When writing another stored procedure, the following SQL statement is used:Copy codeThe Code is as follows:Select max (RE_DATE) INTO V_RE_DATEFROM T_RECORDINGWhere id = '000000' It is reasonable to say that the query result based on this condition

Dbms_random is a random function package provided by oracle. The following describes common examples of dbms_random:Dbms_random.value usage:Generate a 38-digit decimal number greater than or equal to 0 and less than or equal to 1Copy codeThe Code is

There are two methods:One is to declare the system cursor, the other is to declare the custom cursor, and then follow the same operation, the parameter type isIn out or out(1) Declare the personal system cursor. (recommended)Copy codeThe Code is as

The oracle table demo operation statement may be used during the development process. This article will introduce it. If you need it, referSQL codeCopy codeThe Code is as follows:-- Created on 2010/07/29 by WANGNANDeclare-- Local variables hereI1

Today I encountered a strange problem:Using sqlplus on the client allows normal users to log on, but neither system nor sys users can log on, prompting ORA-12154: TNS: unable to resolve the specified connection identifierSQL> conn system @

Unlike SQL Server, Oracle uses Select to return the result set in the stored procedure, but returns the result set through Out parameters. It is actually using REF CURSORCopy codeThe Code is as follows:-- Procedure:-------------------- Declare a

Go to sqlplusSQL> set timing onSQL>SQL> select count (*) from comm_human_role;COUNT (*)----------866Elapsed: 00:00:00. 05The preceding digital outputs are: Hours: Minutes: Seconds. Milliseconds.It takes 0.05 seconds to execute, which is equivalent

A union array is previously called a PL/SQL table. Union arrays cannot be used in tables. They can only be used as structures for programming. Union Arrays can only be accessed in PL/SQL.It is very important to note some key issues brought about by

Software environment:1. Operating System: Windows 2000 Server2. Data Base: Oracle 8i R2 (8.1.7) for NT Enterprise Edition3. installation path: C: ORACLEImplementation Method:1,D:> set NLS_LANG = AMERICAN_AMERICA.USACII7OrD:> set NLS_LANG =

Copy codeThe Code is as follows:Create table T_NEWS(Id number,N_TYPE VARCHAR2 (20 ),N_TITLE VARCHAR2 (30 ),N_COUNT NUMBER)Prompt Disabling triggers for T_NEWS...Alter table T_NEWS disable all triggers;Prompt Loading T_NEWS...Insert into T_NEWS (ID,

Raise a code segment and ask for help.The code snippet is as follows:Copy codeThe Code is as follows:DeclareType t_indexby is table of numberIndex by binary_integer;Type t_nesteed is table of number;Type t_varray is varray (10) of number;V_indexby t_

Create or replace procedure PROC6338196642095312503719 (enter the news topic Varchar2, enter the news content Varchar2, enter the publishing time Varchar2, enter the current page Number, enter the Number of lines per page, and output the current

First, exp unload the data to the file system to generate. dmp file, and then the data is loaded into the database by imp when necessary. for small and medium databases, the dmp file generated by the full database exp may be less than 2 GB, but for