Oracle

Oracle first day 1.oracle database download, install, and configure 1.1 download the archive and overwrite the files inside the package 2 to compress Package 1 1.2 Follow the steps to install the 1.3 Setup Administrator password, by default four

BLOBs and Clob are large field types, blobs are stored as binary, and CLOB can store text directly. The two are interchangeable, or you can use LOB fields directly instead of the two. But in order to better manage the Oracle database, usually like

Stored procedures are not used in small companies, but if the business is complex or the performance requirements are more stringent when the stored procedures come in handy, some of the earlier version of Ibatis does not seem to support stored

Pl/sol (Procedure Language/sol) is a relatively complex programming language for accessing Oracle databases in a variety of environments, integrated with database servers.Oracle three-tier modelThe user interface (for example, the client browser)

The original web site data is stored in SQL Server, which combs the field relationships of the data tables and needs to be imported into the Oracle database. Several solutions are available online. One is to export directly to servers with SQL

"Go" Oracle Set operation functions: Union, intersect, minusThe set operator is specifically used to combine the results of multiple SELECT statements, including: Union, union All, INTERSECT, minus. When you use the SET operator, you must ensure

Oracle CREATE TABLE space SYS users log in as DBA under CMD: Play Sqlplus in cmd/Nolog and then Conn ./ asSYSDBA--to create a path if the path does not exist--Create a temporary table spaceCreate Temporarytablespace txwh_temp

Exception handlingCreate or Replace procedurePr_test3 (V_BHinch varchar2, v_xx out T_hq_ryxx%RowType isbegin Select * intoV_xx fromT_hq_ryxxwhereBianh=V_bh;ifSql%Found ThenDbms_output.put_line ('find the data.');ElseDbms_output.put_line ('No data

Create or Replace procedurePr_test1 isV_case Number(3) := -;--Defining Variablesbegin--/ * Judgment Statementif 2>1 ThenDbms_output.put_line ('conditions established'); ElseDbms_output.put_line ('conditions are not tenable'); End if; if 21

The set operator is specifically used to combine the results of multiple SELECT statements, including: Union, union All, INTERSECT, minus. When you use the SET operator, you must ensure that the number of columns in different queries matches the

Original address: http://www.oschina.net/question/30362_4057First, the concept of ROWIDStores the location of row in the data file: 64-bit encoded data, A-Z, A-Z, 0-9, +, and/,How row is stored in the data blockSELECT ROWID, last_name from

1. Creation of tablesCreate table student02 (Sno number);　　2. Deletion of tablesDrop table student02;　　3. Renaming a tableRename student02 to student01;　　4. Changes to the tableALTER TABLE student01--column modification add OB numbermodify ob

Sql>SelectName,open_mode fromv$pdbs;name Open_mode------------------------------ ----------pdb$seed READ ONLYPDB1 MOUNTEDPDB2 mountedsq L>Alter pluggable database all open; Pluggable database altered. SQL>SelectName,open_mode fromv$pdbs;name

The following is some products, tools, and utilities you can use to achieve your goals as a database administrator:1. Oracle Universal InstallerOracle Universal Installer (OUI) is a utility that installs your Oracle software and options. It can

In the near future, according to the project business needs to the Oracle materialized view has the contact, searches on the net on this aspect information, facilitates enhances, the collation content as follows:Materialized views are a special

Manage and monitor streamsPart 1 routine management of the stream environment 1. capture Process Management-capture Process information set linesize 200 COLUMN CAPTURE_NAME HEADING 'capture | Process | Name 'format A15COLUMN QUEUE_NAME HEADING

Date calculation, date Calculator Database environment: Oracle 11g R2 I haven't written a blog for a long time. The main reason is that I have met some of the requirements I have done in my blog before, so I am too lazy to sort them out. Question:

Case study of downtime caused by ORA-04031 errorsToday we met an ORACLE database downtime case. The following describes the causes of this database downtime case. In the analysis process, we will record the cause and effect of this case, accumulate

Oracle + mybatis uses dynamic SQL to implement batch insert when the inserted fields are uncertain. oraclemybatis Recently, the project encountered a very tangled problem. Due to the business relationship, the database data table cannot be

ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor When PL/SQL is connected to the Oracle database, the error "ORA-12514: TNS: The Listener currently cannot identify the Service requested in the