Oracle

Execute SQL files in batches and output execution logs. 1. Create the betchinsert. bat file. Content: sqlplus username/password @ service name @ BETCH. SQL> SQLINSERT. log exit 2. Create The betah. SQL file. Content: @ nkgis. SQL \ AE _USERS. SQL @

Oracle Database remote connection configuration steps and FAQs objective computer needs: Open net manager1: In the listener: Change "host" to the computer name (ensure that the name is unique) 2: with the listener, you need to specify the database

[Oracle] variable binding Parent-Child cursor (parent-Child cursor) Parent cursor: as long as the SQL statement text is the same, they correspond to the same parent cursor. Sub-cursor: in some cases, although the SQL statement has the same text,

Several ways for Oracle to delete duplicate records [html] several ways for Oracle to delete duplicate records if a file is imported into the database multiple times, duplicate records may be introduced, which methods can be used to delete duplicate

Empty oracle table ticket cleanup 1. query table space usage: sqlplus system/manager @ topprodSQL> @ q_tbsFREE2. how to query temp: sqlplus system/manager @ topprodSQL> SELECT d. tablespace_name, d. status tablespace_status, NVL (. bytes, 0)

In oracle, The row_number () over () analysis function row_number () over (partition by col1 order by col2) indicates grouping by col1 and sorting by col2 within the grouping, the value calculated by this function indicates the sequential numbers

To export the table structure in oracle stored procedures, we need to reverse all the table structures in the database, including partition tables and non-partition tables. The fields involved include number, data, timestamp, varchar2, and char.

The truncate implicit commit colleague asked me to check the problem. procedure jumped out of exception and rolled back in the middle, but some table commit still exists, but no commit statement was found before rollback. it is still a DDL implicit

What is the importance of application dba? 1. it is very important to review the SQL statements written by developers and correct SQL statements with performance problems. compile complex business logic SQL statements. Because the SQL statements

[Oracle] RAC-ha rac's HA is a major selling point. Oracle often promotes it, but in fact, RAC is not really a HA, because it is a share-disk architecture, it can only achieve instance-level HA. The technical foundation of RAC instance-level HA is

Use of Table functions in Oracle -- 1. table and array use example create or replace type t_test as object (id integer, rq date, mc varchar2 (60); create or replace type t_test_table as table of t_test; create or replace function f_test_array (n in

Diagnose and solve row chained and migrated Listing Chained Rows of Tables and Clusters1.execute the UTLCHAIN. SQL or UTLCHN1. SQL script. the script is located at: @ oracle_home \ rdbms \ admin \. The script content is rem $ Header: utlchain. SQL 07

Oracle pre-defined several system exceptions and their causes named system exceptions cause access_0000_null undefined object CASE_NOT_FOUND CASE if the corresponding WHEN is not included, when ELSE is not set, the COLLECTION_IS_NULL set element

PLSQL data import and import data (1) log on to plsql as an administrator; (2) create a command window (3) create a user, set an account, and create a password statement: create user usernameidentified by password; (4) create a tablespace. Create

Oracle automatic partition oralce automatically backs up and deletes the backup export script five days ago in linux: export ORACLE_BASE =/opt/oracle --- installation PATH: export ORACLE_HOME =/opt/oracle/920 --- Product Directory: export PATH =/ora/

Oracle string Split 1. CREATE an array SQL code create or replace type T_RET_TABLE is table of VARCHAR2 (512) 2. CREATE a string segmentation FUNCTION SQL code CREATE OR REPLACE FUNCTION F_SPLIT_STRING (AS_STR VARCHAR2, AS_SPLIT VARCHAR2) RETURN

Start with... in Oracle... connect by recursion in Oracle start... connect by prior clause usage connect by is used in structured queries. Its basic syntax is: select... from tablename start with condition 1 connect by condition 2 where Condition 3;

SQL statements related to oracle table for deleting Foreign keys 1. find all the tables that reference a table with the primary key as the foreign key. PK_SRVMONITOR_SERVICE is the primary key name of the table. The SQL code is select c.

   Install BW and ERP on a server, while BW uses the oracle9 environment, while ERP uses the oracle10 environment. to install two versions of oracle, you need to make some minor changes, two services on the other side cannot be started at the same

How to install multiple versions of oracle Database on one host this article takes installing two versions of oracle Database on one host (oracle 10g/11g) as an example to give a brief introduction. The system environment uses ol5.8 and uses