Oracle

The following code can be added to the package to modify the language parameters of the current session.--Set Session language     procedure p_set_nls_language (pi_nls_lang in varchar2  default  ' Simplified chinese ')  IS    BEGIN     

After you open the database with Resetlogs before oracle10g, the previous backup cannot be used for recovery. That is, you cannot perform a recovery across resetlogs points in time. Therefore, a full library backup is required immediately after

It seems that some people still do not understand the true meaning of the schema, and now I have to tidy up a bit, I hope to be helpful to everyone.Let's start by looking at their definition:ASchemais a collection of the database objects (used by a

[Original link] http://nvd11.blog.163.com/blog/static/200018312201301310585758/[Original VIDEO] Http://www.jiagulun.com/thread-2674-1-1.html1. Database filesThe Oracle database file can be divided into 3 types, namely:control files: storing the

When you create a database, we may write many scripts that create a table structure. If many of these scripts are significantly inefficient to execute scripts one by one, how to execute scripts in bulk.First, put all the scripts into a

Original address: http://blog.csdn.net/zhldt2008/article/details/79539321. The following statement queries the locked table:SELECT l.session_id Sid, S.serial#, L.locked_mode,l.oracle_username,L.os_user_name,s.machine, S.terminal, O.object_name,

Two days ago colleagues asked an oracle to use grouping to complete a statistical report function, this function is handsome. Developing a grouped report directly a SQL is done.Grouping (ColumnA) function means: If the current line is generated by

[Email protected] sql>delete from scott.emp;14 rows deleted. [email protected] sql>select s.sid, s.serial#,  2      case bitand (T.flag, power (2, 28))   3         WHEN 0 THEN  ' read committed '   4         ELSE  ' SERIALIZABLE '

Borrowing the experience of othersThe client Oracle server enters the PL/SQL developer times ora-01033:oracle Initializationg or shutdown in progress error message that the application system cannot connect to the Oracle service. Solve the problem

A. DownloadHttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html the following two Web site source this official download page Web.Win 32-bit operating system:Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2

I. Define JobDeclareJob Number;begindbms_job.submit (Job=Job, what='PROC1; PROC2;', Next_date=sysdate, Interval= 'TRUNC (sysdate+ 1)) ';--synchronize once every morningCommit;End;Second, the function of trunc to TIME1.select trunc (sysdate) from

1. Create a tableCREATE TABLE Emp_test (ID number (5,2) PRIMARY KEY, NAME VARCHAR2 (a) UNIQUE, BIRTHDAY DATE);--Modify Table nameALTER TABLE emp_test RENAME to TEST1;  --modify table column name alter TABLE emp_test  rename COLUMN name

First, on the official website of Oracle Download compressed package, I am win764 bit machine.Second, choose to extract two files to the current directory, then the database folder will be generated in the diagram, this article is in the

If there are more than 10 indexes on a table, how do you feel? Obviously it will slow down, delete, change the speed, do not expect developers to build index. My approach is to monitor a long period of time to see which indexes are not used, and

First, the controller if (!defined (' BasePath '))Exit (' No Direct script access allowed ');Class Topics extends Ci_controller{function __construct (){Parent::__construct ();$this->load->helper (' url ');$this->load->helper (' form ');Note that the

Create a partition table in Oracle 1. Create partitions by month Create table T_MHDP ( ID VARCHAR2 (50) not null, FLT_AIRCODE VARCHAR2 (4 ), FLT_NUMBER NUMBER (7 ), FLT_DATE DATE ) Partition by range (FLT_DATE) ( Partition PART201105 values less

Oracle modifies the default character encoding -- View the Oracle database character set: SQL code Select userenv ('language') from dual; Query results: SIMPLIFIED CHINESE_CHINA.AL32UTF8 -- Modify the character set of the oracle database: (in SQL

Install Oracle 10g (redhat 4) and oracleredhat in Linux -- Note: This article only installs Oracle and does not create a database.1. Install a readhat 4 System in the Virtual Machine. 2. Configure the IP address. The configured IP address is as

Oracle11g's dependence judgment reaches the field level In Oracle 10 Gb, the dependency only reaches the object level. That is to say, once the object accessed by the Stored Procedure changes, Oracle sets the stored procedure to INVALID. Therefore,

Oracle Installation text tutorial in VMware linux environment (1), vmwareoracle Installation Process: Preparations ---> install ORACLE software ---> install and upgrade patches ---> install odbc to create a database ---> install listeners --->