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

Example (Instance)Database startup after the impression in memory, the management database runs normally. The ORACLE_SID is identified in the OS as a instance_name identifier in the DB, consisting of the System Global area + Background Process.To

I haven't updated my blog for a long time, mainly because I changed my job years ago. The new job is very busy, and seldom time to blog the garden.As an Android developer, why should I learn Oracle database? I am a non-computer professional, and the

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

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

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

Recently contacted with ADO and Oracle to share some of the problems I have encountered with you.I think if you want to get started with the Oracle, the basic requirement is to update the data in Oracle with ADO.This article is simple to update the

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

[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

How to connect a database with the same name on different ip addresses when connecting oracle with plsql Sometimes, in work, the database name is the same through plsql, but on different ip hosts, how can we differentiate connections through plsql?

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

Duplicate sid installation in oracle After Oracle is uninstalled, it is installed again. If the configured SID is the same, "the specified SID already exists on the local machine. Please specify a different SID ." SID Introduction The SID, also

Oracle connection typeIf you connect multiple tables by using the select clause and the from clause, the query result is a table generated by the Cartesian product.The table generated by the so-called flute product is the table generated when each

Simple and practical merge commands in oracle Merge command With this merge, You can execute the inserts and updates operations on a table in an SQL statement at the same time.You can use the meger statement to merge two specified tables. The syntax