Database Administrator

Prepare the environment: Oracle 10g online documentation, host with 10g database software configured, oracleasm library rpm package, 2 5 Gb hard disks 1. View local disk Information [Root @ shiyueasm ~] # Fdisk-l   Disk/dev/sda: 16.1 GB, 16106127360

1. OOM Introduction Object-OrientedModel (OOM) object-oriented model. An OOM contains a series of packages, classes, interfaces, and their relationships. These objects form a class structure of all (or part) the logic of a software system design

Oracle locates 1 billion data records: /** The app queries the table and partition where the ID is located by ID, and locates the Stored Procedure for the first 100 table partitions in one table.* Parm id ID* Return table_name table name, par_name

Use JDBC to update and query database instances:   PackageOrg. Oracle. insert; ImportJava. SQL. Connection; ImportJava. SQL. DriverManager; ImportJava. SQL. ResultSet; ImportJava. SQL. Statement;

Loss of updates is a common and classic problem in data. During project creation, we may not notice this problem. However, this problem is very important and sometimes leads to serious results. Next we will discuss this missing update. 1. What is

1. query the first row of records: Select * from table limit 1 2. query records from row n to row mSelect * from table1 limit n-1, m-n; SELECT * FROM table LIMIT 5, 10; returns records FROM 6th rows to 15th rows Select * from employee limit 3, 1;//

I have been using Mysql and Oracle databases for so many years. This time I have to use the C/C ++ language to call the Oracle stored procedure, so I am too lazy to look at the OCI API, I went online to find someone else's encapsulated library, and

To enable Oracle to the nomount state on Windows, enter the following command without starting the oracle service: C: \> sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Friday October 14 16:28:13 2011 Copyright (c) 1982,200 5,

RANK () OVER ([query_partition_clause] order_by_clause) DENSE_RANK () OVER ([query_partition_clause] order_by_clause) You can group and sort the results set of the same group fields by specified fields, Where partition by is the grouping field,

In actual application, multiple insert statements may be executed at a time. I know two ways to share with you: 1. Write the statement block in tools such as PLSQL between begin end, for example: Begin Insert into table values (....); Insert

Normal equal connections:Select * from a, B where a. id = B. id;This is an internal connection.For external connections:"(+)" Can be used in Oracle, and 9i can use LEFT/RIGHT/full outer join.Left outer join: LEFT OUTER JOINSELECT e. last_name, e.

My database (asm storage) is upgraded from 11.1 to 11.2. This function must be upgraded to 11.2 only when the delay section is created today. Check whether my instance's compatible is 11.1.0.0.0. Naturally, I think of alter systerm set compatible =

Some students need to insert images into the table in their projects. The following provides a method for your reference: 1. Create a table. Note: The columns to insert images must be defined as BLOB. Create table image_lob (t_id varchar2 (5) not

ORA-14452: attempt to create, alter or drop an index on temporary table already in use Procedure:1. First query the object_id of the table from user_objects:Select object_id from user_objects where object_name = upper ('ggs _ stick '); 2. Know the

When importing historical data, there is a list query, and the query is normal before the data is imported, but the query error occurs after the data is imported, debug debugging finds that there is a to_number field in the SQL statement that has

A table is the most basic logical unit for storing data in a database. It consists of rows and columns. Oracle divides the table into heap table and index organization table (IOT) and temporary table (temporary table) This section briefly introduces

This is because em cannot find the corresponding font file when generating the button image. Solution: In the Oracle user environment 1. Apply the default font configuration file Cd $ ORACLE_HOME/jdk/jre/lib/ Cp font. properties. zh_CN.RedHat

SQL> conn sys/xin as sysdbaConnected.SQL> set wrap offSQL> set linesize 1001. Some basic operations(1) view the tablespace:SQL> select * from v $ tablespace;(2) view data files:SQL> select * from v $ datafile;(3) view the ing between tablespace and

I. Syntax:TRANSLATE (string, from_str, to_str)Ii. Purpose Replace each character in from_str with a string after the corresponding character in to_str. TRANSLATE Is a superset of the functions provided by REPLACE. If from_str is longer than to_str,

Recently, Spring and Hibernate were used in the project for development. Thanks to Criteria, the query method design allows you to flexibly assemble query conditions according to the features of Criteria. Now we will summarize the usage of Hibernate