Oracle

1. View the creation mode of the database sql> select name,cdb,con_id from V$database;NAME CDB con_id---------    ---------    ----------ORA12C Yes 0 shows yes to the database in CDB mode 2. View root container name sql> show Con_nameCon_name--------

In Oracle, the having must be used in conjunction with group by, but in MySQL the situation is different and can be used alone.C:\Documents and Settings\guogang>sqlplus Test/testSql*plus:release 10.2.0.1.0-production on Tuesday August 12 09:09:58 201

Transactionsas the basic unit of logical processing, for database operations, one or more SQL statement to form. Of course, there is a good application for non-database operations, such as a restore point set on a computer. The basic nature of the

Query and delete duplicate records of the SQL statement  1, find redundant records in the table, duplicate records are based on a single field (ID) to determine the  select * from table where Id in (select ID from table group Byid have COUNT (ID) > 1

Implementation results:For example, the following data[PHP]GroupID PersonID Name1 a Super Admin2 B Administrator2 C Testers3 A Super Admin4 B Administrator5 B Administrator5 C Testers5 a Super Admin5 D Leadership6 C Testers6 B Administrator7 A Super

1. Create a new log group1.alter Database Add logfile Group 4 ('/u01/app/oracle/oradata/jian/redo04.log ') size 1024k;2.alter Database Add logfile Group 5 ('/u01/app/oracle/oradata/jian/redo05.log ') size 1024k;2. Switch the current log to a new log

First, user-related SQL statements/* New user */Create user SA identified by ;Description: SA user name, 2013 password/* Authorize Connect,resource to user sa*/Grant connect,resource to SA;Description: Connect role:--is the typical right to grant

Oracle to_date () function usage introduction, oracleto_date In Oracle databases, the Oracle to_date () function is a frequently used function. The following describes the usage of the Oracle to_date () function in detail, hoping to enlighten

Oracle implements SQL syntax aggregation for paging queries and oracle paging SQL syntax The examples in this article summarize the SQL syntax for Oracle paging query, which is for your reference. The details are as follows: 1. There is no order by

Oracle queue type For more information, see the official oracle11gr2 documentation 《Oracle? Database Reference11GRelease 2 (11.2)" Queue definition:The oracle queue has a shared memory for serial access to database resources.Lock. It is produced by

Oraclefga audit has these featuresFga audit has the following features:This article is the original article, reprint please indicate the source: http://blog.csdn.net/msdnchina/article/details/384090571. select * from table_xxx where 1 = 2 -- the

Cache of PL/SQL function results of Oracle11g Two experiments have been conducted to simulate the Oracle Performance Diagnosis art. The book says that if you don't need RELIES_ON, then the changes to the objects on which the function depends will

ORA-00265: requires instance recovery and cannot set ARCHIVELOG mode work undThe solution is as follows:From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the Partitioning, OLAP and Data Mining options disconnectedC: \

Temporary tables in oracleTemporary table: In addition to permanent tables, oracle can also create temporary tables to store session private data, which only exists during the period of a transaction or session. The create global temporary table

Oracle table connection query and its internal operation mechanism 1. Internal Connection The inner join query operation lists the data rows that match the connection condition. It uses the comparison operator to compare the column values of the

Oracle Database permission managementPermission management: the default three usernames and passwords in oracle 9: sys change_on_install // the Administrator with the highest permissions: system manager // normal administrator scott tiger // normal

Solution to PL/SQL Dev connection to Oracle pop-up dialog box, devoracle No way, you can only study it on your own. After about a day, do it well and write a summary. There are several solutions to this problem: 1. Insufficient permissions. A

Steps for clearing OracleFGA audit recordsNote: This article is an original article. For more information, see the source:Http://blog.csdn.net/msdnchina/article/details/384359991. Confirm the fga audit policies,The audit policy can be queried from

How to handle ORA 1455 error when oracle exports data at 11g? ora1455 This exception may occur because the exported User table may have an empty data table. First: View: SQL>show parameter deferred_segment_creation; If this parameter is set to TRUE,

Oracle puts the query results into a custom table and then queries data. The actual example code below can put the query results into a custom table and query data from this custom table: with AA as(SELECT TICKETNUMBER, TICKETTYPE, VERSIONNUMBER,