Oracle

Getting Started with Oracle 11g installationModify Shell LimitsVi/etc/security/limits.conf---------------------------------------------Oracle Soft Nofile 65536Oracle Hard Nofile 65536Oracle Soft Nproc 16384Oracle Hard Nproc 16384modifying kernel

Oracle leverages the UTL_HTTP package to provide access to HTTP tools.The following code is online search, you can run directly in the Plsql.DeclareReq Utl_http. REQ;Resp Utl_http. RESP;Val varchar2 (32767);BeginReq: = Utl_http. Begin_request ('

Sql>set Colsep '; -Field Output delimiterSql>set echo off; Displays each SQL command in the script started by the start, which defaults to onSql> set echo on//Set Run command is whether to display statementsSql> set feedback on; Set display "XX row

Oracle System account password expiration resolution.The password for the system account is valid for 180 days, and when the password hint has expired,This can be resolved in the following ways:1> input sqlplus in DOS window, prompt to enter account

View processPs-ef |grep Pmon# su-oracle[You have NEW MAIL]$ sqlplus/as SYSDBASql*plus:release 10.2.0.4.0-production on Mon Feb 9 16:30:23 2015Copyright (c) 1982, Oracle. All rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release

To_date---->> Date_formatSELECT * FROM dual---->> Select ' * ' from dualrownum---->> LimitThe table name is changed to uppercase.Modify dialect, MySQL default dialect is not Bigdecimal,long,textReference needs custom dialectPackage

Recently encountered a more common problem, each row of records need to accumulate sum. These problems are not how difficult, mainly in the process of work will often encounter, especially Oracle's own some of the functions can also be a good

1. Concept A cursor is a handle or pointer to the memory area that SQL handles. An implicit cursor is automatically created when a PL/SQL block is used to execute a DML statement or a SELECT statement that returns only a single row of results. If

I. Maintaining the integrity of the dataData integrity is used to ensure that database data complies with certain commercial and logical rules, and in Oracle, data integrity can be implemented using three methods of constraints, triggers,

Oracle under Linux is in a running state after installation is complete. After restarting the machine, Oracle does not add Oracle to the Windows service as it did under Windows, and the Orcle service needs to be started manually under Linux

1, if you need to create a global DBLink, you need to first determine the user has the right to create DBLink: SELECT * from User_sys_privs where privilege like upper ('%database link% '); If not, you need to use the SYSDBA role to

Error when creating a new library using DBCA:To view resource status:$ crsctl Stat res-t--------------------------------------------------------------------------------NAME TARGET State SERVER State_details--------------------------------------------

In this case, make a data patch, copy the contents of one of the fields in the table to another field, and add a newline if the target field has values.First, the carriage return in Oracle is CHR (13), the newline character is Chr (10), the carriage

First, what is a businessTransactions are used to guarantee the consistency of data, which consists of a set of related DML statements that are either all successful or fail altogether in the group's DML (data manipulation language, additions and

I haven't got up yet, the damn phone is ringing. A nervous message:dataguard database Master never synchronized, quickly climbed up to work. first step, check the alarm log Log.xml . Keep your eyes wide open and look for the abnormal output, and

1.--Creating table SpacesCreate tablespace cmdb_db datafile ' \home\cmdb_11.dbf ' size 100m autoextend on next 50m extent management local;2.--Build UsersCreate user cmdb_1023 identified by admin default Tablespace cmdb_db;3.--give permissionGrant

ORACLE Date functionSysdate the current database system timeAdd_months (plus minus the specified month)Months_between (number of months separated by two dates)Last_day (the last day of the month on which the specified date is taken)Example

Oracle Two optimization modesThe WHERE clause in 1.CBO CBO mode has no effect on query speed2.rbo will perform the index first under Rbo.OLTP online transaction processing refers to systems that frequently change data.OLAP table Data Analysis Index

--1. Deleting temporary tables drop table biz_bus_station_direct_0711;--2. Placing site data, etc. into a temporary tableCreate Tablebiz_bus_station_direct_0711 asSelectLs.line_no Line_no, Bb.line_name line_name, T1.line_direct line_direct,

Often there is a business scenario where we have duplicate records in the same table , and we want to delete the duplicate records, this article is used to solve this problem, the method is the most efficient method I am currently encountering (if