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:

Many people know that the Oracle listener has always had a security risk. If security measures are not set, users who can access the listener can close the listener remotely. Example: D:> lsnrctl stop eygle LSNRCTL for 32-bit Windows: Version 10.2.0.

How to modify the VIP address in a 10 Gb environment of the Oracle database: ◆ 1. Stop all services Crs_stop-all ◆ 2. root user Login, according to the original environment needs to execute commands, set environment variables (note if you are not

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

Create a tablespaceCreate tablespace data01DATAFILE/oracle/oradata/db/DATA01.dbf SIZE 500 MUniform size 128 k; # specify the area SIZE as 128 k. If not specified, the default area SIZE is 64 k. Delete a tablespaceDrop tablespace data01 including

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

The following describes how to connect to the oracle database using java to call and return the list of oracle stored procedures for your reference. If you are interested in oracle stored procedures, take a look. Since the oracle stored procedure

Oracle analysis table is an important part of Oracle Database Management. The following describes the knowledge of Oracle analysis table in detail.It can be helpful.1. Analyze SQL:Analyze table tablename compute statisticsEquivalent to analyze table

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

ASSM and pctused I believe many people know that when using ASSM (auto segment space management), PCTUSED will not be valid. However, how many people tell you why PCTUSED is ignored in ASSM. Before ASSM, Oracle used freelist and freegroup to manage

Using SQL statements to parse the element Geometry field is used in system applications. To obtain the point value set of the element geometric field, we often used ArcEngine for development and analysis, this article introduces a more convenient

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. /

SQL (+) SELECT emp_name, dept_name FORM Employee, Department WHERE Employee. emp_deptid (+) = Department. deptid  This SQL statement uses the right connection, that is, the other side of the "(+)" is the connection direction. All records on the

Oralce (2) [SQL] // table join query // 1. select s. subscriberno, c. customerid from subscribern s, customer c where s. customerkey = c. customerkey and subscriberno = 'cxm'; // 2. join // select s. subscriberno, c. customerid from subscriber s

[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

[Oracle] After Oracle is set to restart automatically when the server is started in Linux, the database does not restart. Only then can I find that all databases have not been set to enable automatic restart, to prevent me from waking up from my

During the project's analysis on the dramatic expansion of the Oracle system tablespace, we found that the database could not be logged on. An exception is reported when any user logs on: the system tablespace is insufficient due to the above error.

Lock_sga and pre_page_sga are two parameters that are usually not too many, but these two parameters may provide you with optimistic performance improvements during optimization, the lock_sga and pre_pga_sga parameters can be modified to ensure that