Oracle

PostgreSQL has a function of generating sequences, which makes it easy to build data. Here I use Oracle to implement the function of the generate_series function of Pgsql.POSTGRESQL.t_girl=# SELECT * from Generate_series (1,10);

SQL statements are divided into 3 categories1.ddl:data definition Language, data definition language,The language used to define and manage all objects in the SQL database1.CREATE creation2.ALTER modification3.DROP Delete5.COMMENT comments6.GRANT

1. Download the installation packageHttp://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.htmlOracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zipOracle-instantclient11.2-sdk-11.2.0.1.0-1.x86_64.zipOracle-instantclient11.2-sqlplus-11.2.0.

A partitioned index (or index partition) is primarily for a partitioned table.As the amount of data grows, the normal heap table needs to be converted to the partition table, and its index is converted to the partition index accordingly.The

Today do not know how, whim, put the machine out of the domain, and then ready to oracle11g control to deal withAt the beginning, did not have any intentions, the Internet casually find a bit of information, and then dry, and then nothing to dry,

ADO Operation Oracle database is basically the same as the original operation of MSSQL. Just use a different namespace. Here are two examples:One. C # Read the table for Oracle database ///ADO Read Table///you need to add a namespace: Using

1. Constraint IntroductionAlthough the table is completed, the data in the table is not valid, and if you want to do some filtering on the data in the table, you can do it through the constraints, the main function of the constraint is to ensure

The JDBC Connection database process is:1, load driver, establish connection2, creating the SQL statement object3, Execute SQL statement4, processing result sets5, close the connectionThese five steps are about 4 major points of knowledge:1, Drive

1. Table SpaceA database can have more than one table space, and a table space can have more than one table. A tablespace is a physical space to store multiple tables, and you can specify the size and location of the table space.1.1 Creating Table

Oracle the user security management mainly has permissions and RolesWhen the user was just created. The user does not have any rights or permissions and cannot run whatever action.Assuming that you want to run a specific database operation, you

SQL statement ClassificationSelect query statement??DML statement (Data manipulation language) Insert, Update, Delete, Merge??DDL statements (data definition language) Create, Alter, Drop, Truncate??DCL Statement (Data Control Language) Grant,

After the configuration is complete, switch to the Oracle User:Su-oracleExecuting the tnsping service name (SERVICE_NAME), under Oracle User, refers to the service_name in the Tnsname file.If OK appears later, it indicates that TNS is normal. As

Uninstall steps: 1. Stop all Oracle Services2. Running Oracle Universal Installer uninstalling Oracle3. Modify the registry to remove Oracle-related information? Oracle software has key-value hkey_local_machine\software\oracle? Oracle Service

Usage examples:--Select columns for the entire table1. Select* fromEMP;--Select the contents of the specified columnSelectJob fromEMP;SelectEname,sal fromEMP;--Conditional JudgmentSelectSal fromEMPwhereSal= -;--between and methodsSelect*

To create a table:1 --To Delete a table:2 --Delete the existing table with the same name before creating the table, ensuring that you can create a success. 3 --but this is a very dangerous operation and it can be very bad to delete a table that

To view the table structure:See field names and data typesSELECT * FROM cols WHERE table_name=upper (' table_name ')To view the primary key:SELECT * from user_constraints where constraint_type= ' P 'and Table_name=upper (' table_name ')Other than

Summary of date functions: System time Date operation First, the system timeSysdate: Or Western format, we generally need to_char (date, ' Yyyy-mm-dd hh24:mi:ss ')Next_day: The date of the next week of the current dateExample: the date of

Oracle built-in functions are divided into four main categories: numeric functions Character functions Date function Conversion functions This analytical numerical function:First, rounding roundRound (DOUBLE,M)Double: we want to

Category: OracleIf you want to modify the order of the fields, you can generally use the following steps:--(1) Backing up the target table dataCREATE TABLE Temp table as SELECT * from target table;--(2) Drop target tabledrop table target table;--(3)

(1) First you need to download instantclient (unzip below), modify your Instantclient/network/admin/tnsnames.ora file, write your Oracle server addressTnsnames.ora File Contentscs_de_o= (DESCRIPTION = ( address_list = ( ADDRESS = (PROTOCOL =