Oracle

the concept of temporary tables: There is also a type of table in the Oracle database, called a temporary table. The biggest difference between this temporary table and the permanent table is that the data in the table doesn't exist forever. When

Hibernate use Date, Oracle can be set to date, date can be accurate to seconds, and when Java adds an accurate to a second date to the database, you can directly Set (new Date ()), which is displayed in the database in 2015/10/17 16:15:13, directly

Date type, you can modify it in the following way, only to change the year and the day, not change the minutes and seconds SELECT * from T_bdqc t where Hphm = ' Shaan aw1nw0 ' //Modify for custom time UPDATE t_bdqc SET gxsj = to_date (To_char ( '

The large pool is used to allocate large memory to handle the larger memory of the shared pool and is a standby pool to ease Oracle's pressure on shared pool and PGA memory use The main objects used with large pool are: Multithreaded Server MTS:

11. View parameter information for a datasheet SELECT partition_name, High_value, High_value_length, Tablespace_name, Pct_free, pct_used, Ini_trans, Max_trans, Initial_extent, Next_extent, Min_extent, Max_extent, Pct_increase, freelists,

###### Analysis log file LOGMNR ############## 1) in Init.ora, set utl_file_dir parameter 2) to restart the Oracle 3 Create directory file desc DBMS_LOGMNR _d; Dbms_logmnr_d.build; 4 Add log files add/remove log file Dhms_logmnr.add_logfile

How to connect to an Oracle database from a computer's command prompt (Cmd.exe). Suppose you have an Oracle database with the following information: ip:192.168.0.1 Sid:orcl Port number: 1521 User name: TestUser Password: 123456 The service

Error description Oracle-04082:new or old references are not allowed in table-level triggers Solve the sample (1) Create a trigger, there is a problem CREATE OR REPLACE TRIGGER trigger_cname before DELETE on C DECLARE v_count number; BEGIN

One, Backup script command: @ECHO offIf not exist d:\ora_dmp MD d:\ora_dmpSET backpath=d:\ora_dmpECHO prepares to back up the databaseREM 7 days a loopIF EXIST%backpath%\one GOTO OneIF EXIST%backpath%\two GOTO TwoIF EXIST%backpath%\three GOTO

Transmission door: http://www.cnblogs.com/einyboy/archive/2012/08/01/2617606.html There are four main functions in Oracle that support regular expressions:1,regexp_like: Similar to like function2,REGEXP_INSTR: Similar to INSTR

Oracle time and date operationsSysdate+ (5/24/60/60) Delays 5 seconds based on system time SYSDATE+5/24/60 delays 5 minutes based on system time SYSDATE+5/24 delays 5 hours based on system time SYSDATE+5 delays 5 days based on system time Add_months

The use of parameter files in Oracle startup generally has the following situations 1 Single Instance 1.1 starts by default: In non-RAC environments, the parameter files for Oracle databases are placed by default in the $oracle_home/dbs directory,

Redo (Redo) log features: Data recovery 4.2 Redo Log Features: 1 record database Changes (DML, DDL) 2) for recover of data blocks 3 Manage Redo file in group mode, at least two groups of redo, recycle 4 and data files on different disks, need to

With respect to Oracle's rownum problem, a lot of information said that does not support >,>=,=,between...and, only uses above symbol (,& gt;=,=,between. and will prompt for SQL syntax errors, it is often not to find a record, there will appear to

The cursor (cursor)--the cursor is a data buffer that the system opens for the user, and holds the execution result of the SQL statement. Each cursor area has a name that allows the user to retrieve the record from the cursor in one of the SQL

3 Default users in OracleSYS Change_on_install [as SYSDBA] System Manager Scott Tiger Data Dictionary View what system permissions the current user hasSELECT * from User_sys_privs; View what object permissions the current user hasSELECT * from User_

Before Oracle9i, Chinese is sorted according to binary encoding. In oracle9i, according to pinyin, radical, stroke sorting function. Set Nls_sort value Schinese_radical_m sorted by radical (first order), stroke (second order) Schinese_stroke_m

1, change the client character set: run regedit through Windows Run menu, modify registry Start-> Run-> rededit Under Registry Editor-> HKEY_LOCAL_MACHINE-> SOFTWARE->oracle->key_xe->right WINDOW DOUBLE CLICK Nls_la NG-> Change VALUE to

1. Alternate text UPDATE ' table_name ' SET ' field_name ' = replace (' Field_name ', ' from_str ', ' to_str ') WHERE ... Description: table_name--the name of the table field_name--the field name from_str--the string to replace the string to_str--

1 Insert a piece of data (or delete it again), wasting time, sometimes hundreds of tables will be exhausted. 2 before creating a database Use code: SQL code alter system set DEFERRED_SEGMENT_CREATION=FALSE; Adjust and build tables Neither of these