Oracle

#!/bin/bash#Purpose: Create and config Oracle install.#Usage: Log on as the superuser (' root ')#1. Create groups and users.Groupadd DBA-G 111Groupadd Oinstall-g 110Useradd oracle-u 110-g 110-g 111echo "Oracle" | passwd--stdin Oracleecho "Export tmp=

1. Change the database character set to GBKSHUTDOWN IMMEDIATE;STARTUP MOUNT EXCLUSIVE;ALTER SYSTEM ENABLE RESTRICTED SESSION;ALTER SYSTEM SET job_queue_processes=0;ALTER SYSTEM SET aq_tm_processes=0;ALTER DATABASE OPEN;ALTER DATABASE National

Transferred from: http://blog.sina.com.cn/s/blog_af26e333010194ht.htmlA recent modification of an Oracle trigger encountered two problems in the process:Select LastName from Hrmresource where ID in (waigaunyanshourens);This SQL as long as the

In Oracle, the non-equal sign has the following options:<>,!=,^=Test SQLCREATE TABLE test ( ID int, name VARCHAR2 (Ten), age int) insert INTO test (id,name,age) VALUES (1, ' Zhangsan ', 23 INSERT into Test (id,name,age) VALUES (2, ' Lisi ', ");

Test preparation Analyze and experiment 1 Processing of fractional parts 2 maximum value that can be saved 3 minimum value that can be saved Summarize The Number data type for Oracle represents decimal

First, the preparatory work1. Insert the Linux installation disk into the optical drive2. Mount the optical drive[Email protected] ~]# mount/dev/cdrom/mnt/Mount:block Device/dev/sr0 is write-protected, mounting read-onlyIf the optical drive does not

A business high concurrency, access to a customer phone to send a special invitation code (code for the word multibyte digital mixed, irregular), code has been stored on the table, business to invite code and user mobile phone number one by one

1. DemandThe application scenario is this:Use Oracle data to save the to-do task, using the status field to differentiate whether the task has been executed. When multiple worker threads perform a task concurrently, the value of the status field is

I. Sql_trace description1.1. In the global enable specified in the parameter file (pfile/spfile): Sql_trace =true 1.2. At the current session level, enable tracing for the current session: Alter session set Sql_trace =true; End Trace: Alter

When querying Oracle database using Plsql Developer and Dbvisualizer, query data is garbled in Chinese.Look at the database encoding formatSELECT * from V$nls_parameters;View the encoded value as WE8ISO8859P1. and the computer environment variable

I. Use RowNum to do three-layer packing inquiry (common scheme)SELECT * from (Select A.* from (select* from) where)where>=The most internal query, select * FROM table_name, represents the original query statement without paging. ROWNUM = 21

List the points of knowledge about OPROCDOPROCD is the introduction of Oracle in RAC to fencing IOUnder UNIX systems, if we do not use third-party cluster software other than Oracle, there will be OPROCD processesUnder the Linux system, only after

After today's shutdown immediate command issued to the test library, the observation log found the following:Tue May 12 09:52:45 2015Shutdown:active processes Prevent SHUTDOWN operationShutdown is blocked by the active process, CTRL + C cannot

1 Importjava.sql.Connection;2 ImportJava.sql.DriverManager;3 Importjava.sql.PreparedStatement;4 ImportJava.sql.ResultSet;5 Importjava.sql.SQLException;6 7 /**8 * Oracle Database-driven class encapsulation9 * @authorAdministratorTen * One */ A

1. Assuming that the field data is empty, you can do it directly, regardless of the field type you are changing to:ALTER TABLE TB Modify (name Nvarchar2 (20));2, if the field has data, then to NVARCHAR2 (20) can be directly executed:ALTER TABLE TB

Previously just simple to use the program to manipulate data, now found that they do not have the system of learning, so want to record their own in the database problems encountered, will refer to the query network some information, now look at the

One of the Oracle Learning Starter SeriesDatabase Development and historyThis Oracle Learning Starter series is based on some of the notes and projects I work on. On the one hand is the accumulation of their own knowledge, to facilitate the

Detailed Connection: http://blog.163.com/lsj_start/blog/static/17826443920111112103716524/http://blog.itpub.net/29324876/viewspace-1096741/(view implicit conversion with explain)Oracle has three of the most basic data types, namely, character,

Tag:jdbc    Connection database     Package Com.util;import Java.sql.connection;import Java.sql.drivermanager;import java.sql.preparedstatement;import Java.sql.resultset;import java.sql.sqlexception;/** * * 2015-3-5 PM 2:45:56 *

Summary of common Oracle operations and summary of oracle1. oracle modifies the table name, column name, field type, adds a table column, and deletes a table column: Alert table scott. test rename to test1 -- modify the table nameAlter table scott.