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

If PLSQL select into is null, the following error is returned: select column into t_prop In the stored procedure... If no value is found, an error is returned. The processing method is to use an aggregate function, for example, [SQL] create or

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

How to view ORACLE alarm logs?Purpose: first understand what an External table is, and what is the difference with other tables. Create a simple External table (mainly based on the operation process). Finally, use an external table to view the

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,

View oracle tablespace usage 1 select 2 B. file_id File ID, 3 B. tablespace_name tablespace name, 4 B. bytes/1024/1024 | 'mb' number of bytes, 5 (B. bytes-sum (nvl (. bytes, 0)/1024/1024 | 'mb' used, 6 sum (nvl (. bytes, 0)/1024/1024 | 'mb'

Important Oracle SQL statements commonly used at work 1. view the default tablespace of the current user: SQL> select username, default_tablespace from user_users; 2. view the role of the current user: SQL> select * from user_role_privs; 3. view the

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:

OERR: ORA-12519 TNS: no appropriate service handler found client connection intermittent failure, error ORA-12519 Cause: the listener cocould not find any available service handlers that are appropriate for the client connection. action: Check the

Count (1), count (*), order by 1, 2, 3, 4, difference 1 to create NULL data; 2. Use the column name to COUNT and check result 3. Use 1 2 3 4 5 * to COUNT and check that all data is the same as all functions. www.2cto.com 4 order by 1 do use the

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 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

Oracle client PLSQL connection failure solution I wrote in my blog last week that the oracle client is connected to the server http://www.bkjia.com/database/201206/137699.html This article solves the troubles of installing on your own book. Www.2cto.

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