Oracle

1. First introduction to the Environment Operating system: Windows R2 (64bits) Oracle database: 10GR2 10.2.0.3.0 (32bits) MySQL database: 5.1 (32bits) 2. Download MySQL ODBC driver, I use the Mysql-connector-odbc-5.3.4-win32 and Installation Note:

Exp/imp is an executable file under the operating system placed in the directory/oracle_home/binThe Exp/imp tool compresses data backups from a database into a binary system file that can be migrated between different OSesIt has three modes:A. User

About Oracle data paging retrieval SQL syntax, the network is everywhere, a variety of, this is also the author I search on the network of the more representative of the grammar, not my original, posted here, purely to let the "data page series"

Today found a problem, a length set to 2000 bytes of the field, inserting a length of 1000 Chinese characters data, unexpectedly error.A Chinese character accounts for two bytes, which is arguably exactly 2000 bytes. However, by looking at the log,

--Create Employee-- ------------------------- DECLARELc_employee_number per_all_people_f.employee_number%type: = ' WRKNO1000001 ';LN_PERSON_ID Per_all_people_f.person_id%type;LN_ASSIGNMENT_ID

---------------------------Eclipse---------------------------Java was started but returned exit code=13C:\ProgramData\Oracle\Java\javapath\javaw.exe-dosgi.requiredjavaversion=1.6-xx:maxpermsize=256m-xms512m-xmx1024m-jar d:\android\adt-bundle-windows-

--User sql>--Create a user named Grace password is password, the new user does not have any rights sql> create user grace identified by password; Authentication User: Password authentication method (Username/password) External authentication method (

Just to implement a function, so write only one method, for easy invocation, set as static method1 Packagecom.jv;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 6 Public classLianjie {7 8 //static method Gets the Connection

Extending the capabilities of the database Provide SQL functionality access to PL User SYS owns all packages It's a public synonym. can be accessed by any user Some built-in packages Package Name

Oracle table partitioning is divided into four types: range partition, hash partition, list partition, and composite partition.One: Range partitioningis to partition partitions based on the range of values of a field in a database table, for example:

Preface:                      cannot guarantee 100% pass, each system will be more or less different, If some of the dependencies are missing, please also forgive  1, install Apache need to compile and install the package, the official website

Chapter One: Log Management1.forcing Log Switchessql> alter system switch logfile;2.forcing checkpointsSql> alter system checkpoint;3.adding Online Redo Log groupssql> ALTER DATABASE Add logfile [Group 4]Sql> ('/disk3/log4a.rdo ', '/disk4/log4b.rdo '

SELECT b.*,RANK () over (PARTITION by B.dname ORDER by B.sal) as Rank_num,Dense_rank () over (PARTITION by B.dname ORDER by B.sal) as Dence_rank,MIN (SAL) KEEP (Dense_rank first ORDER by B.sal) through (PARTITION by B.dname) as First_val,MAX (SAL)

The storage structure of Oracle database is divided into logical storage structure and physical storage structure. First, logical storage structureThe logical storage structure mainly describes the internal storage structure of Oracle database, that

Some time ago on the local XP system to test some of the integration of JavaBean form example, want to publish to the server segment to see if it works properly, at first think it will be the same as the local XP system, deploy to the relevant

Automatically delete log script files:Link: http://pan.baidu.com/s/1mg0EnQo Password: 4uitPreparing for the database before installation[Email protected] ~]# Vim/etc/sysconfig/network-scripts/ifcfg-eth0 #配置IP地址DEVICE

Switch among the three Protection modes of DGbroker and the protection mode of dgbroker 1. Three protection Modes -Maximum protection In Maximum protection, the slave database and master database data are exactly the same, so that zero data loss

Definition formats of basic Oracle statements Oracle built-in data typesI. character data1. char (size)2. varchar2 (size) is the most commonly used, with a maximum length of 4000 bytes.3. nvhar (size) and nvarchar (size)4. varchar (size)5. We

Insert --- insert record, insert --- insert Insert into table_name (column1, column2 ,.......) Values (value1, value2 ,......); Example: Insert into userinfo (Name, sex, num) Values ('john', 'male', 100001 ); Note: 1. column must correspond

Oracle11g system-level trigger to track drop misoperations Preface:The data in a table in the db is always disordered. I guess I 've experienced data synchronization operations such as drop and create, but no one knows where to operate it now,