Database Administrator

Environment: Oracle 10g 10.2 There is a text data in the following format: HLR_CODE HLR_TYPE REGION_CODE AREA_CODE PROV_CODE BUREAU_CODE VALID_DATE EXPIRE_DATE MODIFY_DATE1 1302309 1 565 565 551 Z00 2000-1-1 2020-12-31 23:59:59 20:22:562 1302310 1 21

Oracle 11g Create or replace procedure skeletonISBEGINBeginInsert into a values (10 );BeginInsert into a values (11 );End;End;Begin-- Savepoint ps;Insert into a values (20 );Commit;End;BeginInsert into a values (30 );End;Insert into a values (40 );--

1. What is registration? Registration is to register the database as a service to the listener. The client does not need to know the Database Name and Instance name. It only needs to know the service name provided by the database to external users

Oracle has been installed many times in both Linux and Solaris, and almost never succeeded. At the beginning of the installation, I couldn't even see the installation page. Later, I can see the installation page. Some errors will be reported during

Oracle BBED (oracle block browser and editor tool)Installation and Use   BBEDTools can be used to change dataBlockBut not officially supported.   The installation process is as follows: $Cd $ ORACLE_HOME/rdbms/lib $Ls-al * bb *. o -Rw-r --1

Major Data Types of database Classification All object hava a name and atype, and each object is owned by a schema. -- Query the main object types of a Database Selectobject_type, count (object_type) from dba_objects Group by object_typeorder by

1)Role of Wallet Starting from Oracle 10g R2, any user can log on to the database without a password by using Oracle Wallet (non-operating system authentication ), this is very useful for scripts that use user passwords to log on to the database for

Because the RedHat Linux 5 system is launched 10 Gb later than Oracle, the official documents only support Oracle 10 Gb installation in RedHat 4. 1. You need to modify the operating system configuration file of RedHat 5 and change RedHat 5 to

Insert into, replace into, insert ignore, replaceignore I recently discovered that mysql insert statements have so many usage cases. Here I will share with you. ① Insert: Insert into table_name values (); Insert into table_name (column) values

How to Use JDBC to start Oracle auto trace, jdbcoracleSometimes we need to track and analyze the specific execution process of SQL statements, especially when the application performance is optimized. Two Oracle tools can help us analyze performance.

Let you know software development in advance (34): Database Maintenance Part 1 Database SQL language Database Maintenance   For some large software products, once commercialized, a lot of user information will be stored, which is the database used

1. Configure the Publishing ServerOn the Publishing Server, perform the following steps:(1) select [configuration Publishing, subscription server and Distribution] from the [copy] sub-menu in the [tools] drop-down menu to see the configuration

Nomorlization) 1NF: atomicity, that is, each field cannot be separated. 2NF: uniqueness, that is, each table describes only one entity. This entity must have a primary key. non-primary keywords must be fully dependent on the primary key because

Install omsBefore logging on to oms, you must first install the oms service. Start Oracle universal installer, check the installed products, and expand oracle main directory-oraHome92. If oracle9i management and integration is not available, it

Check whether the installation has been installed:Yum list installed mysql *Rpm-qa | grep mysql * Check whether the installation package is available:Yum list mysql * Install the mysql client:Yum install mysql Install the mysql server:Yum install

In addition to using files or SharedPreferences to store data, you can also choose to use the SQLite database to store data.On the Android platform, an embedded relational database-SQLite is integrated. SQLite3 supports NULL, INTEGER, REAL (floating

Preface I have recently studied MongoDB, mysql, MSSQL, and Oracle, but they are all SQL-based and table-based relational databases. I understand it, but I know something about it. MongoDB is based on documents. So what is MongoDB? Five Things should

• Describes the options for restoring data faults • use the new RMAN data repair command to perform the following operations: -List faults-receive repair suggestions-repair faults • Perform preventive fault checks • query the data recovery guidance

1. Automatic growth of identityApplicable to MySQL, DB2, and ms SQL Server. It uses the primary key generated by the database to generate unique identifiers for long, short, and int types.Use auto-increment fields of SQL Server and MySQL. This

Recently, I found that there are more or less many problems in the online articles on creating a library with bare devices bound to linux lv, which is easy to mislead beginners. Therefore, I sorted out the preliminary steps for directly creating a