Oracle

--------- Mathematical functions 1. Absolute ValueS: select abs (-1) valueO: select abs (-1) value from dual2. INTEGER (large)S: select ceiling (-1.001) valueO: select ceil (-1.001) value from dual 3. Round (small)S: select floor (-1.001) valueO:

In the dedicated connection mode, the server establishes a connection with the client for every client request to connect to the database server. This connection is used to process all requests of the client, until the user actively disconnects or

I used to know that Windows only has a recycle bin. Today I heard that Oracle also has a recycle bin! In Oracle, a table may be accidentally dropped. If regular backup is not performed, it will cause a lot of trouble. In some cases, daily data is

Authoritative Performance Testing Organization (TPC) was confirmed on December 3, the previous day Oracle submitted the names of the T3-4 Supercluster, with a total of 30 249 transactions per minute (transactions processed per minute. The original

To modify the Data Type of a field as required by the business, change it to number (5 ). Use the following statement if no data exists. Alter table tb_test modify permile number (5, 2 ); However, if there is data, you cannot use the above

Oracle 10 Gbit/s provides powerful cross-platform database migration functions to migrate oracle databases between different architectures and operating systems! However, endianess must be the same, and different endianess may be migrated between 11

The following are some statements about temporary tablespace learned:-- 1. view temporary tablespace (dba_temp_files view) (v _ $ tempfile view)Select tablespace_name, file_name, bytes/1024/1024 "file_size (M)", autoextensible from

Common ORACLE errors and solutions are not as easy to remember as they are. In the future, we will record the common oracle errors in the project. 1. ORA-24324: Error Description: [SQL] SQL> shutdown immediate; ORA-24324: service handle not

The parameters related to oracle semi-join (in, exists) Semi-join and anti-connection are actually in and exists. Before that, I was confused about these things, I think there are some online saying that exists is better than in, and so on. in fact,

Oracle 10g rac standby automatic log deletion script [plain] #! /Bin/bash export ORACLE_HOME =/opt/oracle/product/10.2.0/db_1 export ORACLE_SID = standby1 export ARCHIVE_DIR =/log/archivelog export LOG_FILE =/home/oracle/logs/del_archive.log if [! $1

Time Calculation of common Oracle computing statements: oracle two time subtraction by default is the number of days * 24 is the number of hours of difference oracle two time subtraction by default is the number of days * 24*60 is the difference in

Oracle virtual index does not consume CPU, IO, and storage space. It is used to determine whether the created index can be used. The following example shows: SQL> create table tb1 as select owner, object_name, object_id from dba_objects; -- create

Check the table space and table size in the oracle database today. It seems that the table space is too large. Find the following information and first query the space occupied BY the TABLE. Use the following statement: SQL code SELECT SEGMENT_NAME,

Oracle export/import and Character Set Information viewing for data import and export, we should pay attention to the character set issue. In the EXP/IMP process, we need to pay attention to the four character set parameters: the client character

Oracle user-maneged recovery (1) I. disable database recovery in non-archive mode. shutdown immediate; shut down the database 2. use the operating system command to copy the latest backup (data files and control files, if log files are backed up) 3.

The DBMS_HPROF package is used to collect PL/SQL Performance information. The DBMS_HPROF package is an oracle 11g tool, which is a combination of DBMS_PROFILER and DBMS_TRACE. here is a simple demonstration of how to use the DBMS_HPROF package to

Oracle basic code learning /* ------------ Orcale function ---------------- */1. character function LOWER () LOWER case UPPER () UPPER case INITCAP () connect the first letter to the CONCAT () string (you can also use "| ") functions are connected. /

Oracle trace file 11g: Oracle alter file before 11g is in the bdump directory. Oracle 11g provides Alert logs in XML and traditional text formats. The location of the new oracle 11g log is determined by the Automatic Diagnostic Respository (ADR. You

[Oracle]-[sqlplus/as sysdba logon Error, sqlplus/as sysdba returns an error, which is strange, so it is simulated in its own VM. A test user is created: [test@liu bin]# ./sqlplus Error 6 initializing SQL*PlusMessage file sp1.msb not foundSP2-0750:

[PL/SQL] How to implement complex grouping, subtotal, and aggregate -- Test code create table t_dist (TYPE_CD NUMBER, BUYER_ID VARCHAR2 (50), ORDER_DT DATE, SO_ID VARCHAR2 (50) not null, STOCK_ID VARCHAR2 (50) not null, UNIT_PRICE NUMBER, discount