Oracle

The Round () function returns a numeric value, which is the result syntax ROUND (number, decimal_places) number of the rounding operation based on the specified number of decimal places: the number of decimal_places to be rounded, number of decimal

Dblink mode: 1 Create public database link xxxx connect to xxxx identified by xxxxusing 'xxxx'; -- select 'drop table' | trim (xxxx) | '; 'From dt_tabinfo where dw_sysid = '000000' -- 2 select 'create synonym' | trim (dw_tabid) | 'for TOTALPLANT. '|

Database usage: oracle tablespace operations1. view the space used by the database table select tablespace_name, sum (bytes)/1024/1024 from dba_data_files group by tablespace_name;2. view the remaining tablespace in the database SELECT

Problem:During database migration, if the table contains LOB fields (BLOB, CLOB, etc.) and IMP fails, the system prompts that the tablespace does not exist.Cause:All data of the LOB type is stored in the tablespace, and only the pointer is stored in

1. rating function: used for rating, percentage point, n-part, etc. Function Description RANK () returns the ranking of data items in the group. If the ranking is equal, the vacant DENSE_RANK () is left in the ranking to return the ranking of data

Install Linux basic Edition SoftwareThe Redhat5 Software Package uses yum management, so you need to connect to the Internet if you need to add software. to install the software from a CD, follow these steps:1. mount the disk to create the directory

In actual data, in order to display the information in the table more intuitively, values of the same type or within a certain range are usually classified as one type, and the 'old value' is replaced by a unified 'new value ', at this time, we will

How to obtain the current year, month, and day from Oracle1. // The extract () function in oracle is introduced from oracle 9i. It is used to extract a specific part from a date or interval type. // The syntax is as follows: EXTRACT ({YEAR | MONTH |

Implemented through Oracle database Triggers. For example, TEST is the TEST account and the bound IP address is 10.142.244.30. Create or replace trigger sys. trg_work_logAFTER LOGON DATABASEDeclareV_program_name varchar2 (200 );V_username varchar2 (1

Example 1 create a table SQL> create table wdongh (www.2cto.com 2 id integer, 3 name varchar2 (60) 4 ); 2. insert data SQL> insert into wdongh values (1, 'wdh '); 1 rowinserted SQL> insert into wdongh values (2, 'xiaoming '); 1 rowinserted SQL>

You can use the GROUPING_ID function to filter records with the HAVING clause, removing records that do not contain subtotal or total. The GROUPING_ID () function can accept one or more columns and return the decimal value of the GROUPING bit vector.

TNS: protocol adapter Error Problem encountered today ORA-12560: TNS: protocol adapter Error Problem, after some effort the problem has been resolved, share with everyone. There are three reasons for the problem that caused the ORA-12560: TNS:

Solution environment for ora-01092 oracle instance terminated:Solaris10 64bit, oracle10gR2 64bitOperation:Mainly for database software upgrade, from 10.2.0.1 to 10.2.0.5After the software upgrade is completed, log on with DBA permission through

The following 10g Oracle service start/stop scripts are the two most commonly used scripts every day, namely, oracle 10g services start/stop, the script content is not original (obtained from caiyun at the earliest), and the original address cannot

Configuration relationship between oracle rac Server Load balancer and local_listener and remote_listener: configuration relationship between oracle rac Server Load balancer and local_listener and remote_listener. 1. Client implementation: directly

The SQL statement table content displayed by a group: create table TEST2 (ID NUMBER, NAME VARCHAR2 (20); insert into TEST2 (ID, NAME) values (1, 'stefanie '); insert into TEST2 (ID, NAME) values (1, 'Google '); insert into TEST2 (ID, NAME) values (1,

ORACLE row-to-column writing/* drop table foo; * // ** CREATE a demo TABLE **/create table foo (bbbid number (2 ), -- primary key depid number (2), -- unit NUMBER AAC006 VARCHAR2 (1) -- Gender 1 male 2 female 0 unknown CONSTRAINT CK_AAC006 CHECK

Resolution of ora-01779 errors when optimizing update, given that update from is more efficient, but because oracle checks key values, a ora-01779 error is reported, by using BYPASS_UJVC to skip the Oracle key determination, the same effect is

ORA-00205: error in identifying control file, check alert log for more info Problem Environment: oracle10gR2 solaris10 operation: the following command is directly executed without creating pfile1 SQL> create pfile from spfile; 2 SQL> shutdown

Oracle case when usage 1. the case when expression has two forms: Simple Case function CASE sex WHEN '1' then' male 'when' 2' then' female 'else' others' END -- Case search function CASEWHEN sex = '1' then' male 'when sex = '2' then' female 'else'