Oracle

Sdo_geometry type in Oracle spatial: CREATE TYPE Sdo_geometry as OBJECT ( Sdo_gtype number,--geometry type, such as Dot line surface Space reference coordinate system of Sdo_srid number,--geometry Sdo_point Sdo_point_type,--If geometry is a point

Listagg (column name, ' Split symbol ') Oracle 11g above a multiple-row query result with the specified column name merged into one line with the specified split symbol: For example: Table raw DATA: Requirements: The data in the

Reprinted from: http://blog.csdn.net/redarmy_chen/article/details/7351410 Oracle Two-time subtraction default is days Oracle Two-time subtraction default is the number of days *24 to the difference in hours Oracle Two-time subtraction the default

1, oralce website download installation odtforvs2015_121025 Restart vs 2. Project Reference Oracle.ManagedDataAccess.dll 3. Database connection string: User id=xxxx;password=xxxx;data SOURCE=192.168.0.XXX:1521/ORCL (database name) 4, the use of

Sql> Conn/as SYSDBAConnected to a idle instance.Sql> StartupOracle instance started. Total System Global area 276824064 bytesFixed Size 778736 bytesVariable Size 137371152 bytesDatabase buffers 138412032 bytesRedo buffers 262144

Frequently, colleagues consult Oracle database character set issues, such as data migration in different databases, exchange of data with other systems, and so on, often because of different character sets that cause migration to fail or the data in

Grouping functions By learning the group function today, we have the following learning content. 1, what is the grouping function. A: A grouping function acts on a set of data and returns a value for a set of data. 2, the common grouping functions

C:\documents and settings\administrator>sqlplus /nolog    sql> connect  system/password  as sysdba    connected.    sql> shutdown normal    ora-01109:  Database not open           has uninstalled the database. The    oracle  routine has been closed.

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

If you store a tree structure in a table, you need to deposit two field IDs and ParentID in the tables, indicating who the parent of each record is. Table:treetable Id ParentID Field 3 ...... 1 Null A

The Show_space version is available on the web for a number of editions. Today, a generic version is sorted out for later use. Create or Replace procedure Show_space (V_segment_name in Varchar2, V_segment_owne

First, use the following command to move: ALTER TABLE table_name move tablespace tablespace_name; Then, if there is an index, the index must be rebuilt: Alter index index_name rebuild tablespace tablespace_name; Of course, you can use spool to

Parameter control of an audit functionThe value of the Audit_trail parameter can be set to the following1. None: Not open2. DB: Open Audit function3. OS: Audit records are written to an operating system file.4. TRUE: Same as parameter db5. FALSE: Do

With the rapid development of information technology and the deepening of enterprise information construction, the number of enterprise business system is increasing. At this time, the data interaction between the business systems, the data

In some cases, we need to use a recursive method to organize the data, which is very easy to do in the program, but in the database, how to implement the SQL statement. Below I describe how to use recursive queries in Oracle with the most typical

Environment: MyBatis + oracle11g R2 1. Use Direct path insertion ("/*+append_values/" in the following SQL statement) and use the keyword "union ALL": INSERT INTO/*+append_values * * T_ Uid_code (C_uid_code, C_serail_len,

Recently because the project needs to write stored procedures, has not been written before, contact is contact with, in the soft through the time contact, it is Huawei's project that a few stored procedures are very complex, but also very messy,

Format of PivotSelectFrom (Inner_query)Pivot (aggreate_function for pivot_column in (list of values))Order BY ...;Examples of usage:Select From (Select Month,prd_type_id,amountFrom All_sales)Pivot (sum (amount) for month in (1 as jan,2 as feb,3 as

The requirement for TRUNCATE permissions in an Oracle document is that a table is required under the currently logged-on user, or the currently logged-on user has the permission to drop any table.However, if the first condition is not met, the

ObjectiveThis paper deals with Odp.net and ODP. NET managed (managed) driver, the Entity framework of the managed drive these three parts of the download, installation, configuration.1. IntroductionNuGet is a. NET Software Development Kit management