Oracle

Sysdate 2009-6-16 15:25:10 　 TRUNC (Sysdate) 2009-6-16 　 To_char (sysdate, ' YYYYMMDD ') 20090616 to Japan To_char (sysdate, ' YYYYMMDD HH24:MI:SS ') 20090616 15:25:10

--upper-------Convert characters to uppercaseSELECT Upper (' ABCDE ') from dual;--lower -----Convert characters to lowercaseSELECT Lower (' ABCDE ') from dual;--initcap----- Returns the first letter of all words in uppercase, other lowercase

In SQL Server has been using the DTS Extract data, but DTS Microsoft only support to 2008, to 2012 there is no such tool, now need to build a channel between SQL Server and Oracle, with this channel, Extract the data from Oracle into the SQL Server

A tablespace table space is a collection of one or more data files, all of which are stored in the specified table space, but are primarily tables, so called table spaces.Partition TableWhen the amount of data in the table is increasing, the query

Oracle encountered NVARCHAR2 type times error when making character match, prompting for character set mismatch.For places where you use NVARCHAR2, you need to convert the fields into characters, plus the To_char (nvarchar2 field).For example:SELECT

System permissionsSystem permissions require that the grantor have the ability to perform system-level activities, such as connecting to a database, changing user sessions, establishing tables or establishing users, and so on. You can get full

--The second method: direct configuration --If you create a global dblink, you must use the SYSTM or SYS user to add public before database . Create/ * public */Database link DBLINK1 Connect to Dbusername identified by Dbpassword 　　Using ' (

Overview of Oracle's main processesData write Process (DBWR): Responsible for writing changed data from the database buffer cache to the data fileLog write Process (LGWR): Writes changes in the redo log buffer to the online redo log fileSystem

The Oracle sequence (Sequence) is primarily used to generate serial numbers, which are often used in applications, especially as ID values, which are used to make table primary keys. However, sometimes when you need to modify the sequence initial

Some time ago learning Oracle To do the study notes, organized a bit, the following is a share of the Oracle common functions of some notes, and later will share other parts of the notes, please criticize correct.Use of the To_date () function in a 1

SELECT ROUND (number, [Decimal_places]) from DUALDescriptionNumber: The value that will be processedDecimal_places: Rounding, decimal number, not fill default is 0Sample:Select Round (123.456) from dual; Results: 123Select round (123.456, 0) from

Recent work encountered from the database read the Blob type of picture, and in the page display problems, think of the next, there are probably two ways, one is to convert the data into a file, save it locally, and then upload the file address to

PrefaceA system at the beginning, due to the small amount of data in the database, the main focus of developers on business and functional implementation. As the system completes its deployment and accumulates over time, the data in each table is

Oracle Two time subtraction default is the number of daysOracle two time subtraction The default is the number of days *24 is the difference between the hoursOracle two time subtraction The default is the number of minutes *24*60 is the difference

"Source" http://www.cnblogs.com/yangy608/p/4054393.html' Alter profile default limit Password_reuse_max unlimited; '' Alter profile default limit Password_reuse_time unlimited; ' When using profile and want to reuse the password, you need to meet

Similar to the identity column identity,oracle in SQL Server, the same effect is somewhat small and complex, as follows:1 --1. Create a table2 Create TableStudent (3Idinteger not NULL Primary Key,4Namevarchar2( +) not

How does oracle11g restore the primary database of dataguard to an oracle single-host instance?You need to recover the primary database of dataguard to an oracle single-host instance. Therefore, record the detailed process 1, pull a new parameter

How to associate two Mysql tables with update in Oracle, oraclemysql When reading MySQL 5.1 reference manual, we found that MySQL provides a two-table join update operation. The original article is as follows: UPDATE items,month SET

ORA-12537: TNS: connectionclosed error handling process1. My colleague said that the oracle test failed to connect. The error is as follows: [oracle@pldb236 admin]$ rlwrap sqlplus powerdesk/pd141118@PD236SQL*Plus: Release 11.2.0.1.0 Production on

Oracle uses functions to merge multiple rows and one column of data /* Formatted on 13:23:55 (QP5 v5.185.11230.41888) */create or replace function GetGiftsName (rid in number) // RETURN VARCHAR2 as str VARCHAR2 (1000) in the rid parameter ); /*