oracle 更新命令,Oracle 11g命令语法更新

最新推荐文章于 2022-04-19 11:00:57 发布
最新推荐文章于 2022-04-19 11:00:57 发布
阅读量235 收藏
点赞数
文章标签： oracle 更新命令

http://www.psoug.org/library.html

Topic Version Last Modified Comment

Active Session History 10gR2 08-Aug-2006 -

Add Binding Clause 10gR2 01-Nov-2006 -

ADDM Demo 10gR2 09-Aug-2006 -

Advanced Queuing Demo 10gR2 16-Jan-2005 -

Analytic Functions 10gR2 15-Jul-2007

Analyze 11gR1 09-Jul-2007 -

Anonymous Block 11gR1 07-Jul-2007

Anydata Data Type 10gR2 19-Mar-2005 -

Application Server 10.1.2.0.2 07-Feb-2007 -

Application Server 10.1.3.0.0 07-Feb-2007 -

Archive Logs 10gR2 03-Mar-2007 -

Array Processing 10gR2 03-Mar-2007 -

Arrays: Index by BINARY_INTEGER 11gR1 07-Jul-2007

Arrays: Index by VARCHAR2 11gR1 07-Jul-2007

AS OF Queries 10gR2 27-Apr-2007 -

ASH 10gR2 03-Mar-2007 -

Associative Arrays 11gR1 07-Jul-2007 -

Auditing 10gR2 11-Apr-2007 -

AUTHID 10gR2 12-Jan-2006 -

Automatic Workload Repository 10gR2 16-Mar-2005 -

Automatic Workload Repository Report 10gR2 23-Feb-2007 -

Autonomous Transactions 11gR1 07-Jul-2007

Autotrace 11gR1 08-Jul-2007 -

AWR Report 10gR2 23-Feb-2007 -

Backup & Recovery 10gR2 07-Mar-2006 -

B*Tree Indexes 10gR2 23-Jun-2006 -

Bidirectional Cursor 10gR2 02-Mar-2007 -

Bind Variables 10gR2 18-Dec-2005 -

Bitmap Indexes 10gR2 23-Jun-2006 -

Bitmap Join Indexes 10gR2 23-Jun-2006 -

Block Change Tracking 10gR2 14-Dec-2006 -

Block Dump 10gR2 12-Oct-2005 -

Built-in Packages 10gR2 25-May-2007 -

Buffer Pool 11gR1 15-Jul-2007

Bulk Binding / Bulk Collection 10gR2 03-Mar-2007 -

CASE Function 11gR1 12-Jul-2007

Cast Function 10gR2 18-Nov-2005 -

Chained Rows 10gR2 10-Mar-2007 -

Change Data Capture - Sync 10gR2 07-Jun-2006 -

Change Data Capture - HotLog 10gR2 07-Jun-2006 -

Change Data Capture - AutoLog 10gR2 - -

Character Sets 10gR2 29-Jul-2006 -

Character Set Functions 10gR2 21-Nov-2005 -

Check Constraint 10gR2 09-May-2007 -

Clustering Factor 11gR1 07-Jul-2007

Clusters 11gR1 07-Jul-2007

Codd's Rules - 07-Jul-2007 -

Collections 10gR2 18-Nov-2005 -

Collection Functions 10gR2 22-Nov-2005 -

Commit 11gR1 07-Jul-2007

Compilation: Interpreted and Native - - Coming soon in 11g

Compound Triggers - - Coming soon in 11g

Compressed Indexes 10gR2 23-Jun-2006 -

Compressed Tables 10gR2 18-Feb-2007 -

Conditional Compilation 10gR2 11-Sep-2005 -

Conditions 11gR1 08-Jul-2007

Connect By 11gR1 08-Jul-2007

Constraints 10gR2 06-May-2007 -

Consumer Groups 10gR2 03-Jan-2006 -

Contexts 10gR2 18-Nov-2005 -

Control Files 10gR2 10-Oct-2005 -

Control Structures 10gR2 02-Mar-2007 -

Conversion Functions 10gR2 09-Dec-2006 -

Create Database 10gR2 21-Nov-2006 -

Create Schema 11gR1 08-Jul-2007

Cross Tabulation 11gR1 07-Jul-2007

CTX_DDL 10gR2 29-Apr-2007 incomplete

Cube 10gR2 09-Dec-2006 -

Cursor Sharing 10gR2 14-Dec-2006 -

Cursors & Cursor Loops 10gR2 02-Mar-2007 -

DANGLING 10gR2 08-Mar-2007 -

Data Control Language (DCL) 11gR1 07-Jul-2007 -

Data Dictionary 10gR2 15-Apr-2006 -

Data Files 10gR2 26-May-2007 -

Data Guard 10gR2 30-May-2007 Physical Only

Data Integrity 10gR2 11-Mar-2007 -

Data Mining Functions 10gR2 22-Nov-2005 -

Data Pump (API) 10gR2 - -

Data Pump (Executable) 10gR2 - -

Data Types & SubTypes 10gR2 12-Nov-2005 -

Database 10gR2 21-Nov-2006 -

Database Links 10gR2 08-Apr-2007 -

Date Functions 10gR2 06-Jun-2007 -

DBMSOBJG 11gR1 08-Jul-2007

DBMS_ADVANCED_REWRITE 10gR2 10-May-2007 -

DBMS_ADVISOR 10gR2 18-Apr-2007 -

DBMS_ALERT 11gR1 08-Jul-2007

DBMS_AMD 11gR1 08-Jul-2007

DBMS_APPLICATION_INFO 11gR1 08-Jul-2007

DBMS_APPLY_ADMIN 10gR2 01-Jun-2006 incomplete

DBMS_AQ 10gR2 20-Dec-2005 -

DBMS_AQADM 10gR2 03-Jul-2007

DBMS_AQELM 10gR2 20-Dec-2005 -

DBMS_ASSERT 10gR2 12-Feb-2006 -

DBMS_ASYNCRPC_PUSH 11gR1 08-Jul-2007

DBMS_CAPTURE_ADM 10gR2 07-Jun-2007 -

DBMS_CDC_PUBLISH 10gR2 23-Mar-2006 -

DBMS_CDC_SUBSCRIBE 10gR2 23-Mar-2006 -

DBMS_CHANGE_NOTIFICATION 10gR2 30-Apr-2007 -

DBMS_CLUSTDB 11gR1 08-Jul-2007

DBMS_CRYPTO 10gR2 09-Apr-2007 -

DBMS_CRYPTO_TOOLKIT_TYPES 10gR2 29-Nov-2006 -

DBMS_DATAPUMP 10gR2 03-Jun-2007 -

DBMS_DBLINK 10gR2 29-Nov-2006 -

DBMS_DB_VERSION 10gR2 11-Sep-2005 -

DBMS_DBVERIFY 10gR2 11-Sep-2005 -

DBMS_DDL 10gR2 11-Sep-2005 -

DBMS_DDL_INTERNAL 10gR2 02-Jun-2006 -

DBMS_DESCRIBE 10gR2 11-Sep-2005 -

DBMS_DRS 10gR2 29-Nov-2006 -

DBMS_ERRLOG 10gR2 12-Aug-2006 -

DBMS_EXPFIL 10gR2 11-Sep-2005 -

DBMS_EXTENDED_TTS_CHECKS 10gR2 11-Sep-2005 -

DBMS_FEATURE_USAGE 10gR2 14-Sep-2005 -

DBMS_FEATURE_USAGE_REPORT 10gR2 22-Mar-2007 -

DBMS_FGA 10gR2 11-Apr-2007 -

DBMS_FILE_TRANSFER 10gR2 15-Sep-2005 -

DBMS_FLASHBACK 10gR2 25-Sep-2005 -

DBMS_HA_ALERTS 10gR2 03-Jun-2006 -

DBMS_HA_ALERTS_PRVT 10gR2 03-Jun-2006 -

DBMS_INDEX_UTL 10gR2 16-Oct-2006 -

DBMS_IOT 10gR2 21-Apr-2007 -

DBMS_I_INDEX_UTL 10gR2 10-Dec-2006 -

DBMS_JOB 10gR1 14-Apr-2005 See DBMS_SCHEDULER too

DBMS_LCR 10gR2 16-Sep-2005 -

DBMS_LDAP 10gR2 27-Nov-2006 -

DBMS_LOB 10gR2 15-Jul-2007

DBMS_LOCK 10gR2 24-Nov-2005 -

DBMS_LOGMNR 10gR2 08-May-2006 -

DBMS_METADATA 10gR2 06-Dec-2006 -

DBMS_MONITOR 10g 16-Oct-2006 -

DBMS_MVIEW 10gR2 20-Nov-2006 -

DBMS_OBFUSCATION_TOOLKIT - - Deprecated See DBMS_CRYPTO

DBMS_ODCI 11gR1 10-Jul-2007 -

DBMS_OUTLN 10gR2 30-May-2006 -

DBMS_OUTLN_EDIT 10gR2 30-May-2006 -

DBMS_OUTPUT 11gR1 10-Jul-2007

DBMS_PCLXUTIL 11gR1 10-Jul-2007

DBMS_PREDICTIVE_ANALYTICS 10gR2 13-Aug-2006 -

DBMS_PREPROCESSOR 10gR2 15-Oct-2005 -

DBMS_PROFILER 10gR2 23-Feb-2007 -

DBMS_PROPAGATION_ADM 10gR2 07-Jun-2007 -

DBMS_RANDOM 11gR1 10-Jul-2007 See DBMS_CRYPTO too

DBMS_RECTIFIER_DIFF 11gR1 10-Jul-2007 -

DBMS_RECTIFIER_FRIENDS 11gR1 10-Jul-2007

DBMS_REDEFINITION 10gR2 23-Mar-2007 -

DBMS_REFRESH 10gR2 19-Nov-2005 -

DBMS_REGISTRY 10gR2 14-Oct-2006 -

DBMS_REGISTRY_SERVER 10gR2 28-Nov-2006 -

DBMS_REGXDB 10gR2 01-Dec-2006 -

DBMS_REPAIR 10gR2 25-Sep-2006 -

DBMS_RESOURCE_MANAGER 10gR2 03-Jan-2006 -

DBMS_RESOURCE_MANAGER_PRIVS 10gR2 03-Jan-2006 -

DBMS_RESUMABLE 10gR2 15-Nov-2005 -

DBMS_RLS 10gR2 16-Sep-2005 -

DBMS_ROWID 10gR2 22-Feb-2007 -

DBMS_SCHEDULER 10gR2 18-May-2006 -

DBMS_SCHEMA_COPY 10gR2 06-May-2006 -

DBMS_SERVER_ALERT 10gR2 01-Jan-2006 -

DBMS_SERVER_TRACE 10gR2 30-Nov-2006 -

DBMS_SERVICE 10gR2 17-Jan-2007 -

DBMS_SESSION 10gR2 29-Apr-2007 -

DBMS_SHARED_POOL 10gR2 25-Nov-2005 -

DBMS_SNAPSHOT 10gR2 08-Oct-2005 -

DBMS_SPACE 10gR2 25-Nov-2005 -

DBMS_SPACE_ADMIN 10gR2 15-Mar-2007 -

DBMS_SQL 10gR2 30-Dec-2005 -

DBMS_SQLHASH 10gR2 14-Feb-2006 -

DBMS_SQLPLUS_SCRIPT 10gR2 23-Mar-2007 -

DBMS_SQLTUNE 10g 26-Jan-2007 -

DBMS_STAT_FUNCS 10gR2 20-Dec-2006 -

DBMS_STATS 10gR2 06-Dec-2006 -

DBMS_STREAMS 10gR2 07-Jun-2007 -

DBMS_STREAMS_ADM 10gR2 07-Jun-2007 -

DBMS_STREAMS_AUTH 10gR2 07-Jun-2007 -

DBMS_SUPPORT 10gR2 17-Mar-2007 -

DBMS_SYSTEM 10gR2 04-Dec-2006 -

DBMS_TDB 10gR2 01-Dec-2006 -

DBMS_TRACE 10gR2 16-Nov-2005 -

DBMS_TRANSACTION 10gR2 30-Dec-2005 -

DBMS_TRANSFORM 10gR2 26-Nov-2005 -

DBMS_TTS 10gR2 20-Nov-2005 -

DBMS_TYPES 10gR2 11-Dec-2005 -

DBMS_UNDO_ADV 10gR2 17-Oct-2006 -

DBMS_UTILITY 11gR1 10-Jul-2007

DBMS_WARNING 10gR2 16-Jul-2007 -

DBMS_WARNING_INTERNAL 11gR1 15-Jul-2007

DBMS_WM Synonym 10gR2 17-Dec-2005 -

DBMS_WORKLOAD_REPOSITORY 10gR2 16-Oct-2006 -

DBMS_XDBUTIL_INT 10gR2 09-Sep-2006 -

DBMS_XMLGEN 10gR2 15-Jul-2007

DBMS_XPLAN 10gR2 16-Dec-2006 -

DBMS_ZHELP 11gR1 13-Jul-2007 -

DBMS_ZHELP_IR 11gR1 13-Jul-2007 -

DBV (database verify) 10gR2 26-Nov-2005 -

DCL Statements 11gR1 07-Jul-2007 -

DDL Event Triggers 10gR2 05-Mar-2007 -

Deadlocks 11gR1 07-Jul-2007

DECODE Function 11gR1 12-Jul-2007

Delete Statement 10gR2 10-Mar-2005 -

Descending Indexes 10gR2 23-Jun-2006 -

Dimensions 10gR2 20-Nov-2006 -

Directories 10gR2 07-Nov-2006 -

DIUTIL 11gR1 11-Jul-2007

DML Statements 11gR1 07-Jul-2007 -

Dynamic Performance Views 10gR2 05-May-2007 -

Environment Variables 10gR2 30-Mar-2006 -

Errors All 07-Jul-2007 -

Exception Handling 10gR2 27-Feb-2007 -

Excluded Nodes 10g 15-Jun-2005 -

Exists 10gR2 24-Oct-2005 -

Explain Plan 10gR2 21-Apr-2007 -

Export 10gR2 16-Dec-2005 -

Expression Filtering 10g 28-Apr-2005 -

External Tables 10gR2 04-Jun-2007 -

Files Of Interest 10gR2 09-Apr-2007 -

Fine Grained Access Control (FGAC) 10gR2 16-Sep-2005 -

Flashback 10gR2 07-Jul-2007

Flashback Database 10gR2 10-May-2006 -

Flashback Drop 10gR2 02-May-2007 -

Flashback Query 10gR2 02-May-2007 -

Flashback Table 10gR2 05-May-2007 -

Flashback Transaction 10gR2 02-May-2007 -

Flashback Version 10gR2 02-May-2007 -

FOLLOWS Clause - - Coming soon in 11g

FOR UPDATE 10gR2 26-Nov-2005 -

FORALL 10gR2 03-Mar-2007 -

Foreign Key Constraint 10gR2 09-May-2007 -

FORMs 10g 24-Jan-2005 -

Function Based Indexes 10gR2 23-Jun-2006 -

Functions: Miscellaneous 10gR2 06-Feb-2007 -

Functions: User Defined 10gR2 26-May-2007 -

Fusion MiddleWare Application Server 10.1.3 02-Jan-2007 -

Global Hints 10gR2 22-Aug-2006 -

Global Partitioned Indexes 10gR2 25-May-2007 -

Global Temporary Tables 11g 15-Jul-2007 -

Globalization Toolkit 10gR2 25-Oct-2005 -

Grid Control 10gR2 07-May-2007 -

GROUP BY Clauses 10gR2 09-Dec-2006 -

GROUPING SETS 10gR2 09-Dec-2006 -

Guaranteed Restore Point 10gR2 11-Apr-2007 -

GV$ Views 10gR2 05-May-2007 -

HAVING Clauses 10gR2 09-Dec-2006 -

Hints 10gR2 17-Mar-2007 incomplete

Histograms 10gR2 15-Apr-2006 -

Host Environment 10gR2 29-Sep-2006 -

HTP 10gR2 16-Jun-2006 -

IF Statements 10gR2 02-Mar-2007 -

Import 10gR2 16-Dec-2005 -

Indexes 10gR2 23-Jun-2006 -

Index Organized Tables (IOT) 10gR2 29-May-2006 -

Init SID Dot Ora 10gR2 04-Apr-2007 -

Inline Views 10gR2 24-Nov-2006 -

Insert Statements 10gR2 02-May-2007 -

Instead-Of Triggers 10gR2 28-Nov-2005 -

Instring Function 11gR1 15-Jul-2007 -

Intermedia Audio 10g 21-Jul-2004 -

Intermedia Video 10g 21-Jul-2004 -

Interval 10gR2 19-Nov-2005 -

Invisible Indexes - - Coming soon in 11g

Invited Nodes 10g 15-Jun-2005 -

Joins 10gR2 21-Nov-2005 -

Keep Pool 11gR1 15-Jul-2007

Killing Sessions 10gR2 16-Jan-2005 -

Licensing 10gR2 30-Sep-2006 -

Listener 10gR2 30-Sep-2006 -

LOB_Compression 10gR2 25-Oct-2005 -

Local Partitioned Indexes 10gR2 25-May-2007 -

Locks 10gR2 24-Feb-2005 -

Log Files 10gR2 08-Nov-2006 -

LONG To CLOB 10gR2 26-Nov-2005 -

Loops 10gR2 24-Oct-2005 -

LT Built-in Package 10gR2 17-Dec-2005 -

Materialized Views 10gR2 02-Jan-2007 -

Merge Statement 10gR2 26-Nov-2005 -

Microsoft SQL Server 2005 Comparison - 24-Apr-2007 -

Microsoft Vista Enterprise and Oracle - 21-Apr-2007 -

Model Clause 10g 09-Dec-2006 -

Multiset 10gR2 18-Nov-2005 -

Multiversion Concurrency Control (MVCC)  10gR2 27-Sep-2006 -

Native Compilation - - Coming soon in 11g

Native Dynamic SQL (NDS) 10gR2 03-Dec-2005 -

Nested Loops 10gR2 02-Mar-2007 -

Nested Tables 10gR2 05-Dec-2005 -

Nested Table Constraints 10gR2 09-Dec-2006 -

Net Services 10g 03-May-2005 -

Network Appliance Filer Management - 16-Jan-2007 -

NID (change internal database identifier) 10gR2 26-Nov-2005 -

No Segment Indexes 10gR2 23-Jun-2006 -

NOCOPY 10gR2 12-Jan-2006 -

Normalization - 11-Sep-2005 -

NOWAIT 10gR2 26-Nov-2005 -

Numeric Functions 10gR2 15-Dec-2006 -

NULL 10gR2 03-Feb-2007 -

NULL Pruning 10gR2 15-Apr-2006 -

Object Privileges 10gR2 26-Nov-2005 -

Object-Relational Views 10g 17-Nov-2004 -

Operators: Built-in 10gR2 29-Nov-2005 -

Operators: User Defined 10gR2 01-Nov-2006 -

ORA_HASH 11gR1 13-Jul-2007 -

ORA_NAME_LIST_T 10gR2 16-Jun-2006 -

ORA_ROWSCN 10gR2 10-May-2007 -

ORADEBUG 10gR2 08-Aug-2006 -

ORADIM 10gR2 23-Nov-2005 -

ORAPWD 10gR2 13-Jul-2006 -

ORDER BY Clause 11gR1 07-Jul-2007

Outlines 10gR2 30-May-2007 -

OUTLN_EDIT_PKG 10gR2 30-May-2006 -

OUTLN_PKG 10gR2 30-May-2006 -

OWA_CUSTOM 10gR2 05-Mar-2007 -

OWA_CX 10gR2 19-Mar-2007 -

OWA_OPT_LOCK 10gR2 14-Jan-2007 -

OWA_SEC 10gR2 06-May-2007 -

OWA_TEXT 10gR2 06-May-2007 -

OWA_UTIL 10gR2 06-May-2007 -

Packages: User Defined 10gR2 29-Mar-2007 -

Partitioning (tables and indexes) 10gR2 25-May-2007 -

Partitioning Elimination Demo 10gR2 25-May-2007 -

Partitioning Pruning Demo 10gR2 25-May-2007 -

Pipelined Table Functions 10gR2 15-Mar-2007

PLSQL_CCFLAGS 10gR2 11-Sep-2005 -

PL/SQL Object Settings 11gR1 08-Jul-2007

PRAGMAS 10gR2 16-Dec-2006 -

PRAGMA Autonomous_Transaction 10gR2 16-Sep-2005 -

PRAGMA Exception_Init 10gR2 26-Nov-2005 -

PRAGMA Serially Reusable 10gR2 17-Jul-2005 -

Primary Key Constraint 10gR2 09-May-2007 -

Procedures 10gR2 02-Mar-2007 -

Product User Profiles 10gR2 30-Nov-2005 -

Profiles 11gR1 13-Jul-2007 -

Protocol.ora 10gR2 03-May-2005 Deprecated See: SQLNET.ORA

Pseudo Columns 10gR2 10-May-2007 -

Purge Recyclebin 10gR2 02-May-2007 -

Purge Table 10gR2 08-Mar-2006 -

Quote Delimiters 10gR2 10-Jul-2006 -

RAC 10gR2 31-Jul-2006 -

RAID 10gR2 16-Jan-2005 -

Rank 10gR2 30-Nov-2005 -

RDA 10gR2 05-Oct-2006 -

Real Application Clusters 10gR2 16-Jan-2006 -

Recycle Bin 10gR2 15-Jul-2007

Recycle Pool 11gR1 15-Jul-2007

Redo 10gR2 23-Mar-2007 -

Ref Cursors 10gR2 05-Dec-2005 -

Referential Constraint 10gR2 09-May-2007 -

Regular Expressions 10gR2 15-Jul-2007

Remote Diagnostic Agent 10gR2 05-Oct-2006 -

Replace Built-in Function 10gR2 15-Jul-2007

Restore Point 10gR2 11-Apr-2007 -

Resumable Transactions 10gR2 15-Nov-2005 -

Reverse Key Indexes 10gR2 23-Jun-2006 -

Rewrite Equivalence 10gR2 11-Sep-2005 -

RMAN 10gR2 26-Apr-2006 incomplete

RMAN Demo 10gR2 19-Mar-2006 incomplete

Roles 10gR2 28-Nov-2005 -

Rollback 11gR1 07-Jul-2007

Rollup 10gR2 09-Dec-2006 -

ROWDEPENDENCIES 10gR2 27-Nov-2005 -

ROWID 10gR2 27-Nov-2005 -

Row Level Security 10gR2 16-Sep-2005 -

ROWNUM 10gR2 27-Nov-2005 -

Rule Based Optimizer (RBO) 10g 16-Apr-2004 Deprecated

Sample Clause 10gR2 12-Jul-2006 -

Savepoint 11gR1 07-Jul-2007

Schema 11gR1 08-Jul-2007

Select Statement 10gR2 16-Dec-2006 -

Sequences 11gR1 07-Jul-2007

Services 10gR2 26-Nov-2005 -

Sessions 10gR2 24-Feb-2006 -

Set Operators 10gR2 29-Nov-2005 -

SHOW 10gR2 22-Dec-2006 -

SKIP LOCKED 10gR2 26-Nov-2005 -

SLEEP 10gR2 28-Feb-2007 -

Snapshots 10gR2 30-Apr-2006 -

Sorted Hash Clusters 10gR2 26-Feb-2007 -

Soundex 10gR2 16-Sep-2006 -

SPFile 10gR2 26-Jan-2007 -

SQL Injection 10gR2 05-Mar-2007 -

SQL*Loader 10gR2 03-May-2007 -

SQL*Plus 10gR2 21-Apr-2007 -

SQLNET.ORA 10gR2 03-May-2005 -

Standard 10gR2 16-Sep-2006 -

Starting & Stopping The Database 10gR2 16-Jul-2007

Startup Parameters 10gR2 05-Apr-2007 -

Stored Outlines 10gR2 19-May-2007 -

Stored Procedures 10gR2 21-Nov-2005 -

Storage - 24-Apr-2006 -

Streams Demo 1 10gR2 07-Jun-2007 -

Streams Demo 2 10gR2 - -

String Functions 10gR2 07-Mar-2007 -

Subqueries 10gR2 24-Oct-2005 -

Substring Function 11gR1 15-Jul-2007 -

Sybase ASE 15.0.1 Comparison - 26-Jan-2007 -

Synonyms 10gR2 24-Nov-2006 -

SYS_CONTEXT Built-in Function 10gR2 17-Mar-2007 -

SYS_GUID 10gR2 09-Dec-2006 -

SYS_OP_DESCEND 10gR2 16-Jun-2006 -

SYS_OP_DISTINCT 10gR2 09-Mar-2007 -

SYS_OP_GUID 10gR2 27-May-2007 -

SYS_OP_LBID 10gR2 16-Jun-2006 -

SYS_OP_MAP_NONNULL 10gR2 09-Sep-2006 -

SYS_OP_RAWTONUM 10gR2 09-Mar-2007 -

SYS_OP_RPB 10gR2 07-Mar-2007 -

SYS_OP_TOSETID 10gR2 07-Mar-2007 -

SYS_TYPEID 10gR2 29-Dec-2006 -

System  10gR2 03-Dec-2006 -

System Events  10gR2 11-Feb-2007 -

System Event Triggers 10gR2 18-Apr-2007 -

System Privileges  10gR2 30-Nov-2006 -

System Statistics  10gR2 25-Feb-2007 -

Table Collection Expression 10gR2 18-Nov-2005 -

Tables 10gR2 15-Jul-2007

Table Triggers 10gR2 29-Mar-2007 -

Tablespaces 10gR2 15-Jul-2007

Tablespace Groups 10gR2 06-Jan-2006 -

Timestamp 10gR2 19-Nov-2005 -

Time Zones 10gR2 19-Nov-2005 -

TKPROF 10gR2 07-May-2007 -

Trace File Identifier 10gR2 26-Sep-2006 -

Tracing 10gR2 07-May-2007 -

Trace Analyzer 9i 12-Nov-2003 -

Transactions 10gR2 16-Sep-2005 -

Translate Built-in Function 10gR2 15-Jul-2007

Transportable Tablespaces 10gR2 07-Jan-2006 -

Truncate (Tables & Partitions) 10gR2 26-Nov-2005 -

Tuning 10gR2 05-Mar-2007 -

Types 10g 16-Apr-2004 -

Undocumented Oracle 10gR2 29-May-2007 -

UNIX / vi - 15-Jul-2007 -

Unique Constraint 10gR2 09-May-2007 -

Update Statement 10gR2 26-Nov-2005 -

USERENV 10gR2 02-Dec-2005 See SYS_CONTEXT

Users 10gR2 08-Nov-2006 -

USER_LOCK 10gR2 14-Nov-2005 -

Utilities 10gR2 21-Mar-2007 -

UTL_COLL 10gR2 13-Nov-2005 -

UTL_COMPRESS 10gR2 25-Oct-2005 -

UTL_ENCODE 10gR2 13-Nov-2005 -

UTL_FILE 10gR2 25-Oct-2005 -

UTL_GDK 10gR2 29-May-2007 -

UTL_HTTP 10gR2 09-Jun-2006 -

UTL_I18N 11gR1 15-Jul-2007

UTL_INADDR 11gR1 07-Jul-2007

UTL_LMS 11gR1 07-Jul-2007

UTL_MAIL 10gR2 12-Nov-2005 -

UTL_MATCH 10gR2 12-Nov-2005 -

UTL_RAW 10gR2 30-Mar-2007 -

UTL_RECOMP 10gR2 30-Mar-2007 -

UTL_REF 10gR2 16-Jan-2006 -

UTL_SMTP 10gR2 12-Nov-2005 Deprecated: See UTL_MAIL

UTL_TCP 10gR2 29-Apr-2007 -

UTL_URL 10gR2 12-Nov-2005 -

Varrays 10gR2 03-Dec-2005 -

VERSIONS BETWEEN 10gR2 27-Nov-2005 -

Views 11gR1 07-Jul-2007

Virtual Columns - - Coming soon in 11g

Virtual Indexes 10gR2 23-Jun-2006 -

Virtual Private Database 10gR2 16-Sep-2005 -

V$ Views 10gR2 05-May-2007 -

WAIT 10gR2 26-Nov-2005 -

Where Clause 10gR2 26-Nov-2005 -

Wildcards 10gR2 26-Nov-2005 -

Windows 10gR2 28-Apr-2006 -

WITH Clause 10gR2 15-Jul-2007

Workspace Manager 10gR2 17-Dec-2005 -

WPG_DOCLOAD 10gR2 25-Jul-2006 -

Wrap 10gR2 26-Nov-2005 -

Write CLOB to file 10gR2 25-Jul-2006 -

XML Functions 10gR2 28-May-2007 -

XMLQuery 10gR2 16-Sep-2005 -

XMLTable 10gR2 16-Sep-2005 -

XMLTYPE 11gR1 14-Jul-2007

XML Tables 10gR2 16-Sep-2005 -

良田美池
关注
dbms_UTL_file
weixin_36408281的博客
11-30 361
dbms_UTL_file包： 用于读写os系统文件; 使用该包时，必须为os文件建立directory目录；create or replace directory USR_DIR as ‘E:\新建文件夹’;–1.file_type /* 该方法是utl_file包，所定义的记录类型； */type file_type is record (
oracle教程：创建手动刷新的物化视图
学亮编程手记
09-11 988
1、物化视图概念：将视图中查询出来的数据存储到一张表中。2、优点：查询速度比视图要快。3、缺点：占用资源，并且要时时更新数据。4、创建物化视图。
oracle 当值为1时更新为2,静默升级oracle 11g （从11.2.0.1升级到11.2.0.4）
weixin_39942213的博客
04-05 259
一个环境是oracle 11.2.0.1，一个环境是oracle 11.2.0.4，同样的数据，同样的sql，在两个版本数据库表现不一样。于是，干脆都统一为11.2.0.4。但由于环境限制，只能用静默的方法，把oracle 11.2.0.1 升级到 11.2.0.4。不过，还好，根据网上的文档，升级过程还算顺利。下面，我记录一下升级过程，供自己以后查看，也供有需要的人参考。1、11.2.0.1环境...
SYS_OP_MAP_NONNULL操作
ckawt40802的专栏
08-05 434
无意在数据库中发现了这个操作SYS_OP_MAP_NONNULL。 SYS_OP_MAP_NONNULL应该不是数据库中的对象，因为在DBA_OBJECTS中根本找不到它，而在STANDARD和DBMS_STAND...
ORACLE查询优化之is null和is not null优化
weixin_30667649的博客
08-17 1049
　　最近工作的时候遇到了比较大的数据查询，自己的sql在数据量小的时候没问题，在数据量达到300W的时候特别慢，只有自己优化sql了，以前没有优化过，所以记录下来自己的优化过程，本次是关于is null和is not null的优化。所用环境0racle11g 　　现有a表，a表中有字段b，我想查出a表中的b字段is null的数据。 select * from a where b is ...
oracle 选反集合,Oracle集合操作
weixin_42496802的博客
04-03 334
集合关键字：1、UNION：并集，所有的内容都查询，重复的显示一次,默认进行升序排序；2、UNIONALL：并集，所有的内容都显示，包括重复的，展示内容没有排序；3、INTERSECT：交集，只显示多个查询中相同的元素部分；4、MINUS：差集，显示第一个查询中有，第二个查询中没有的元素例子：在scott用户下，创建表emp2，该表只包含emp中20部门员工的信息：代码：create table ...
Oracle11G基本语法
12-14
Oracle 11g 是一款广泛使用的商业关系数据库管理系统，它提供了丰富的功能和高效的数据处理能力。在学习Oracle 11g的过程中，了解其基本语法是至关重要的。这包括数据库的安装与配置、用户管理和表的操作。 首先，...
ORACLE相关语法与命令.docx
05-03
ORACLE 相关语法与命令 ORACLE 是一种关系型数据库管理系统，具有强大的数据存储和管理能力。下面是 ORACLE 相关语法与命令的总结： 物理组件 1. 数据文件（Data File）：用于存储数据库数据的文件，每个 ORACLE ...
Oracle11g RMAN 语法手册（PDF+EPUB，带书签目录，非扫描版）
02-17
Oracle 11g 的 Recovery Manager (RMAN) 是一个强大的工具，专为数据库备份和恢复设计。本手册详细阐述了 RMAN 的语法和用法，是数据库管理员进行数据保护和故障恢复的重要参考资料。以下是 RMAN 的核心知识点： 一...
Oracle日常运维常用命令速查手册
最新发布
09-14
Oracle 是一款功能强大且广泛应用的关系数据库管理系统，作为Oracle运维人员，熟悉常用的命令和语句是非常必要的。本文档汇总了 Oracle 日常运维中常用的命令和语句，包括登录 Oracle 数据库、创建数据表、约束的...
oracle comment命令用法示例分享
01-19
oracle中用comment on命令给表或字段加以说明，语法如下： 代码如下:COMMENT ON { TABLE [ schema. ] { table | view } | COLUMN [ schema. ] { table. | view. | materialized_view. } column | OPERATOR [ ...
Oracle之DBMS_SQL包用法详解
月下狼~图腾~
09-27 1559
通常运用DBMS_SQL包一般分为如下几步： 1. open cursor：打开cursor 2. parse cursor：解析你要执行的SQL语句 3. bind variable：如果要执行的SQL语句中包含变量，在此就需要绑定变量 4. execute：执行SQL语句 5. close cursor：在执行后关闭此cursor. 如果你还需要返回执行SQL的结果集，还需要使用...
ORACLE 11g自带DBMS函数包
HXC_HUANG的博客
06-03 2129
select object_name,status,object_type from dba_objects where object_name like ‘%DBMS%’ and object_type=’PACKAGE’;1 DBMS_STANDARD VALID PACKAGE 2 DBMS_REGISTRY VALID PACKAGE 3 DBMS_REGIS
关于Oracle数据库常用操作指令盘点
ysds20211402的博客
04-19 409
转自：微点阅读https://www.weidianyuedu.com 一、启动和关闭Oracle数据库 1. 数据库启动以SYSDBA身份登录数据库启动命令：STARTUP 【启动选项】 数据库启动三个阶段： 启动Oracle实例（非安装阶段） 由实例安装数据库（安装阶段） 打开数据库（打开阶段） 2. 数据库的关闭 以SYSDBA身份登录数据库关闭命令：SHUTDOWN 【启动选项】数据库关闭三个阶段： 关闭数据库 卸载数据库 关闭Oravle实例 ▎...
oracle 更新update语句
热门推荐
xue_yanan的博客
10-10 9万+
update 表名 set 列名=新值 where条件; select语句 for update;
Oracle 数据库的绑定变量特性及应用
abc123098098的博客
04-30 229
关键词: 绑定变量(binding variable),共享池(shared buffer pool), SGA(system global area); 在开发一个数据库系统前,有谁对Oracle 系统了解很多,尤其是它的特性,好象很少吧;对初学者来讲,这更是不可能的事情;仅仅简单掌握了SQL的写法,就开始了数据库的开发,其结果只能是开发一个没有效率,也没有可扩展的系统; 因此,...
oracle常用命令（日常整理，持续更新）
king_harry的专栏
04-18 1万+
oracle常用命令 一、Oracle数据库实例、用户、目录及session会话查看： 1、ORACLE SID查看设置 查看SID、用户名 $ env|grep SID 、select * from v$instance、select instance_name,host_name from v$instance; 查看数据库所有用户及用户状态： SQL> select user
oracle 11g 补丁更新步骤
TT的博客
06-06 1万+
1.检查OPatch版本需要跟踪对应补丁的README说明，确定当前环境的OPatch版本符合要求，如果不符合要求，需要下载符合要求的OPatch版本。1.1 查询OPatch版本$ORACLE_HOME/OPatch/opatch version 1.2 替换为新版本OPatch(GRID_HOME and ORACLE_HOME)备份原来的OPatch，解压新版本OPatch到$ORACLE...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值