Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


701: Oracle Database Character Set Problem Analysis
Often see some of my friends asked ORACLE character set issues, I would like to iterative way to tell us. The first iteration: character set to master the basic concepts. Some people may think this is an unnecessary, but in fact it is precisely be...

702: ORACLE function Guinness
SQL in a single-record function 1.ASCII Return with a specified number of characters corresponding to the metric system; SQL> select ascii ( 'A') A, ascii ( 'a') a, ascii ('0 ') zero, ascii (' ') space from dual...

703: SQL * Loader will use Excel to export data to Oracle database
System environment: 1, the operating system: Windows 2000 Server, the machine memory 128M 2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, the installation path: C: \ ORACLE The realization of these steps: 1, open the MicroSoft Ex...

704: ORACLE inside as ROWNUM query to obtain the same effect as the first record set M to N records
if exists (select * from dbo.sysobjects where id = object_id (N '[dbo]. [p_show]') and OBJECTPROPERTY (id, N'IsProcedure ') = 1) drop procedure [dbo]. [p_show] GO / *-- Achieve universal paging stored procedure Show the specified...

705: Oracle Introduction to basic knowledge of one-click
1. A table space can only belong to one database. 2. Each database at least one control file (recommendation 3, respectively, on a different disk). 3. Each database at least one tablespace (SYSTEM tablespace). 4. To establish the purpose of SYSTE...

706: Oracle Import text data
Dos environment using SQl * Loader command load The use of other data transfer tools Oracle Enterprise Manager to load data function Technology specific A, Dos environment load 1, first of all, server-side must have the listening service open. ...

707: LOB field in ORACLE use and maintenance of
Abstract: This paper describes, through examples of ORACLE database DBMS_LOB package through the use and maintenance of LOB data types of the basic method. Keywords: ORACLE DBMS_LOB LOB maintenance CLC number: TP31 1, Introduction With the devel...

708: How does it work Oracle
From ----" Oracle backup and recovery " -------------------------------------------------- ------------------------------------------------- A man named Sid, film-loving feverishly to preserve and organize photos. Sid's wife, named D...

709: A strange way to get the temporary table the issue of Oracle
Procedures often require a primary key in the framework of subquery, and the scope of the former Taichung dynamically generated, so the only mass from a string format to determine the scope of the primary key of the sql statement. Before it is In ac...

710: oracle how to write case statement inside
As follows: SELECT LogID, UserID, LogTime, Url, Description, (case OperateType when OperateType = 0 then 'new' when OperateType = 1 then 'modify' else 'deleted' end case) FROM LOG? ? ? ? 1. Case SELECT LogID, UserID, LogTi...

711: How to completely remove Oracle
Software environment: 1, Windows 2000 + ORACLE 8.1.7 2, ORACLE installation path: C: \ ORACLE Method: 1, Start -> Settings -> Control Panel -> Administrative Tools -> Services to stop all Oracle services. 2, to start -> program -...

712: In. Net deployment setup oracle full client Strategy
The main thing is to do three tasks: packing paper, write the registry, environment variables registered Description: My oracle version 9, in 2000 advanced server on the test, you can create a normal database connection 1. <BR> Directory resu...

713: oracle Optimization
oracle performance optimization of the basic method 1. Set reasonable performance goals 2. The test and record the current performance 3. To determine the current performance bottleneck oracle 4. To wait for the events recorded in the tracking f...

714: In. Net in Oracle date types of processing
Oracle database, Oracle found the date type is difficult to handle, for example, November to November -2004, and characters must be on, I do not know why, read out from the database and then updated in the same circumstances can not be updated, is t...

715: ORACLE 9I rebuild tablespace TEMP
1.startup - start the database 2.create temporary tablespace TEMP2 TEMPFILE '/ home2/oracle/oradata/sysmon/temp02.dbf' SIZE 512M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED; - to create a temporary table space transit 3.alter database ...

716: Oracle expert tuning secrets
Preface In the past decade, Oracle has become the world's one of the most professional of the database. For IT specialists is to ensure that the use of Oracle's powerful features to improve the productivity of their companies. One of the mo...

717: Oracle temporary table space for the use of attention
Note the use of temporary table space: 1. Temporary table space is used during the sorting operation (such as large-scale inquiry, the creation of a joint inquiry between the index and store temporary data) Each user has a temporary table space 2...

718: Oracle stored procedure JAVA Developer
Oracle stored procedure JAVA Developer Java stored procedures to simplify the use of database operations Author: Kuassi Mensah Communication using Java stored procedures SQL, XML, Java, J2EE and Web services. Stored procedure (stored procedure) ...

719: oracle data pump step
This two-day trial ora10g the data pump, the steps will be posted by us take a look at As a result of my experiment is not a lot of database data, so data pump speed advantage is not obvious, but the backup file size than a lot of exp out of the bi...

720: ORACLE Applications fool common problem in 1000 asked B
21. How ORACLE TABLE crawl MEMO type field of the data record is empty? select remark from oms_flowrec where trim (from remark) is not null; 22. How to use BBB to update the information table table AAA (associated field) UPDATE AAA SET BNS_SNM = ...


Page 36 of 37
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]