Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


601: Modify initialization configuration ORACLE 8.1.7
Fail Safe configuration data initialization parameters modify these steps: 1. The need to open the Oracle Fail Safe Control Panel, choose to stop in the Cluster Database 2. Modify init.ora configuration file, the file name initDBNAME.ora or init.o...

602: Oracle experts to learn high-level programming notes (b)
Oracle Architecture of three main components: 1. Documents: the composition of the database instance of the five files (parameter files, control files, data files, temporary data files, redo log files) 2. System overall regional SGA (System Global...

603: oracle system failure emergency treatment
Oracle physical structure database failures is the composition of the various physical file damage caused by failures of various databases. These failures may be caused due to hardware failure, or it may be caused by man-made mistake. Therefore, we ...

604: Oracle 9iAS configuration running FORM, Report
Application server installation to configure the operating system Enterprise Edition installation of Oracle 9iAS ① Oracle 9i Application Server Infrastructure; One: Oracle 9iAS Infrastructure Instance Name: ora9ias_is; Password: ora9ias Instal...

605: Analysis of Oracle and SQL Server
T-SQL is the language of SQL Server engine, and Oracle is the language engine PLSQL. Both query languages are ANSI SQL-92 standards have been expanded to provide additional support. You to create applications used almost all of these added features....

606: C # - Oracle database connection methods
using System; using System.Data; using System.Data.OracleClient; ( public static void Main () ( string myConnString = "user id = zk; data source = zkqx; password =*****"; OracleConnection myConnection = new OracleConnection (myConnS...

607: Access Control I (JBX + struts + hibernate + ORACLE)
The first step: the establishment of UserPermissionFilter category. import javax.servlet.http .*; import java.io. *; import java.util .*; import test.vo.SysUserVO; import test.system.dao.SysUserDao; import test.Const; this.filterConfig = null...

608: C # stored procedure using Oracle Notes
C # stored procedure using Oracle Notes   1. Call contains out / in out type of stored procedure parameters Stored procedure: CREATE OR REPLACE PROCEDURE "SITE_EDITSITEDATAEXIST" (id_ number, name_ varchar2, httpRoot_ varchar2, ...

609: oracle initialization parameters
ALTER DATABASE DATAFILE'd: \ ORANT \ DATABASE \ USER1ORCL.ORA 'RESIZE 1000M; CREATE TABLESPACE INDEX_DATA DATAFILE'd: \ ORANT \ DATABASE \ INDEX_DATA 'SIZE 500M; ALTER DATABASE DATAFILE'd: \ ORANT \ DATABASE \ RBS1ORCL.ORA '...

610: Oracle-related operations (b)
cn.Close (); / / DataReader object is not closed before the connection can not be closed ) catch (OracleException ex) ( Console.WriteLine ( "Exception occurred!"); Console.WriteLine ( "The exception message is: (0)", ex.Mess...

611: Oracle operations related to (a)
A long time, I have been using MS SQL Server / Access databases, through the. NET Access MS own little things that come across any trouble. Recent project to use Oracle as a database, a number of study and research. NET access to Oracle's someth...

612: Oracle bare equipment and 20 cases of Q & A
1. What is the bare equipment? Bare equipment, also known as bare-district (the original partition) is not a format, not Unix file system to read through the special character device. It consists of applications to read and write operation is respo...

613: Read and write using the ODP in the MTS appears Oracle is unable to load solution OraMTS
Oracle database in the operation of the machine: 1. According to KB 193893, in the establishment of two views inside Oracle, use the SYS account. The default path in the script: oracle \ ora92 \ rdbms \ admin \ xaview 2. The establishment of two ...

614: Linux install Oracle9i
Database version: Oracle9i R2 (9.2.0.1.0) 1. To create users and groups: ------------------------- Root switch users and run the following command $ Su -- # Groupadd oinstall # Groupadd dba # Useradd-g oinstall-G dba oracle # Passwd oracle ...

615: Oracle9i New Features - DBMS_METADATA packet access object using DDL statements
Oracle started from Oracle9i provides a new system package DBMS_METADATA, can be used to extract the DDL statements to create the object. This Package features extremely powerful, and we take a look at the use of it. 1. Was to create table stateme...

616: Oracle9iAS Containers for J2EE standalone Guide
Oracle9iAS Containers for J2EE (OC4J) Contains 1.OC4J a JSP Translator, a Java servlet container (deployment methods: first servlet to the standard Web Application aRchive (WAR) document package, OC4J deployment tool provided WAR file on its decom...

617: Oracle characters in length
Before doing a system encountered a problem! Today inadvertently found a solution to this problem and put out!!! Problem description: varchar2 (4000) abc; intert into table_name (abc) values ( 'There are 1500 Chinese characters ... ...');...

618: Optimal adjustment of Oracle 8i database
Oracle 8i database server is highly optimized software products, regular adjustments can optimize the performance of the system, To prevent data bottlenecks. By adjusting our database system, you can enable it to achieve the best performance to mee...

619: Oracle Database Performance Optimization
---- And e-commerce web application with the continuous development of all site traffic increasing, how to make limited Computer system resources services for more users? How to ensure that the user's response to the speed and quality of servic...

620: Using Oracle SQL to achieve file access
Oracle9i are the advantage of one of the most eye-catching, and this is through non-Oracle SQL access to Oracle documents. This A new feature known as the external table (external tables), its system has some very important role, can make non - Da...


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