For convenience, search the site: Direct access to or subjects: Reading an AWR (Automatic Workload

For convenience, search the site: Direct access to or subjects: Reading an AWR (Automatic Workload Repository) Grouping related GROUP BY substr and transaction channels Create bpt a CLOB SQL * Loader The directories: manipulation The files bind peeking histograms associated bpt with statistical Secrets of DECODE function triggers execution plans stored Preview autonomous transactions CBO: execution plans according to Reprise target volume data: simple examples primary and foreign keys: to instead bpt its integrity constraints The MERGE statement or inserting selected dbLink: query a remote database Why my index is not used? The bind variables bitmap index for Injection bpt and MDA Create an index function Empty Cache Using rownum and rowid Oracle SQL exceptions lines columns, PIVOT enough for a 11g common queries; DECODE pending migration models views and synonyms The WITH clause to the rescue sub queries to compare the performance of a query with 2 different index The DUAL table to develop Tablespaces, datafiles and filesystem, include storing Edit settings, stop and restart oracle database. Understand what is the listener and test with tnsping Interaction shell Unix / Oracle sqlplus Manage auto-increment in Oracle's data dictionary LOB first steps to circumvent limits LONG Hint oracle and choice of execution plan types SQL and PL types LOB Migration in a dedicated tablespace SQL generating SQL Industrialization CREATE OR REPLACE SQL scripts ... yes but for tables? The views Migration indexes in a tablespace dedicated Virtual columns Mount 11g Oracle data in the Index Cache join: selecting multiple tables and XML Oracle Oracle Import statistics with constraints: The order the insert bpt function partitioned tables from Oracle a procedure bpt java Export database structure Improve the performance of an index for the B-tree
The oracle instruction substr extracts a sub-string from a string, depending on the position of the characters. - Delete the first n-type (n = 12) select substr ('first example of substr', 13) from dual; => 'Substr' - characters after taking k n (n = 4, k = 7) select substr ('2nd example substr', 5, 7) from dual; => 'Example' - take the last n-type (n = 17) select substr ('3rd example substr', -17) from dual; => 'Example substr' associated bpt with instr function and length, it is possible to perform many operations on strings. The instr instruction identifies the position of a substring of character in a string: - touver position "example" select instr ('Here is an example of instr', 'example') from dual; => 10 - remove before "example" select substr part ('Here is an example of instr associated bpt with substr', bpt instr ('Here is an example of instr associated with substr', 'example')) from dual; => 'Example instr associated bpt with substr' or (using the function with: with ma_chain as (select 'is an example of instr associated with substr' s from dual) select substr (s, Instr (s, 'example' )) from ma_chain; => 'example instr associated with substr' - remove the part after "example" with ma_chain as (select 'here is another example of substr instr associated with' s 'eg' t from dual) select substr (s, 1, instr (s, t) + length (t)) from ma_chain; => 'Here is another example' features: substr (colA, 0, n) <==> substr (colA, 1, n ) substr (colA, 0) <==> bpt substr (colA, 1) <==> colA substr (colA, n, k) with k> = length (colA) -n <==> substr (colA, n) Also using the decode function. bpt
bases (12) function (11) index (14) join (11) Maintenance (6) migration (9) optimization (19) setting (9) PL_SQL (15) SQL script bpt (12) sql * loader (1) sqlplus (6 ) tablespace (5) Technical (18) View (5)