Oracle

Step 1: orahome92-configuration and migration tools-net managersStep 2: click "+" in "service name"Step 3: edit your service name (not the Database Name of the other party) www.2cto.comStep 4: Select TCP/IP by defaultStep 5: Enter the host name in

Oracle-table join introduction table join refers to the association between tables in an SQL statement to retrieve relevant data from one or more tables. The connection is achieved by the connection conditions between multiple table names of the

Example of accidentally deleting data after oracle Restoration: 1. select * from test_table t // query all data in t_viradsl2. Three data entries are displayed. delete test_table // delete all data in t_viradsl2, and three data entries disappear.

Common Oracle views 1 Common Oracle Data Dictionary tables 1. view the current user's default tablespace SQL> select username, default_tablespace from user_users; 2. view the current user's role SQL> select * from user_role_privs; 3. view the system

Oracle user information query operation statement dba_XXX requires the permission to view, otherwise the report and view do not exist Error 1. query all users (username, tablespace information) [SQL] select * from dba_users; select * from all_users;

Processing Requirements for a large amount of data in the database: a large amount of product order information is retrieved from the ORACLE database, then written into the document in the specified format, and then parsed to the business management

RMAN-06026 Error Analysis and Solution Background: we did not completely recover Based on SCN, and used the _ allow_resetlogs_uption parameter in the process of trying to recover, after resetlogs, oracle uses the current control file does not allow

ORA-06502: PL/SQL: Number or value error: String Buffer too small error analysis 1. problem cause this error is always encountered when you recently perform some oracle operations: ORA-06502: PL/SQL: Number or value error: string buffer is too small,

Oracle time operations and to_char and to_date usage summary Oracle time processing sometimes to_char and to_date are two key functions. Here we will summarize: 1. Obtain the current system time select sysdate from dual; usage of to_char select

The ORACLE digital equivalent comparison imports data to the Oracle EBS system through the interface table. After the system is imported, it is necessary to verify that the data in the system is consistent with that in the Custom interface table.

Oracle scheduled execution of stored procedures 1. create or replace PROCEDURE sp_wftestone (msg varchar) as www.2cto.com begindelete from wf_testone; commit; end; 2. to create a job, run SQL> variable v_jobnum number; SQL> exec dbms_job.submit (: v_

The simple process of manually deleting a database to drop the database is as follows: if the database version is 10 Gb or later, it must be in the mount state. In RESTRICTED mode, sys @ STANDBY3 (dtydb5)> shutdown the database has been disabled.

Failed to export all objects when Oracle11G export object caused by EMP-0001 error in export table, it is because SQL> 1 show parameter DEFERRED_SEGMENT_CREATION NAME TYPE VALUE www.2cto.com before -------------------- ---------------------- begin

Create temporary tablespace wftest_temp tempfile 'e: /Oracle/oradata/orcl/wftest_temp01.dbf 'size 32 m autoextend on next 32 m maxsize 2048 m extent management local;// Create a data table space create tablespace wftest_data logging www.2cto.com

11.2 The create or replace type statement is added and the FORCE option is added. Before 11.2, as long as other tables or types depend on the current object, this object cannot be replaced:SQL> create type t_num_tab is table of number;2/Type created.

In oracle, ASK_TIME ATM_NUMBER 2012-01-01 2 2012-02-01 4 2012-05-01 6 2012-08-01 8 1. grouping BY year www.2cto.com SELECT (to_char (ASK_TIME, 'yyyy') as year, (sum (ATM_NUMBER) as number of ATMs FROM TB_KFWH_WORKREPORT group by to_char (ASK_TIME,

The generation and analysis of oracle awr reports: Automatic Workload Repository (AWR) is an important component introduced by 10 Gb. It stores detailed information about the activity status of the database in the recent period (7 days by default. 1.

Oracle logon trigger analysis oracle logon trigger is generally used to audit user logon information or restrict user logon. Although it is not commonly used, it is still a good way.Note: you cannot audit dba user logon. The following is a specific

Glogin. SQL command analysis glogin. SQL is the first command to execute the sqlplus command. You can use it to set sqlplus environment variables and personalized sqlplus settings. The following example shows my frequently used settings.Vi $

Oracle pl/SQL's "art appreciation" from if to then"In oracle development, the conditional expressions between if and then are full of "art" and require us to discover and appreciate them. Appreciation 1: What is the final result of a three-value