Oracle

Recently, the company used Ibatis development projects, can use stored procedures to deal with bulk inserts, batch modification and multiple sets of conditional query; But since the use of modules is relatively small, temporarily in the XML

Database backup Everyone knows that regular backups are scheduled daily, but few people do the verification of backup files. Once we need to use the backup file, the backup file is really damaged and it's sad. It is necessary to do the backup

For Oracle stored procedures, throwing exceptions can be thrown into code or logged with a table. If your system application has a lot of nodes, like 40 of our nodes, if the wrong throw into the code, the error can not be found at all, it is best to

A RAC cluster of a newly installed Oracle 11GR2Three nodesCreate a good database, everything is in normal progressThen went to install an Oracle client, and when the link was made there was a ORA-12545Then a simple Baidu, some people say is 11gr1

It is very rare to say that a sequence is known because both MySQL and SQL Server have auto-grow fields (such as integers where the ID primary key automatically grows), and Oracle does not provide that usage.then Oracle provides a more flexible and

I. Overview　Other database objects　　　　The main mastery is the sequenceSecond, sequence　1. What is a sequence　　Sequence: A database object that can be used by multiple users to produce unique valuesAutomatically provide a unique valueShared objects　　　

Throw a question first:I have a table T, and now I want to update 1/4 of the records in my table, my SQL is as follows:Update t set col1= ' 123 ' where mod (rownum,4) =1Can I get the results I want?The answer is: No.Let's illustrate by an experiment.

In theOracle spatial Partitioning application Research: partition and sub-table query performance comparison has been explained: by the county partition + Global Spatial index efficiency is better than by county partition + local spatial index, so

Summarize Oracle system views and table Daquan:Dba_ opening .....Dba_users Database user InformationDba_segments Table Segment InformationDba_extents Data Area InformationDba_objects Database object InformationDba_tablespaces database table Space

Julian Date DefinitionJulian Date: The valid date range is from January 1, 4713 BC to December 31, 9999. Julian Date is the number of days elapsed since 12 o'clock noon January 1, 4713.Using it Julian date allows us to calculate how many days

1.package com.oracle.util;Importjava.sql.Connection;ImportJava.sql.DriverManager; Public classDbutil { //application for connecting Oracle database Private Static FinalString jdbcname= "Oracle.jdbc.driver.OracleDriver"; Private Static FinalString

Client Environment parametersNls_lang = Language_territory. Character_setDescription is as followsParameter DescriptionLANGUAGE Specifies the LANGUAGE and conventions for displaying messages, day name, and month name.TERRITORY Specifies the

Same point:1.truncate and delete without a WHERE clause, and drop deletes the data in the table.2.drop, truncate are DDL statements (data definition language) that are automatically committed after execution.Different points:1. Truncate and delete

Description Table functions can accept query statements or cursors as input parameters, and can output multiple rows of data.The function can be executed in parallel and can continuously output data streams, which are called piped

First, what is a view　　A view is a custom display of data from one or more tables, but a view is considered a virtual table or stored query, and the table on which the view is created is called the base table. The view provides another level of

1.Select query data in the tableSelect * from Stu;---Query the stu table for all data, * represents all2.dual , pseudo-table, the data to be queried does not exist in any table when usedselect sysdate from dual;----Query the current time of the

After installing the ORAFCE plugin, Pgsql can be compatible with some of Oracle's tables, functions, and data types,ORAFCE already contains the following content　　The specific installation method is as follows:1.

Oracle asm command instructions, oracleasm instructions 1. Runtime EnvironmentLinux: Centos 6.5 Oracle: 11.2.0.4.0 2. Oracle asm command instructions [root@strong ~]# oracleasmUsage: oracleasm [--exec-path= ]    [ ] oracleasm

What should I do if the Oracle control file is lost ?, Oracle control loss What should I do if the control file of Oracle is lost? If you have a text backup control file, you can use the text backup control file. SQL> ALTER DATABASE BACKUP

Solution to the Chinese garbled characters inserted by PLSQLDeveloper This is because the character encoding on the oracle server is inconsistent with that on the Oracle client. Check the character encoding on the Oracle server, and use