Oracle

Oracle 11g default password expiration time is 180 days,After the password expires, the following exception occurs when you access the database:java.sql.sqlexception:ora-28001:the Password has expiredQuery Password expiration settings:SELECT * from

---------Mathematical Functions1. Absolute valueS:select ABS ( -1) valueO:select ABS ( -1) value from dual2. Rounding (Large)S:select Ceiling ( -1.001) valueO:select ceil ( -1.001) value from dual3. Rounding (small)S:select Floor ( -1.001)

Overall situationCLOB field in the actual work, there are still a lot of application scenarios, but the Blob field in today's large system, the role of more and more unsatisfactory.Because of database resources, upgrade costs are highest in large

The following information is prompted when installing centos6.5 using the virtual machine Oracle VM VirtualBox:This kernel requires the following features not present on the CPU:Unable to boot–please usage a kernel appropriate for your

1. Environment Preparation 1.1 software preparationTo first install Oracle with support for spatial data, followed by an installation or a free-install version of GeoServer, when both are deployed, we will begin to discuss further environments that

All along, it is assumed that connection if Setautocommit (false) is set, the manual transaction commit must be initiated manually or rollback. There was a problem today and the results were very surprising.The results were tested as follows (note

In an Oracle 10g,11g RAC, we use CRS_STAT to monitor the operational status of the RAC. However, since the Crs_stat display is incomplete, we will encapsulate the crs_stat two times to make the results look fresher. Such as:In the 12c cluster

Very good SQL statement optimization 34 article1) Select the most efficient table name order (valid only in the rule-based optimizer):The ORACLE parser processes the table names in the FROM clause in a right-to-left order, and the FROM clause is

1. ORACLE11G Installation Environment PreparationWith OEL6.5 x64 installation, the installation process is consistent with Redhat, the installation process selected desktop, development package, development library, other default options.Desktops >

Today around 10 o'clock in the morning, boss told us that the production environment a customer in a function of the input information, the loading data is very slow situation, because the serious impact on customer use, let us hurriedly verify the

1. Common componentsFor Apex various components (page, Region, item, button, etc.) can be set to read-only under certain conditions. Their settings are similar, and the following are also read as examples.In the component view (Component view)1.

concat (' Hello ', ' world ')     stitching             HelloWorld substr (' HelloWorld ', 1,5)   intercept Hello Length (' HelloWorld ')         string length ten InStr ('

Hello, Heroes.Really helpless, in this request you have Oracle customer service number of friends to help download the following patch, thank you! Can be shared with the cloud disk to me, thanksOracle Database Network foundation Component Remote

(1) Turn off Oracle services and background processes View the installed home directory and environment variables: echo $ORACLE _home | grep ORA View instance Names as SYSDBA Select from V$instance; View the launched Oracle

The difference of function between Exp/imp and EXPDP/IMPDP:　　1, the user UserA to import the object into the UserBEmp/imp usage:Formuser=usera Touser=userb;EMPDP/IMPDP usage:Remap_schema= ' UserA ': ' UserB 'For example:Imp system/password

After the Oracle 10g R2 was installed, the alert log was found to have the following error when starting the database: Database Characterset is UTF8 Replication_dependency_tracking turned off (no async multimaster replication found)

A little familiar with Oracle knows that if we want an SQL statement to insert multiple values into a table, if insert into a table values (each value), values (values),.....; This will cause an error because Oracle does not support this notation if

Reference: http://blog.csdn.net/nemo2011/article/details/8183326Solaris Adding a new hard diskhttp://blog.163.com/[email protected]/blog/static/35166181200942351523927/ in Solaris installation under System Oracle10 Summary

Oracle team helps to integrate enterprise systems and improve database performance Wu Chengyang, vice president of Oracle and General Manager of the Greater China technology product department, stressed that the integration of information systems

Oracle calculates the total data from 1 to 12 months in a year (very practical)Case studies Query the total number of real population from January 2015 to 12 months and the number of real population from January 2014 to 12 months in previous years.