Oracle

In practice, you often encounter the need to periodically delete data that has expired and release server resources. For example, we define a timer task, which starts at 2 o'clock in the morning, and this task is to delete data from 1 months ago to

In MySQL There are keyword group_concat that provide similar functionality, and similar feature keywords in Oracle are wm_concat. For example, I have the following query data:But I would like to be able to display a row of queries, the result graph

--ascii Code and character conversionSelect Chr (65) | | Chr (66) | | Chr (ABC,CHR) (54678) from dual;Select ASCII (' 諙 '), ASCII (' ABC ') from Dual;--Get the string length functionSelect Length (' Abcde i Fghi ') from dual;--string

as follows, table A is a table that already exists in the database, and B is a table that is ready to be copied from table A:1. sql that replicates only the table structureCREATE TABLE B as select * from a where 1<>12. sql that replicates the table

Because Oracle does not have a for WIN7 version, you must download the for VISTA_W2K8 version, extract the Oralce 10G installation image to the hard disk, and then modify the Rehost.xml and Oraparam.ini two files in the installation directory.I.

Learning route Map: Learning methods and ideas: Why do you need to learn about Google? Do you still have to study with the official documentation? Job Roles: Developer: SQL operations database, PL/SQL implements

Reprint: http://database.51cto.com/art/201009/228094.htm1. Inner connection (natural connection)2. External connection(1) Left outer connection (the table on the left is unrestricted)(2) Right outer connection (no restriction on the right table)(3)

Increase the size of the TMPFS under Oracle Linux and increase the 502M to 3G (note: The initial value is half of memory)First change the/etc/fstab tmpfs size to 3GAdd size=3g after Tmpfs,Ok,/etc/fstab edit completed, but Oel and redhat a little

Today, someone asked a question about Oracle string interception and splicing, let me help him write SQL, read the problem description is relatively clear to try to solve, the use of lunch time to realize the function, the problem seems not

Summarizes the common SQL used to view Oracle databases and helps to optimize a robust system program for analysis.1. Current number of database connections:Select COUNT (*) from v$process2. Maximum number of connections allowed for the

It's hard to find a job for a newly graduated student, but how do we have project experience?At first I also do not believe, can own according to Http://url.cn/TgrIZT Register, and then through this website to obtain the learning card user name and

This is for oracle11g, other versions of the test has not been known.First, use system to establish a connection, the password is the one you specified when you installed it, and then create a new user in the bottom "other user".Note 1: Be sure to

The acid Characteristics of Oracle Transactions1 , Atomic (atomicity)The atomicity of a transaction means that all the operations contained in a transaction are either done or not, ensuring that the database is consistent.For example: A account to

1. Start Stop Oracle Instance(1) su-oracle(2) Echo $ORACLE _sid(3) Sqlplus/nolog//To enter the Sqlplus environment without logging into the database(4) Conn as SYSDBA//Input database user name/password(5) Startup//StartShutdown Immediate//stop2,aix

The use of the--oracle trunc () function/************** Date ********************/1.select trunc (sysdate) from dual--2011-3-18 today's date is 2011-3-182.select trunc (sysdate, ' mm ') from dual--2011-3-1 returns the first day of the month.3.select

No response to oracle login solution (oracle4612267 patch installation tutorial) At about noon today, I suddenly received a text message prompting me that the company's software had not produced a ticket for a long time. The first reaction was that

[Reprinted] basic Oracle knowledge and basic oracle knowledge I. oracle Installation Process Ii. sys and system users (1) The sys user is a super user with the highest permissions, The sysdba role, and the create database permission. The default

[ORACLE] Precautions for installation (1). Precautions for oracle Installation Although it is not difficult to install ORACLE, sometimes it is easy to cause installation failure due to some small details, wasting a lot of time. Here we will

View the SQL Execution history of an Oracle Database Method 1: Use the LogMiner Tool Advantage: the log content can be fully mined to find all SQL statements that have been executed Disadvantages: If archiving logs are not enabled, you can only mine

Ora 12514 tns listeners cannot be recognized currentlyFind a text file: E: \ oracle \ NETWORK \ ADMIN \ listener. ora also has a tnsnames. ora file in the same path (this is my own installation path) Open listener. ora: # Listener. ora Network