Oracle

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

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

I. Overview　　What is a single-line function:Action data Object Accept parameter returns a result only one row is transformed each row returns a result that can be transformed data types can be nested parameters can be a column or a value　　　For

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

Oracle Tablespace (tablespaces)We know that the Oarcle database actually holds the data file (data files), and theoarcle tablespace (tablespaces) is actually a logical concept, He does not exist physically, so a set of data files can be a table

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.

First, create a table:CREATE TABLE Example (ID number (4) not NULL PRIMARY KEY, NAME VARCHAR (25));Then, customize a sequence (sequence):1--1-------not built bufferCreate a second trigger:CREATE TRIGGER Example_triger before INSERT on example for

Workaround:1, first from the most basic start, here to open the computer right-click, select Management2. Find the services and applications inside, open the service 3. Find:Oracleoradb11g_home1tnslistenerOracleserviceorcl4, start the two data

Blob refers to the binary large object is the English binary Large objects written;CLOB refers to a large character object that is written in English character Large object.So both types are designed to store large amounts of data, where blobs are

One, decode () function1. GrammarDECODE (Control_value,value1,result1[,value2,result2 ...] [, Default_result]);Control _value: The value you are trying to process. The decode function compares this value to the subsequent sequence of even orders to

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

Restrictions on SQL statements of ORACLE databases-basics, oraclesql /* Change the user password:1. Enter cmd to open the dos window2. sqlplus/nolog3. conn/as sysdba4. alter user system identified by orcl;*/ /**Data Integrity indicates that all data