Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


541: oracle8i steps in the installation of linux9
After this step is the installation of the number of days of this practice and make reference to other users integrated into the document, it is only used to install REDHAT LINUX 9.0 use oracle 8.1.7. Here express my sincere gratitude to those frien...

542: TURBOLinux 7.0 installed Oracle 8.1.7.0.1 release 3
-------------------------------------------------- ----------------------------- RAM: 256M Objective: To TURBOLinux 7.0 installed in the Oracle 8.1.7.0.1 release 3 Enterprise Edition database server. (A) the need to package compatible TURBOLinux,...

543: Check with a number of java from oracle
drop table varray_table; drop type num_varray; / CREATE TABLE varray_table (col1 num_varray); INSERT INTO varray_table VALUES (num_varray ( 'Hello', 'abc')); import java.math .*; import oracle.jdbc.driver .*; import oracle.sql...

544: Study summary: Oracle software architecture
Oracle database server by the two main components: a database and examples. . Examples of the memory structure: SGA (system global areas) and PGA (program global areas) . Examples of the process of structure: service processes and background proce...

545: Oracle user's password a modified small know-how
Database Version: 9.2.0 .5 Sometimes we may not know a user's password, but they need to operate the user to do something and not out to change the user's password, this time, they can use some tips to complete the operation. Specific op...

546: [Oracle 10g] Table space name
Briefly SQL> COL FILE_NAME format a70 SQL> SET linesize 120 SQL> SET pagesize 99 SQL> COL TABLESPACE_NAME format a10 SQL> SQL> SELECT file_name, tablespace_name FROM dba_data_files; FILE_NAME TABLESPACE --------------- -----------...

547: oracle_sid, server_name, network connectivity, database restart
Network drive version of SQL * Net, Net8 using the database instance host name string structure; network version Net8i, Oracle9i Net Services, the host using the database service name string. Start the database instance: Read the parameter files, ...

548: Oracle work encountered a case of failure analysis and processing
Case Type: VAS network System Type: CMODE System Version: Hardware: SUN software: all versions Case title: CMODEthe database approach LOCK Failure phenomenon: sam_cmode start the process of workers alone can not deal with. Fault Description: St...

549: servlet from the oracle database blob field read out a document and display
* ReadFile.java * * Created on 2004 years 11 17, pm 3:41 * / import java.net .*; import javax.servlet.http .*; import java.sql .*; import jgwl.base.DataBaseConnection; import java.io. *; import oracle.sql .*; * * @ Author Roy Chen * @ Ve...

550: Oracle project development skills
Participate in the "digital bus" project has been more than a month, I am basically responsible for the completion of the module and pass the test Oracle based on the item of C / S structure, and involve a number of database operations, s...

551: Oracle Self-realization of the definition of a temporary table and its application in Oracle Spatial
Oracle temporary table features: Temporary table in Oracle is the overall situation, the need to create a complete database design, rather than the procedures used. Each landing a user to use the same temporary table, but do not see each other each...

552: ORACLE Q & A
ORACLE in the application of all time may seem to run into a lot of it is not difficult, especially for the novice, today I would like to briefly summarize it, publish to everyone, I hope all of you help! And the community together to explore common...

553: Oracle database table changes the table space
In the Oracle database management system, create a database table (table) to assign a tablespace (tablespace), If you do not specify table space, use the system users do Tablespace province. 1.1. Db_zgxt to export all tables (Dos console) db_zgxt E...

554: About Oracle Spatial
About Oracle Spatial: First of all, Oracle support for custom data types, you can use an array, structure or with a constructor, the type of function to define their own object type. This object type can be used for attribute data types, can also b...

555: Oracle Spatial Data Encryption Research
Oracle 9i2 features: 1, the return value of custom object type of function. For example, data type SDO_GEOMETRY. 2, can be written in Java or C stored procedure. ÷ Oracle Spatial advanced features: Can use the return value SDO_GEOMETRY data typ...

556: ORACLE rollback segment management
Rollback Segment Overview Rollback segment used to store the data value before the modification (including changes to the data location and value). Rollback segment that contains the head of the rollback segment is in use of information services. A...

557: Spring called ORACLE stored procedure result set
advanced features for the oracle is always different (I strongly dislike this point, if the use of its products will be on this product Specific programming, which is good I do not like weblogic platform reasons), access to a large object to set it...

558: Oracle temporary tables to optimize query speed
1, Introduction At present, all support the use of Oracle as a database application platform, most of relatively large amount of data systems, that is, the amount of data table under normal circumstances are more than one million in the amount of d...

559: Oracle added the use of temporary table
1, when the designated temporary table on commit preserve rows for a time (conversation level), in the current SESSION like to have to drop the table when, oracle tips: drop table student 3, the time to create a temporary table can also specify a ...

560: Configure Oracle, it supports the distribution of services under the MTS
1. According to Q193893, which we need to set up two views of Oracle. ...


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