Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


641: VC under the Pro * C development using Oracle interface
Abstract This article describes the use of Pro * C / C + + in Visual C + + environment under the Oracle database interface development process. Key program design, database interface program, Oracle Overview In Visual C + + under development Orac...

642: Oracle 9i table and easy access to build the index DDL statement
We all know that before in 9i, in order to get to build the statement table and index is a very troublesome thing. We usually through the practice of export with rows = no to get, but it is because the output format and can not be directly used to u...

643: ORACLE lock
ORACLE database is the area of today's most widely used database, at the same time it is also a large system, a comprehensive understanding of it, Topsy Not only does it need a certain degree of theoretical knowledge, but also need to develop ex...

644: Oracle9i database manually create
Author: Ho-induced billion Oracle U.S. special consultant Taiwan The previous issue, we examine the core elements of Oracle9i database entities, I am sure the Oracle9i database server has a degree of understanding. I will introduce the current Orac...

645: Chinese description Oracle9i initialization parameter (b)
Value range: 0 - PARALLEL_MAX_SERVERS. Default value: 0 log_archive_dest_state_3: Note: Specify the archive log parameters (only LOG_ARCHIVE_DEST_3) the availability of state. If this is enabled, Objectives will be archiving the log. If the dela...

646: Chinese description Oracle9i initialization parameter (a)
Blank_trimming: Description: If the value is TRUE, even if the length of the source than the target length (SQL92 compatible) longer, but also allow the distribution of data. Range: TRUE | FALSE Default value: FALSE serializable: Description: i...

647: ORACLE common SQL syntax and data objects
1. Data Control statements (DML) part of http://www.acnow.net/ srr0U 1.INSERT (data table to record the statement insert) http://www.acnow.net/ srr0U INSERT INTO table (field names 1, Field Name 2, ... ...) VALUES (value 1, value 2, ... ...); ht...

648: Start Oracle analysis of common problems
Instance and database startup and shut down is one of the important functions DBA. Only open the database to other users of the database to operate. Once the database shut down their operation will not be able to. For the DBA to run, shut down and r...

649: In Oracle to return multiple result sets
Oracle does not support batch queries and therefore can not return to a command from the multiple result sets. When using the stored procedure to return multiple result sets to return a single result set is similar; must use the REF CURSOR output pa...

650: Oracle script common Memo
1, to create a table T2, so that the structure has a T1 CREATE TABLE T2 AS SELECT * FROM T1 WHERE 1 <> 2; 2, create a table T2, with T1 to form the structure and data CREATE TABLE T2 AS SELECT * FROM T1; 3, to amend the province did michae...

651: Oracle functions List Info
PL / SQL function group one-way function and explain Function is a zero or more parameters and return value of a procedure. Oracle built-in SQL in a series of functions, these functions can be referred to as SQL or PL / SQL statement, function is m...

652: Oracle query to see how the implementation plan
SQLPLUS is AutoTrace analysis of the implementation of SQL plan, the implementation of the efficiency of a very simple and convenient tool, in most cases, is also a very useful tool. 1. How do I set up and use AUTOTRACE SQL> connect / as sysdba...

653: jb + oracle + weblogic cmp since growth in the use of primary key
1. In the database were the establishment of a sequence: create sequence suntest; 2. To create a table example: create table suntest2 ( id number (9) primary key, name varchar2 (20), email varchar2 (40) ) 3. Jb the table used to convert cmp ...

654: ORACLE storage in the process of how to do a simple dynamic query
CREATE OR REPLACE procedure ZXM_SB_GZ_GET (p_table in varchar2, p_name in varchar2, p_value in varchar2, outpara out lntxdba.zxm_pag_cs_power.c_type ) as begin declare wherevalue varchar2 (200); begin wherevalue: = 'select * from'...

655: Oracle database through the JDBC connection of several techniques
Java Database Connectivity (JDBC) API is a series that allows Java programmers to access the database interface, each interface is not exactly the same developer. Here are some skills, these skills will enable us to better system performance and to ...

656: Oracle Pro * C / C + + cursor and stored procedure performance test reports
1.1 The purpose of that Oracle database for Pro * C / C + + programmers tend to records in the database to read, Pro * C / C + + development tools to provide the two kinds of methods on the database to read and write: what I call a cursor (Cursor) ...

657: How to Learn Oracle
Oracle often have some of the beginners asked this question, here is a unified response. 1, if there is a database that is how SQL thing, even to write simple SQL, but you can look at moving them, you can jump to 2. Otherwise, please look at the fo...

658: ORACLE PERFORMANCE SQL TUNING
Recommend that users personally tested before use, do not blindly use the following methods and suggestions! 17. The use of table alias (Alias) When the SQL statement to connect more than one table, use the table alias of an alias and the prefix o...

659: Oracle automatically activated under linux and stop
1, amend the Oracle system, configuration file / etc / oratab / etc / oratab format: SID: ORACLE_HOME: AUTO AUTO field is set to the Y (upper case), the only way, oracle and dbstart own dbshut be able to play a role. I am for: ora9i: / home/oracl...

660: ORACLE lock management
ORACLE lock in the following modes: 0: none 1: null space 2: Row-S line-sharing (RS): Shared Table Lock 3: Row-X dedicated line (RX): for line changes 4: Share share lock (S): to prevent other DML operations 5: S / Row-X share a dedicated line...


Page 33 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]