Oracle

Oracle installed on the CentOS system, the system disk space itself is not very large, after running a period of time to find that Oracle's temporary tablespace occupies a larger disk, so that the system is on the edge of the crash, the method to

Source: http://blog.csdn.net/hzfu007/article/details/6182151Often encounter situations where SQL Server data needs to be migrated to Oracle.Look it up online, there are many ways to use third-party tools, etc., but SQL Server itself provides an

In the case of C # access to the Oracle database, the Oracle client must be installed, and the same version of the server must be installed, otherwise there will be incompatible issues with various versions, so many times we do not need to install

ObjectiveThe date/time of this article is all formatted as "2016-01-01 01:01:01"; monitor_time is the database table field;string and date/time Mutual conversion function OracleDate/Time -to-string function: To_char (t.monitor_time, ' Yyyy-mm-dd hh24

--about whether NULL participates in the calculation in the Oracle database, and is validated,With TD as (Select null id,1 name from dual),TD1 as(Select null id,2 name from dual)SELECT * from TD, TD1 where NVL (td.id, ' 0.00 ') = ' 0 'Select ' 1 ' |

1. Build table SpaceCreate tablespace table space nameDataFile ' D:\app\Administrator\oradata\orcl\ABC. DBF 'Size 100M autoextend on next 50M extent management2. Build UsersCreate user username identified by passwordDefault Tablespace table space

Method one: Offline table space1, offline table space: Alter tablespace tablespace_name offline;2, copy the data file to the new directory;3, rename Modify the table space, and modify the control file;4, online table space;1. Offline table Space

The tool used here is rlwrap.You can learn more about http://utopia.knoware.nl/~hlub/uck/rlwrap/in this linkwget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.42.tar.gzYum install-y ReadLine Readline-devel This is dependent on theTar XF rlwrap-0

Finally, the installation of ASM and RAC was started.Getting ready to work under LinuxVi/etc/selinux/config-------permanently off SELinuxselinux=disabled--------and then restart the serverChkconfig iptables off reboot permanently shut down the

I. Sequence INTRODUCTIONSequence is a series of numbers automatically added by the database system according to certain rules, which is mainly used to generate database data records. This sequence is generally used as the surrogate primary key

Gooliugle Oracle: One database connection, returns multiple result sets (with parameters)!1. Set up Package specificationCreate or Replace package QX_GDJTJ is -- Author : xxx--created:2012-1-1 -- Purpose: Statistical main equipment Defect TYPE

Select A.user_name,Decode (A.sex, 1, ' Male ', 2, ' female ') as SEX,A.head_portrait,TRUNC (Months_between (sysdate, A.birthday)/12) | | ' Old ' as BIRTHDAY,Z.disease_nameFrom T_patient_info ADescription: Decode numeric match field, write to SQL

In the actual work, will inevitably encounter serial number generation problem, the following is a simple sequence number generation function(1) Create a custom serial number configuration table as follows:--Custom SequencesCreate TableS_autocode

1. If you have permission to delete a user, you can:Drop user user_name cascade;Add the cascade can delete the user data.Delete and then create the user.--Create an administrator userCreate user username identified by password default tablespace

The simple reason: When the diagram is convenient to not enter the database, directly in the datafile directory to delete the table space corresponding data fileresult in subsequent database error and cannot delete table spaceerrors are as

Operator arithmetic operators: +-*/You can use the Join operator in a SELECT statement: | |    select deptno| | Dname from dept;  comparison operator:> >= =! = Oracle Add Field Syntax: The syntax for adding a field: ALTER TABLE tablename Add (column

Odp.net, Managed Driver SetupThis section explains the setup and configuration steps required for using distributed transactions with Odp.net, Managed Driver.Oracle recommends that applications use. NET's native managed distributed transaction

Concept:View: The so-called view is to extract one or more tables of data to generate a map, management view can also achieve the effect of the original table, convenient data management and security operations.A view is actually a query SQL

Never give up, everything is possible!!!Only to find a way to succeed, not to find excuses for failure!Oracle Stored ProceduresI. Description of stored Procedures1) Description:1. A stored procedure is a PL/SQL statement block for a specific

Chapter II Application of Oracle database2.1 Table space and user Rights management2.1.1 Table Space2.1.1.1 Classification:Permanent Table SpaceTemporary table spaceUndo Table SpacePurpose of the 2.1.1.2 table spaceAssign different spaces to