Oracle

Oracle official site http://www.oracle.com/Oracle base campOtn.oracle.com http://otn.oracle.com/Metalink.oracle.com Co http://metalink.oracle.com/Ask Tom home http://asktom.oracle.com/asktomOracle documentation http://www.oradoc.com/index.html

Make a table insert trigger to modify only the fields of the inserted rows. Create or replace trigger tr_rme_slotBefore insert on rme_slotFor each rowBeginIf (: New. Position> = 0 and: New. Position : New. slot_name: = '0' | to_char (: New.

In table update operations, in many cases, data other than the table to be updated must be referenced in the expression. Like SQL Server provides the update from clause, it can connect the table to be updated with other data sources. Although only

B * Tree Index   The bottom layer of a tree is called a leaf node, which contains each index key and a rowid. The indexed leaf nodes constitute a two-way linked list. Once you find that you want to "start" from the leaf node, it is easy to

========================================================== ======================================@ Echo offSet y = % Date :~ 0, 4%Set M = % Date :~ 5, 2%Set d = % Date :~ 8, 2%Set H = % time :~ 0, 2%Set n = % time :~ 3,2%Set S = % time :~ 6, 2%Set

Select ziduan1 | ziduan2 as ziduan from table (merge)Select ziduan1 | 'and' | ziduan2 as ziduan from table Oracle Concat () only allows two parameters. In other words, only two strings can be connected at a time. However, in Oracle, we can use '|'

Authorized users can access database objects and their contents. Prompt that after a user has the permission to Process Tables of other users, the user must have public or private synonyms of these tables before he can reference tables of other

To connect. Net to Oracle: (1) install the Oracle client. The version must be the same as that on the server. Note: If Oracle is 32-bit, the client on the 64-bit machine must also be 32-bit. (2) Configure listeners and services in net

  -- Create a package Create   Or   Replace Package Types As Type cursortype Is Ref Cursor ; End Types; -- Create a stored procedure and return parameters of the cursor type Create   Or   Replace  

1. go to Oracle and download a file named odac111_20xcopy.rar. decompress the file. There is an instantclient_11_1 folder in it. 11-1 is the version number of Oracle, 2. place the instantclient_11_1 folder in C:/Windows/and modify the system

In many cases, many large units have several systems, and these systems may come from different vendors. The development technologies they adopt may be very different, and the underlying databases may also be For different platforms, this leads to

Software environment: 1. Windows XP + Oracle 9.1.7 2. Oracle installation path: C: \ oracle Implementation Method: 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services. 2. Start-> Program ->

Compare Oracle and MSSQL. The main differences and advantages of server. What are the differences in specific use?     Openness: SQL Server can only run on windows without any openness. The stability of the operating system is very important

First of all, the system tables provided by databases of different versions are different. You can view the tables provided by the database of this version according to the data dictionary.Like this:Select * From dict where table_name like '%

Usage Demo:Dbms_job.submit (: jobno, // job no.'Your _ procedure; ', // process to be executedTrunc (sysdate) + 1/24, // next execution time'Trunc (sysdate) + 1/24 + 1' // Interval);Delete job: dbms_job.remove (jobno );Modify the operation to be

Oracle is a relational database management system with powerful functions and excellent performance. It plays an important role in today's large database management systems. Common Oracle Database colleagues know that Oracle often encounters some

Oracle 10g R2 re-built Em dB control. If you have not modified the IP address or machine name after installation, you can skip steps 1 and 2.1. Drop configuration files and repository run:Emca-deconfig dbcontrol DB-repos drop 2. logon sqlplus as

During work, you need to import data from the gis_weichai_data_1s table in one database to the gis_weichai_data_1s table in another database. The database servers are all remote ! My implementation method is to use PL/SQL locally to operate two

In the Oracle PL-SQL, left and right connections can be implemented in the following way:Statement segment: Select Emp_name, dept_nameForm employee, Department Where Employee. emp_deptid ( + ) = Department. deptid   This SQL

Original article: http://www.cnblogs.com/believe3301/archive/2007/10/10/919408.html For the rownum problem in Oracle, many documents do not support>, >=, =, between... and. The preceding symbols can only be used (,> =, =, .. and will prompt SQL