Oracle

Although Oracle Linux is basically a copy of RHEL, it is easier to install the Oracle database for Oracle's own Linux, and select the Oracle-validate package, the prerequisites for basic Oracle database installation are automatically solved, saving

Today, I am bored. I downloaded an Oracle 11g and want to see what new functions are available. After the installation, enable em and find that the feature is excellent. It is used to import data from another database. Set to import data from the

1. Remove the network cable of the priv Nic of rac2. rac2 reboot and Rac1 work normally.[Oracle @ mesdb01 ~] $ Crs_stat-TName type target State host------------------------------------------------------------Ora. Mes. DB application online

Recently, we helped HR capture the overtime records. HR wants to calculate the number of overtime hours by week. However, Oracle's date function compute week is the first day of Sunday and the last day of Sunday. The Chinese are used to counting the

Instr usage is transferred from the http://www.cnblogs.com/Xrinehart/archive/2005/04/21/142791.html. Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->The format of the instr method is Instr (source

Original article: http://dev.csdn.net/article/72/72686.shtm For convenience, the following simple model is created and some test data is constructed:In BSS,-- Customer data table Create Table MERs(Customer_id number (8) Not null, --

1.RAISE_APPLICATION_ERRORDefinition and use The procedureRAISE_APPLICATION_ERRORLets you issue User-DefinedORA-Error messages from stored subprograms. That way, you can report errors to your application and avoid returning unhandled exceptions. To

PL/SQL table --- table () function usage /* PL/SQL table --- table () function usage:Using the table () function, we can replace the result set returned by PL/SQL. Oracle memory tables are frequently used for queries and reports. They are dozens of

1. Oracle special character escapeKeywords: Oracle escape environment: Oracle 9i PLSQL execute in PLSQL:Update userinfo set pageurl = 'myjsp? Page = 1 & pagesize = 10 'where id = 'test'This SQL statement adds a URL address to the pageurl field of

1) Create the operating system directory e:/test,parse data file dept.txt and place it under E:/test "10", "accounting", "New York" "20", "research", "Dallas" "30", "sales", "Chicago" "40", "operations", "Boston" 2) Create the database directory

The trunc () function is composed of two types: 1. trunc (for dates)The date value intercepted by the trunc function for the specified element.The syntax format is as follows:Trunc (date [, FMT])Where:Date: A date value.FMT date format, which is

  I have prepared a datafile mobile article. For details, refer: How to operate Oracle mobile data files Http://blog.csdn.net/tianlesoftware/article/details/4899172   To ensure data consistency, offline is selected or the DB is started to the Mount

Document directory Automatic database startup and shutdown on other operating systems SQL> select * from V $ version; banner production Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit production PL/SQL release

Four constraints: Disable novalidate neither restricts new data nor verifies existing data, which is equivalent to disable Enable novalidate constraint adds data but does not verify existing data Disable validate restricts the addition of new data

  Description of timed_statistics parameters on MOS: Init. ora parameter "timed_statistics" reference note [ID 30824.1] Health checkalert: Consider setting timed_statistics and statistics_level to recommendedlevels [ID 957433.1]     Version

  Operating System: oraclelinux 6.1 32-bit Database: oracle11.2.0.3   Because the patchset after the Oracle 11g can be directly used for installation, I also directly installed it into 11.2.0.3, which saves the trouble of upgrading, during which two

    During Oracle 11g installation, the following two problems are frequently encountered:   Oracle 11gora-00845: memory_target not supported on this system description Http://blog.csdn.net/tianlesoftware/article/details/7256984   [Ins-35172] target

  From: http://levicorp.com/2009/05/22/how-to-kill-the-running-job/     1. Check the running job (from here you will get the SID thatrunning the job) SQL> SELECT * FROM DBA_JOBS_RUNNING; 2. Make job become broken/offline BEGIN

When you use set autotrace or explain Plan for to generate an execution plan, the following message is displayed: Note ------'Plan _ table' is old version   The cause of this error is that the execution plan of Toad has been analyzed. Therefore,

 1. Install Oracle Linux 6.1 Oracle has been running its own Linux for several years, so I didn't pay much attention to it. Today I paid special attention to it. I downloaded an oracle Linux 6.1 Test from edelivery.   The installation process is the