Oracle

Installing Oracle on RHEL requires some necessary packages, such as binutils compat-db compat-libstdc++-33 control-center gcc gcc-c++ glibc, and so on. If one of the outfit, really very troublesome, fortunately with Yum and oracle-validated: 1

The text is transferred from http://www.cnblogs.com/souso/archive/2010/01/23/1654772.html first, obtain the installation media1. Download the Oracle 10g installation disk from the Oracle official website (http://www.oracle.com). Need to register a

/** * Deletes the name of the field passed in to all tables in the current database, and the record of the corresponding tagged value * MR_CHENPH (2012-1-12) * Invocation Way Select Deletetag (' Isdel ', 1) from Dual * to The above statement

How Oracle handles custom exceptions in stored procedures: In Oracle-more than 20000 is the code for user-defined exceptions, and you can customize your own exception hints based on this principle. You can also invoke additional stored procedures in

In Oracle/plsql, the InStr function returns the position of the string to be intercepted in the source string. The syntax is as follows: InStr (string1, string2 [, Start_position [, Nth_appearance]]) String1 the source string to find in this string.

Note: The difference from max,min, although it can be implemented, is only for numeric fields. 1, initialization of the original data:CREATE TABLE Test (ID number (2), name Varchar2 (a), salary number (6,2));INSERT into test values (1, ' Tom ', 120);

SCOPE The SCOPE clause lets your specify when the change takes effect. Scope depends on whether your started up the database using a client-side parameter file (pfile) or server parameter file ( SPFile). SCOPE specifies when changes to system will

--Job permissions Grant create job to somebody;   --Job creation begin Dbms_scheduler.create_job ( job_name => ' agent_liquidation_job ', job_type => ' stored_procedure ', job_action => ' agent_liquidation. Liquidation ',--stored procedure

Sometimes you want to delete an Oracle user and rebuild it, but the user will not be able to delete it if the user still has a client to keep the connection. At this time we need to find the user connection Sid and serial#, use the relevant command

Today, for example, write a simple pl/sql statement that looks at the newly-written statement in the buffer, as follows: Sql> L1 DECLARE2 I number (4): =13 BEGIN4 LOOP5 INSERT into EMP2 (empno) VALUES (i);6 EXIT when 1>2;7 i:=i+1;8 End LOOP;9*

Write stored procedure encountered a problem, the execution of dbms_output.putline (variable name), when the errorOra-20000:oru-10027:buffer Overflow,limit of bytes.$ oerr ora 2000020000, 00000, "%s"*cause:the stored procedure '

Data export: 1 completely export database test, user Name System Password Manager exported to D:/daochu.dmpExp System/manager@test file=d:/daochu.dmp full=y 2 Exporting a table from the system user in the database to the SYS userExp

Import java.util.Collections;Import Java.util.HashMap;Import java.util.List;Import Java.util.Map; Import Javax.sql.DataSource; Import Org.springframework.jdbc.support.incrementer.OracleSequenceMaxValueIncrementer; Import

Record user logon information in Oracle We can use the Oracle Audit function to record user login information, but if the Audit function is opened it will degrade Oracle performance and even cause Oracle to crash. So how can we record user login

question: Win7 system, failed to configure Oracle's net Manager save. screenshot of question: 1, Error Tip: Writing entry to the local Tnsnames.ora file 2, point "Details" button Problem Analysis: Because the security of the Win7

About an old error with Oracle ORA-01555 snapshots First, understand under what circumstances Oracle will produce ORA-01555 errors: Assuming that there is a testdb table of 60 million rows of data, it is expected that testdb full table scanning 1

in development, we may have deadlocks when manipulating the database, and if we don't want to wait, this requires us to manually kill the process. Oracle View Lock Table SELECT l.session_id Sid, S.serial#,

Oracle Table partitioning: Range Partitioning Oracle. Table partitioning: Hash partitions Oracle. Table partitions: List partitions Oracle. Table partitions: Composite partitions Oracle Table partitioning: manipulating partitioned tables

The report exception was found when you logged on to Oracle using Pl/sql Developer: Ora-01034:oracle Not available Ora-27101:shared Memory realm does not exist Then manually start the database instance: C:\users\wlshi>sqlplus/nolog Sql*plus:release 1

1. Log in with SYS user Sqlplus Sys/pass@tt as Sysdba 2. Look at the location of Archiv log Sql> Show parameter log_archive_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ Log_archive_dest