Oracle

Some common Oracle knowledge points below are some common small ORACLE knowledge points for your own search and review, to be further supplemented ........ www.2cto.com 1. Open the trace file $ tail-f $ ORACLE_BASE/admin/SID/bdump/alert_SID.log 2.

Oracle sys_refcursor statement Ref_cursor code export create or replace procedure testprodurce is cursor c_row is select * from fpkj; ref_c_row sys_refcursor; -- ref_c_row kplsh varchar2 (200); kplx number; begin for tmp in c_row loop

Oracle beginners to master Part 1-user management learning database, first have to log on to the database, login needs an account? Then we should first understand Oracle's account management and rules, which can better deal with database security

The Selectivity of the index indicates a small part of rows in a row set. This row set can be a base table, view, or join result set, or a group by operation is limited by the query predicate, for example, last_name = 'Smith ', or a joint predicate,

Oracle Database migration 1. raw information record and copy 1. record whether the sid of the database to be migrated is in archive mode (view method: Run archive log list after sys user logs on to sqlplus, default mode is not archive mode when

Add the split function in oracle. CREATE table TYPE www.2cto.com create or replace type "TYPE_SPLIT" as table of varchar2 (4000); 2. create or replace function split (p_list VARCHAR2, p_sep VARCHAR2: = ',') RETURN type_split pipelined is l_idx

(1) freeWww.2cto.comA common problem is:How much memory is used by my applications, servers, users, and system processes? OrHow much memory is available now? If the memory used by running processes is greater than the available RAM, you need to move

The tablespace adjustment record of an oracle RAC database was originally thought to be a matter of several commands, but it turned out to be overwhelmed. The reason is that some commands are not processed properly.Clearly, I only know how to use it,

Oracle index migration, release disk space index file migration steps: preparation: 1) backup GBOS User table index: Use plsqlDevelop tool to export all GBOS User table indexes for backup. Www.2cto.com 1. check that the index tablespace has the

Differences between return and exit in oracle stored procedures create or replace procedure Test5 (o_cellphone in varchar2) is v_cellphone cc_quiz_stat.cellphone % type; v_name cc_quiz_stat % rowtype; v_state cc_quiz_stat.state % type; begin declare

Oracle Dynamic cursor example program code block: SQL code www.2cto.com create or replace procedure PROC_QZCSQKTJ is -- defines the cursor type cursor_type is ref cursor; c_qzcs cursor_type; -- defines the record type record_type is record (ywlx

1. Data Objects include tables, indexes, sequences, views, synonyms, and other structures.This section describes table operations, including indexes, sequences, views, and synonyms.Www.2cto.comIi. Table Creation1. The database mainly stores data,

Time conversion between different oracle Systems (NLS_DATE_LANGUAGE) Time conversion between different systems (NLS_DATE_LANGUAGE) www.2cto.com English: SQL code SELECT TO_CHAR (sysdate, 'Mm/DD/YYYY HH: MI am ', 'nls _ DATE_LANGUAGE = American ')

Oracle deletes an existing Table query system table and determines whether the table exists. If yes, it deletes the select count (*) from user_objects where object_name = upper (p_table_name) SQL code www.2cto.com ); select count (*) from

[PL/SQL] Using Stored Procedures to export specified data to a file (like EXP) Since EXP cannot export specified fields of the TABLE (in fact, you can also use CREATE TABLE tablename AS SELECT... ), so I wrote a storage to implement this function.

Oracle SQL _trace tracking and analysis using tkprof toolsWhen a certain SQL statement is executed or a process/package is executed, the performance may be faulty. We can use SQL _trace to track the execution status of the SQL statement and output

Unzip *. zip has encountered zookeeper before using 'checkdir error: cannot create database' Case Review: The oracle user created under root of www.2cto.com linux, and then use oracle to log on to the Command Used to decompress the oracle10g.zip

Install the software package required by Oracle [Selina @ selina oracle] $ lscompat-db-4.6.21-15.el6.x86_64.rpmcompat-libstdc ++-release ++-4.4.6-4. el6.x86 _ 64. rpmksh-20100621-16.el6.x86_64.rpmlibstdc ++-devel-4.4.6-4.el6.x86_64.rpmlibXp-1.0.0-15.

Oracle deletes duplicate data with only one SQL statement www.2cto.com for querying and deleting duplicate records 1. Searches for redundant duplicate records in the Table. duplicate records are based on a single field (Id) select * from table where

Use DBMS_REDEFINITION to create a non-partition table by online redefinition of the partition table. Note that the table structure and field type of the two tables are consistent. SQL> CREATE TABLE tab_unpart www.2cto.com 2 (3 col1 varchar2 (30), 4