Oracle

Oracle has a package named XMLDOM, which allows you to easily create an XML file. A simple example is provided to generate Test. xml. The content is as follows: Arwen 123 Tom 456 Certificate --------------------------------------------------------

The following describes the TIMESTAMP type.Create table test_time (col_time timestamp );  SQL> insert into test_time values (to_timestamp ('2017-1-1. 0', 'syyyy-mm-dd hh24: mi: ss. ff ')); One row has been created. SQL> insert into test_time values (

The system reports the following error: Timestamp: 1/17/2012 4:36:24Message: PROV_OUTPUT_10: Error occurred while polling for new messages. QUEUEDATA schema may be inaccessible.Waiting 60 seconds before retrying. --> ORA-12516: TNS: listener cocould

If oracle prompts ERROR-ORA-12541: TNS: No listener, follow these steps because your assigned address is incorrect. View the \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ tnsnames. ora file, open it in notepad, and display the oracle value: 

@ Echo offSetlocal enabledelayedexpansionTitle % date % time :~, 8% by LiaoNing Sunray Software Technology : Defines the database SID.Set SID = sryx254 : Defines an array of user names (separated by spaces, for example, user1 user2 user3)Set userArr

Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on deviceUpon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device [ID 301830.1] Applies: Oracle

In oracle, the null String is considered null, and any value compared with null is null. In this way, an exception occurs when comparing two strings. See the following example:DeclareI varchar2 (10): = null;V varchar2 (10): = 'abc ';BeginIf (I = v)

Author: skateOracle service process how to handle user process requests, see: http://www.bkjia.com/database/201202/120122.html To log on to the database and do things in the database, you must first connect to the database. Based on the connection

1. log on to the database as an administrator using pl/SQL 2. Run the script file utlxplan in the path % oracle_home %/rdms/admin, for example, D: \ Oracle \ rdbms \ admin.      Note that all file types should be selected below      Then run,       

UnionSelect * from emp where deptno = 10 union select * from emp where deptno = 20;Select * from emp where deptno = 10 union all select * from emp where deptno = 20;Select * from emp where ename like '% A %' or ename like '% M % ';Select * from emp

-- Common oracle system tables/*Start with dba .....Dba_users database user informationDba_segments table segment informationDba_extents data zone informationDba_objects database object informationDba_tablespaces database tablespace

Oracle10g, OracleDBConsoleoracl is my service.The service cannot be started the next day, because the IP address is changed. 1. Run "emctl start dbconsole" under the cmd command. "Environment variable ORACLE_SID not defined. Please define it."

Oracle recursive query and deletion of parent-child relationship recordsThe database often processes records of parent-child relationships. In oracle, you can use a query statement to retrieve all the sub-records at a time. Example: t1 t11 t111 t1111

SELECT region AS constraint name, USER_CONS_COLUMNS.TABLE_NAME AS table name, region AS column name, USER_CONS_COLUMNS.POSITION AS position FROM USER_CONSTRAINTS JOIN USER_CONS_COLUMNS ON (region = region) WHERE CONSTRAINT_TYPE = 'P'; note: note: C (

The user name and password indicate that ctxsyscsysctxsys is an interMedia Text user and has the connect, resource, and dba permissions. DBSNMPDBSNMPDBSNMP includes the database roles of CONNECT and resourcehe snmpagent. Run the catnsmp. SQL script

Configure tnsnames in oracle # tnsnames. ora Network Configuration File: C: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. MYSCOTT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST =

Advanced usage of group by in oracle simple group by usage select c1, sum (c2) from t1where t1 <> 'test' group by c1having sum (c2)> 100; www.2cto.com rollup (multiple columns)-volume summary, from the last summary field to the volume summary, until

The REMOTE_ OS _AUTHENT initialization parameter is used to control whether remote operating system verification is allowed. By default, the database only runs operating system verification on the local server: SQL> SELECT * FROM GLOBAL_NAME;

In this example, three Users: YAFEISHI, TEST, TEST11 export: C: \ Users \ Administrator> exp system/dang file = c: \ multi_owner.dmp log = c: \ multi_owne rlog grants = n rows = y direct = y owner = (YAFEISHI, TEST, TEST11) Export: Release 10.2.0.3.0

Auto-increment of primary keys in Oracle -- create table MSHOW _ SYSUSER_INFO (ID int primary key, ROLE_ID int not null, LOGIN_NAME varchar2 (50) not null, USER_NAME varchar2 (20), USER_PHONE varchar2 (20), USER_DEPARTMENT varchar2 (50), USER_ADDR