Oracle

Oracle log files include warning logs, trace logs, and audit logs,Redo logs: Archive logs.Warning log: the alert log, which corresponds to the background_dump_dest set in the system initialization parameter file.View the location of the log

Oracle job introductionMain scenariosPerform related operations on the background at regular intervals. For example, save the data of one table to another at every night, and 2. Back up the database at regular intervals. It is difficult to start

  Oracle 11g R1 is installed on 32-bit XP. When the Database Configuration Assistant is last executed, an error "ORA-28547: failed to connect to the server, possibly Oracle Net management error" is reported. Google's method was fruitless, and the

  Create or replace procedure test_proc is V_corpid corpinfo. corpid % type: = '20140901 '; Vv corpinfo % rowtype; -- Define a cursor Cursor one is Select * from corpinfo where corpinfo. corpid like v_corpid; Begin -- Traverse cursor 1 Open

When remotely connecting to the database, the following error message is reported: ORA-01031: insufficient privileges An error occurred while trying to grant sysdba to sys. SQL> grant sysdba to sys; Grant sysdba to sys * ERROR at line 1: ORA-0

When oracle8 is released, objects can be used in the database. You can define your own classes, that is, object types. They are similar to classes in java and can contain constructors, attributes and methods ., Object Types sometimes become

Numeric FunctionsSQL code-- Both input and output are numbers.-- Abs (x) obtains the absolute value.Select abs (-1) from dual; -- 1 -- Ceil (x) returns the smallest integer greater than or equal to n.Select ceil (1.4), ceil (-2.5) from dual; -- 2,-2 

Generally, for a database with a single function, you can set an optimizer mode at the instance level,For example, for OLAP systems, most of the time the database runs a report job, the execution is basically an aggregate SQL operation,For example,

Case 4: Oracle diagnosis using SQL _trace Problem description: many times, when we perform database operations, such as drop user and drop table, we often encounter such errors. ORA-00604: error occurred at recursive SQL level 1. This prompt is

C: \ Documents ents and Settings \ Administrator> sqlplus/nologSQL> connect system/password as sysdbaConnected.SQL> shutdown normalORA-01109: the database is not open  The database has been detached.The ORACLE routine has been disabled.SQL> startup

Oracle sequence Learning I. Create a sequenceCreate sequence [user.] Increment by Start with [Maxvalue | nomaxvalue][Minvalue | nominvalue][Nocycle]  it can be positive or negative, but cannot be 0. If this clause is not available, the default

The project involves big data parsing and import. Before importing a piece of data each time, you need to go to the database to determine whether the data exists. This data is used for update and insertion., The execution efficiency is not generally

SQL code-- SubmitSelect * from reportnobenefit;Variable job1 number;BeginDbms_job.submit (: job1, 'pkg _ JOBS. CALC_NOBENEFIT; ', sysdate, 'trunc (last_day (sysdate) + 100 ');End; -- RunBeginDbms_job.execute (222 );Commit;End; -- RemoveVariable job1

Oracle Function Format:Create or replace function user-defined function name [(parameter)]Return Value TypeIsReturn Value TypeBeginOperationEnd; Test:Input empno to obtain the user name,CREATE OR REPLACEFUNCTION FUN_SEL (aa emp. EMPNO % TYPE)

Oracle10.2 dblink impd: copying data from different users in the same database and copying data from different users in the same database 1. authorize the user to import tables; SQL> grant exp_full_database to system; SQL> commit; 2. create dblink;

SQL statement in Oracle time format -- 12-hour system current time (AM) SQL> select to_char (sysdate, 'yyyy-MM-DD HH12: MI: SS am') from dual; -- 24-hour system current time (PM) SQL> select to_char (sysdate, 'yyyy-MM-DD HH24: MI: SS pm') from dual;

Use sqlplus to execute *. summary of common problems in SQL Files case 1 Description: After using sqlplus to log on to the database, enter @ file name full path to execute *. SQL file example: assume there is a test. the path of the SQL file is/home/

The oracle trigger example creates a DML statement-Level trigger. When the INSERT, UPDATE, and DELETE operations are performed on the emp table, it automatically updates the data in the dept_summary table. DDL statements cannot be directly called in

Tips for Oracle database query I. Cancel duplicate rows. For example, in the personnel management system, there is a basic employee information table. This table may contain fields such as department, position, employee name, and ID card number. If

Order by index usage problem: id is PK select a,b,id from adf where rownum  The result is 'ORDER BY' first, and then execute rownum select a,b,id from adf where rownum  The result is to execute rownum SQL> select * from t; ID ID1 ---------- 1 2 2 2 4