Oracle

For LIKE fuzzy search, you can use the wildcard "%" and "_": %: to indicate any character, including zero; _: to indicate any character; SQL code Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as scott SQL> select *

1. Purpose: The profile in the Oracle system can be used to restrict the database resources that users can use. Use the Create Profile command to Create a Profile to restrict the use of database resources, if the profile is assigned to the user, all

1. Set the value of the NLS_SORT parameter SCHINESE_RADICAL_M to sort SCHINESE_STROKE_M By the beginning (First Order), strokes (Second Order), and heads (Second Order) sort SCHINESE_PINYIN_M by pinyin: www.2cto.com 2. set the Session level. Modify

Generally, when a session is killed, run alter system kill session 'sid, serial # '; Administrator's Guide to say that when the session is active, alter system kill session only identifies the session as a killed or pseudo State and does not release

1. system permission management 1.1 three default users: oracle 9i sys change_on_install [as sysdba] -- sqlplus/as sysdba system manager www.2cto.com scott triger oracle 10 Gb or above sys. [as sysdba] set during system installation. scott triger is

Install rlwrap in Redhat enterprise linuxRlwrap can be used to support the callback function of sqlplus History commands in oracle to improve efficiency. When installing rlwrap, you are prompted to use yum install readline to install readline.1,

Oracle 10g wmsys. use of the wm_concat row-and-column Conversion Function: first, let's take a look at the Magic function wm_concat (column name). This function can separate the column values with "," and display them as a row, the following example

When starting the database today, the following problems occur: [root @ p570a2:/crs/app/oracle/product/crs_1/bin] # su-oracle [oracle @ p570a2: /oracle/app/oracle] $ sqlplus "/as sysdba" SQL * Plus: Release 10.2.0.4.0-Production on Tue Jan 5 11:53:42

1. Authorize a user to view sys. v $ SQL _plan permission 2. create a plan_table-like view SQL> create or replace view dynamic_plan_table 2 as 3 select rawtohex (address) | '_' | child_number statement_id, 4 sysdate timestamp, operation, options,

The ORACLE listener service stops again after it is started. "OracleOraHome81 TNSListener service stops again after it is started,Some services are automatically stopped, if they have nothing to doCause: the ip address obtained by the wireless

Oracle External table to import big text data 1, first create the file storage path create or replace directory phone_dir as 'e: \ oracledir'; if it is not in the current user to create a directory, GRANT the permission: grant read, write on

Oracle External combined command oracle External combined command: To understand (+), the most important thing is that (+) is always placed on the side where information is scarce, and records on this side are displayed as null values. Example:

Before I sorted out the database, the exported database tables had more than 270 mb. After the database was imported, the table space reached 20 GB.This is what happened. The database has been cleared several times. Recently, the database has just

The Thinking and summary of Oracle column-and-column conversion has been working on Oracle-SQL in recent days. It involves some things that are not used at ordinary times, so it has been depressing for a long time here. Now the problem has been

Oracle recovery scenario 1-simulate that data files are damaged or lost. In this scenario, data recovery is relatively simple, but it is still necessary to record work logs. DB version: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit

Oracle 11g ORA-28001 processing received an alarm that monitored users could not connect to the database, Oracle prompted error message ORA-28001: the password has expired, go up to view the user status turned out to be expired, the script for

Oracle remote logon solution: Oracle remote Logon: in cmd: sqlplus scott/tiger @ oracle // there is no space between tiger and @ (and no space is allowed ), the name of the remote connection service added by oracle in netca is in cmd: sqlplus/nolog

The ORACLE line to multi-row problem/** the core solution is to generate a column from 1 to 10, as A "secondary column" **/select level l FROM dual connect by level /** Create a test TABLE T1, that is, table a mentioned by the landlord **/create

Oracle proof: uncommitted transactions may also be written into data files by DBWn to learn oracle, many people will think that DBWn writing is related to commit. This is incorrect. In fact, there is no relationship between DBWn writing and whether

The database encountered the problem of enq: TX-row lock contention. This morning, we made an awr report and the database encountered a lot of waiting events for enq: TX-row lock contention, it feels strange. Query the wait event in gv $ session