Oracle

When you use rollup or cube for group operations, fields with null values are generated, then, how can we tell whether the field itself is null or generated by rollup and cube? In this case, grouping (groupingfield) can be used to solve the

Mos documentation describes the upgrade Route: Complete check list for manual upgrades to11gr2 [ID 837570.1] Maclean's Blog contains several more intuitive images:

Oracle 9i provides 16 scalar data types, as shown in Table 7.4.Table 7.4 scalar Data Types of Oracle 9i Name Description Char Used to describe

1. Select name, type from SYS. all_sourceWhere instr (upper (text), 'tbname')> 02. Select name, type from user_dependencies where referenced_name = upper ('tablename ');3. Dynamically input a table name and create a new table in the Stored

SQL ************************************* **********Create Table AA(A_id number (10) primary key,A_name varchar2 (50 ),A_sex varchar2 (4 ),A_date date,A_money number (8, 2))-- Check whether the operation is successful.Select * from AA;-- Create a

 I. Description Previous instructions: Oracle cross-operating system migration Http://blog.csdn.net/tianlesoftware/article/details/7252788   Oracle cross-operating system migration Http://blog.csdn.net/tianlesoftware/article/details/7252788   Oracle

 1. Description of the default tablespace In Oracle9i, if you do not use the default tablespace clause, all users will use the system tablespace as their default tablespace. You cannot specify a default tablespace for the database. The

Read consistency ensures that the query results are consistent with the data at the time when the query is initiated, regardless of whether other transactions have changed the data during the query.   Assume that we have the following function to

Rollup will gradually remove a field on the right from the right to the left Based on the field following group by, and gradually sum up, Cube sums all the combinations of fields after group.   Cube eg1:  Select department_id, job_id, sum (salary)

Without authid CURRENT_USER, The definer permission (definer rights) is executed as the definer identity; If authid CURRENT_USER is added, the caller permission (invoker rights) is executed as the caller.   Example:   1. Create two users: xxpo and

You can also use the field name like '% string %' in Oracle. However, this method cannot use indexes and is not fast. Use a string to compare the instr function (field name, 'string') to 0 to get more accurate search results. Processing of Oracle

Create or replace package pkg_tools Is Type resultdata is ref cursor; Procedure sp_page (p_pagesize int, -- number of records per page P_pageno int, -- current page number, starting from 1 P_sqlselect varchar2, -- query statement, including sorting

C: \ Documents ents and Settings \ Administrator> oradim-startup-Sid testbas C: \ Documents ents and Settings \ Administrator> set oracle_sid = testbas C: \ Documents ents and Settings \ Administrator> sqlplus "/As sysdba" SQL * Plus: Release 9.2.0.4

In the article "Install RHEL 5.2 record (1)", we will first learn how to install rhel5.2 to install oracle. After some exploration, we finally set up the RHEL environment, including the Chinese language environment (although this is not much help

Document directory 2. Usage of case when in different positions in the statement 1. The case when expression has two forms: -- Simple case function case sex when '1' then' male 'when' 2' then' female 'else' other 'ends -- case search function

On Thursday's European version of The Wall Street Journal, Oracle published a large number of front-page ads to talk to Sun Microsystems customers. This advertisement promises to increase investments in Sun's hardware and Solaris software, but it

 -- 1. Learning jobs in PLSQL -- Learning job -- Create a table Create Table test_job (para_date date ); Commit; Insert into test_job values (sysdate ); Commit;   Select * From test_job; -- Establish the storage process Create or replace procedure

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted.1. Create SequenceFirst, you must have the create sequence or

This is a virtual table. You can use this table when operating most Oracle Objects, such as sequence and sysdate.For example, select sysdate from dualSelect seq1.nextval from dualAnd so on. 1. Dual is created by SQL. bsq. When each database is

In Oracle databases, undo has three major functions: providing consistent read, rollback transaction, and instance recovery). Consistent read is relative to dirty read (dirtyRead. Assume that a table t contains 10000 records. It takes 15 minutes to