Oracle

Problem: An inexplicable problem occurs when you use Plsql developer to connect to a local Oracle database on a WIN8 64-bit system, and the error prompt box may even be empty. Reason: According to the internet, the reason is estimated to be

1 Select * from 2 (3Select1+1-- in Oracle, the line is written as Select Plus num From dual4 ) tThe example here is very simple, mainly to explain the syntax differencesIn line 4th, what's the matter? I'm surprised. Line 4th there is nothing at all,

1, Case sensitive differences (if the server OS is Linux).In Oracle, it is generally not case-sensitive. Sometimes when we use Oracle to pay no attention to case, table and field names are case insensitive, like this: the INSERT into tableName and

Basic syntax and examples:1. EXP:There are three main ways (full, user, table)1. Complete:EXP System/manager buffer=64000 file=c:\full. DMP full=yIf you want to perform a full export, you must have special permissions2. User mode:EXP sonic/sonic

--The following are the related tablesSELECT * from V$lock;SELECT * from V$sqlarea;SELECT * from V$session;SELECT * from V$process;SELECT * from V$locked_object;SELECT * from All_objects;SELECT * from v$session_wait;--View the locked tableSelect

Examples of common commands:Export:EXPDP Acl/[email protected] directory=dir schemas=acl dumpfile=acl. DMP Logfile=acl.logImport:IMPDP acl/[email protected] directory=dir schemas=acl dumpfile=acl. DMP Logfile=acl.log Note: Do not have a semicolon

Record the use of exit and returnExit to jump out of the loopLoopIF V_KBP is NULL thenEXIT;END IF;End Loop;Return jump out of stored procedureLoopIF V_KBP is NULL thenReturnEND IF;End Loop;Jump out of Loop onceOracle 11g has provided continue;Oracle

About Network InterfacesEach physical and virtual network device on a Oracle Linux system has a associated configuration file named in the ifcfg-interface /etc/sysconfig/network-scriptsdirectory, where interface is the name of the interface. For

Since I do not want to install the Oracle client/oracle server, after installing the Oracle server on the virtual machine Linux, the implementation on win just installs PL/SQL connection to remote Oracle.1. Download the PL/SQL tool installation (my 3

Depending on the data that is protected, Oracle's database locks fall into the following major categories:1.DML Lock (data locks Lock) for data integrity protection;2.DDL Lock (dictionary locks Dictionary Lock), used to protect the structure of

1. Concept:Tablespace: The largest logical storage file, corresponding to one or more physical data files, each database has at least one tablespace, and the size of the tablespace equals the sum of the size of all the data files that make up the

In the Oracle database, Undo has three main functions: providing a consistent read (consistent read), rolling back the transaction (Rollback Transaction), and instance recovery (Instance Recovery).Consistent reads are relative to dirty reads (Dirty

Performance testing sometimes need to analyze the execution of SQL, to identify the need to optimize the Sql,oracle database to provide a good database status and SQL performance monitoring platform, the database monitoring platform can always

Http://www.cnblogs.com/xnzhao/p/6114469.htmlOpen SqlplusPlease enter user name: System/sys as SysdbaThen (unload data) Enter:sql> shutdown Normalwill appear:ORA-01109: Database is not openThe database has been uninstalled.The ORACLE routine has been

You can use the Thetransportable tablespaces feature to copy a set of the tablespaces from one oracledatabase to another.--You can copy the tablespace from one database to another using the TTS attribute.--Starting with Oracle 11gR1, you must use

AWR in Oracle, all known as Automatic Workload Repository, is an automated load repository.AWR is one of the key tools for DBAs to understand the state of their operations, and the AWR report provides an overall understanding and targeted

The first method: Check all empty tables under the current user first Select table_name from user_tables where num_rows=0; Find the empty table using the following sentence Select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from

This article is reproduced from  http://blog.itpub.net/29047826/viewspace-1453577/, Invasion and deletion. 12C has introduced pluggable libraries, and there are two types of administrative users: Local Users and public users. A local user is a user

1 /**2 3 4 5 */---Oracle to return data using cursors, read in ADO6 PROCEDUREIsdt_vehicle_task_check (P_carnuminch VARCHAR2,7 cur_out out Sys_refcursor8) is9G_has_taskvarchar2( +);--Task NumberTen BEGIN One A Select Max(t.task_id) -

Usage of the row_number () over () analysis function in OracleRow_number () over (partition by col1 ORDER by col2) indicates that sorting is based on col1 within the grouping according to Col2 groupings, and that the value computed by this function