Oracle

First, let's explain the concept of a database. A database is a file stored on a disk. The data stored in these files has a certain physical and logical structure. Database NameIs the name of the database, such as myoracle, which is generally only

Cause: Incorrect ORACLE_HOME location OpenRegisterTable, HKEY_LOCAL_MACHINE/software/Oracle check whether the registration path of Oracle is consistent with the actual installation path. If not, change the Registry path to the actual path! [This

The default "&" in SQL * Plus indicates the substitution variable. That is to say, as long as the symbol appears in the command, SQL * Plus requires you to enter the substitution value. This means that you cannot input a string containing this

Well, I have not fully studied sqldev, but it is not very convenient to use in a few places. I found that I can modify the shortcut key to correct it. 1,CodeSmart completion prompt All the shoes that have used eclipse are used to using ALT +/,

The types of Oracle Data Dictionary views are user, all, and DBA. User _ *: Information about objects owned by users, that is, information about objects created by users All _ *: Information about objects accessible to users, that is,

1 Definition Oracle10g em adopts the web method and is divided into two products: Database Control and grid control. This section describes how to create a single data dbcontrol. To install grid control, download a separate CD. When using dbca to

Generally, dump content cannot intuitively understand the desired information. You can use utl_raw. 1. convert numbers An integer of 1.1 SQL> select dump (175185, 16) from dual; Dump (175185, 16) ------------------------ Typ = 2 Len = 4: C3, 12, 34,

1. Create a test table Use the Sys user to create a test table SQL> Create Table HR. St (ID number, time date ); Table created. SQL> insert into HR. St select rownum, created from dba_objects; 50416 rows created. SQL> commit; Commit complete. 2.

To add sub-partitions for an existing partition (such as clah_201110), we can only add them one by one. It is very troublesome. The following code. I wonder if you have any good solutions. Of course, you can add partitions and subpartitions together

1 syntax 1.1 row-Level Definition   1.2 table-Level Definition       2 not null Only row-level definitions are allowed. SQL> Create Table tn0 (a number (4) not null, B varchar2 (20 )); SQL> Create Table TN1 (a number (4) Constraint nn_tn1_a not

Select F. tablespace_name,A. Total,U. used,F. Free,Round (U. Used/a. Total) * 100) "% used ",Round (f. Free/a. Total) * 100) "% free"From (select tablespace_name, sum (Bytes/(1024*1024) TotalFrom dba_data_filesGroup by tablespace_name),(Select

Ii. PL/SQL developer Installation 1. Download and install Http://allroundautomations.swmirror.com/plsqldev802.exe The registration code is self-searched, and many of them have registration machines. Note: Do not install it in the default c: \

The following is my own installation script for installing Oracle10g. It has been run in various centos5 versions.ProblematicThe usage is as follows:1. Test the following script in a file and run it under the root user.2. A running prompt is

Rownum and rowid are all pseudo columns. However, rownum is a logical number and its value always starts from 1. The rounum of each row is not fixed. The rowid is a "physical" number. If the database file is not movedRowid is usually

For more information about rownum and rowid, see the following link: Http://blog.csdn.net/laizhenhai88/article/details/7437281 For details about how to use rownum paging, refer to the following SQL Select *From ( Select T1. *, rownum RnFrom( Select *

1. Generate a file in the stored procedure of Oracle It is convenient to generate files in Oracle, especially when an external interface is generated, it is completed through a scheduled task, it is more flexible than compiled languages. When using

Public is not a role. You can understand it as a set of all database users.If a permission is granted to the public, the database user can have this permission (of course, some users may not have the connect permission ).For example, if you want to

I. handling process 1. Find the locked database table and related Sid, serial # And spid: Select object_name as object name, S. Sid, S. Serial #, P. spid as system process number From v $ locked_object L, dba_objects o, V $ session S, V $ PROCESS

Use SQL to directly manipulate featureclass (Oracle). Here we mainly talk about the element class with the storage type st_geometry.The featureclass operations mainly include the following:1. Data insertion, deletion, and updateThe insert statement

Understanding instance and Class Members In this section, we discuss the use of staticKeyword to create fields and methods that belong to the class, rather than to an instance of the class. Class variables When a number of objects are created from