Oracle

1.1 Use of Oracle date objects(1) Create a date fieldFor exampleCREATE TABLE foo_7 (d1 date);(2) Use the to_date function to insert a date object. to_date (' string ', ' string format ') For exampleINSERT into foo_7 values (to_date (' November 20, 20

The method of launching Scott users in Oracle, in Oracle11gr2, (g for ' network ') in the database Scott this user is locked during installation, when you install Oracle, you can directly choose to unlock the user, if you forget to understand the

The great God's own detour , a good memory than rotten pen, with half a month to write down the Oracle database series, basically covers all development and database maintenance of all aspects of daily. Because also useful outliner write, Windows

Linux Installation Oracle1Increase swap space, memory is greater than 8G and swap is equal to memory sizemkdir/home/Swap CD/home/SwapDD if=/dev/zero of=swapfile bs=1g count= tomkswap swapfile swapon swapfile #增加到swap分区 (31G+ 31G =62G)

Today, the need to see people asking questions is probably the case. Id S Start time End time 1 20 2001-01-01 08:10:20 2001-01-01 08:10:40 1 9 2001-0

The system environment is Microsoft Windows 98, Chinese Oracle 8i stand-alone version, the application is the health insurance system drugstore end, daily turnover of about thousands of yuan. Users reflect that the computer started when the computer

1. Hierarchical Query Semantic Analysis:2. Hierarchical Query Script test:---Delete a table that already existsdrop table test;--Create tableCREATE TABLE TEST(Orgno Number (TEN) is not NULL,Deptno Number (10),DEPTNM VARCHAR2 (20));---insert

before closing the backup control file/parameter file: Sqlplus/as Sysdbaalter Database backup controlfile to '/home/oracle/control.ctl.bak '; Create pfile= '/home/oracle/init& lt; instance name >.ora ' from SPFile;One, Oracle 11g RAC shutdown

1 --20,141,230 Deployment scripts (from top to bottom in chronological order)2 3 4 --command line, export the database data to be deployed (no semicolon)5 --EXPDP rmb3/[email protected] schemas=rmb3 directory=expdir dumpfile=20141230.dmp logfile=2014

A while ago in the implementation of the problem, need to be modified, and because the data in the database is real data, can not be modified, otherwise it will be a big mistake, so add test data to facilitate the modification, and single add

Problem: The ID of the Customer table in the database changes to 21\31\41 ordinal number, not 1\2\3 growth in turn[Cause of problem]:Seq_customnoteen set the cache 20, take 20 numbers at a time, then one to you, if there is a period of time in the

First, hardware detection1, Memory detection oracle11g minimum 1GB memory requiredCommand: grep memtotal/proc/meninfo2, swap space detection usually swap space is 1.5 times times the memoryCommand: grep swaptotal/proc/meninfo3. Temporary

This is a summary of the recent study of their own experienceI. Oracle's object-orientedSQL is a collection-oriented one that everyone knows, but there is no denying that there are many places in Oracle today that embody object-oriented thinking.

One, a stored procedure with a cursor　　There are two types of cursors as arguments:　　1. Declaring the system cursor type Sys_refcursor1) The cursor acts as a parameter to the stored procedure:--A stored procedure with a cursor create OR REPLACE

First, table partition　　(i) Classification of table partitions1. Range partition (range)2. Hash partition (hash)3. List partition4. Compound partition: Range-Hash (range-hash), Range-list (range-list)　　(b) Scope Zoning:A range partition is a

1.1. Instant Client DownloadWebsite:Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.htmlDownload Instantclient-basic Package and store the package locally, this test is D:\JavaEEServer\instantclient_10_21.2.

How to install Oracle 12c in Redhat 6 environment, oracle12c Step 1: To install Oracle on Linux, you must install the corresponding software package before installing Oracle. The requirements for software packages vary with operating system

An example of OracleAny subquery Problem:Query the names, jobs, and salaries of employees with lower salaries than any salesperson ("SALESMAN") in the Emp table.Analysis:The salesperson has many records in the Emp table. The salaries of each person

Oracle string operations Select upper ('testmyname') from dual; -- convert to uppercase Select lower ('testmyname') from dual; -- convert to lowercase Select upper (substr ('testmyname'), 5) from dual; -- intercept myname and convert it to

Oracleinstr function usage and (oracle uses instr to replace like) Oracle instr function appeared in the recent project, so I found some information about it on the Internet. Usage of INSTR and SUBSTR in Oracle INSTR usage in Oracle:The format of