Oracle

Call report in the menu Program (If you do not specify a parameter, you can use the following program segment for passing the parameter) run_product (reports, 'Report program name. rep ', synchronous, runtime, filesystem, '', null); call the Report

1. Create a user Create user Tom Identified by password Default tablespace Temporary tablespace temporary tablespace Quota 20 m on tablespace Password expire; Quota indicates that only the disk space of a specified tablespace can be used. Change its

1. view the Undo segments of the Undo tablespace.Select segment_name, tablespace_name from dba_rollback_segs; 2. view online undo segment informationSelect * from V $ rollname; 3. view all roles in the databaseSelect * From dba_roles; 4. view the

V $ sysstat contains multiple statistical items. This section describes some key v $ sysstat statistical items, which are quite useful in tuning. Sort the following in alphabetical order:   Key indicators of database usage status: L CPU used by this

Expdp/imdp, exp/IMP usage summary. Expdp/imdp can only be used on the server, and exp/IMP can both be used. 1 expdpFirst, create directoryCreate directory dump as 'e: \ dump ';Grant permissions:Grant read, write on directory dump to Scott; Export

Deterministic clause Specify deterministic to indicate that the function returns the same result value whenever it is called with the same values for its arguments. You must specify this keyword if you intend to call the function in the expression

1. Create a table: Create Table stud (Sid int,Sname varchar2 (50))Insert a data recordInsert into stud values (1, 'Tom ') 2. Create a stored procedure -- Create a stored procedureCreate or replace procedure pro_select_name (V_sid in stud. Sid % type,

1. Add the parameters of the target form to the call before the form jump, and assign values to the when-New-form-instance. 2. Trigger problem collection A> sometimes, key-series triggers are famous for controls such as data blocks, forms, and items,

  The data dictionary dict always belongs to the Oracle user SYS.1. User:Select username from dba_users;Change PasswordAlter user spgroup identified by spgtest;2. tablespace:Select * From dba_data_files;Select * From dba_tablespaces; //

In Oracle Database queries, we often encounter queries for tree structure tables, which is a troublesome problem. The following describes an SQL statement for recursive query. Syntax: Select Field 1, Field 2, Field 3 ,... From table name Start with

I flipped through some of the previous documents and found that the SQL statement for querying the Oracle deadlock was saved. This was taught by a previous engineer. Select/* + rule */S. username, Decode (L. type, 'TT', 'table lock ', 'Tx ', 'row

Use the sequence object in the SELECT statement. Check whether group by or order by exists in the same level. Seq_a, table object tablea (F_a, f_ B) Select seq_a.nextval, F_a, f_ B From tablea Group by F_a, f_ B Order by f_ B When we execute the

In practical applications, tree structure data is widely used, such as the directory structure of books and the classification of organization departments !!!!! Such as the Directory of a book Name Code P_code

How to Handle System and SYS password loss in Oracle 　 This article describes how to handle system and SYS password in Oracle. One is OS verification and the other is password file verification. Oracle provides two authentication methods: OS

1. parameter settings during Database Installation The following database version is Oracle 9i ( 9.2.0 ), When the database is installed, the database system will create a database instance, where: The installation directory is/Oracle, the

The following code uses system. Data. oracleclient (. NET for Oracle Data Provider ). 1. How to call functions with return values in Oracle PL/SQL? It can be called by matching the command and parameter objects. The added parameter is matched as the

Topic: use Java to read the Oracle blob field for upload and downloadAuthor: Cai Yi (caiyi0903@hotmail.com)Time: 2005-6-22 1. Blob Overview Blob is called Binary large objects, which is a binary large object. Blob can be divided into three forms:

There are four types of SQL languages: dql, DML, DDL, and DCL. It is used to define the data structure, such as creating, modifying, or deleting a database; DCL is used to define the permissions of database users; in this article, I will detail how

Transaction Control Transaction control includes coordinating multiple synchronous accesses to the same data. When a user changes the data that another user is using, Oracle uses transactions to control who can operate the data. 　　Transactions A

Oracle relational database management system is a popular relational database system in the world. It is an extremely powerful, flexible, and complex system. It is said that this idea should be applied to Oracle, that is, almost any idea can be