Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


681: oracle imp character set problems
Question: Imp a dmp file in time, suggesting that does not support the required character set conversion (from the type 850-852). Principle: ORACLE multiple languages around the world set up to support the language and character set, most of the ...

682: Oracle products and services and technical-level introduction to
Many of my friends asked about the Oracle database of legitimate products and pirated products What is the difference between them, in fact, from the product itself, the distinction is not, you can download from the OTN Web site a database product, ...

683: oracle data query page
1. The best or the use of analytic functions row_number () over (partition by col1 order by col2) 100-150 For example, would like to remove the records, in accordance with the sort tname select tname, tabtype from ( select tname, tabtype, row_nu...

684: oracle database insert special symbols &
oracle insert special characters Environment configuration: server: linux9 db server: oracle817.4 client os: windows2000 pro oracle client: oracle 9i Today, a colleague of mine run the script, insert the data to the database. Data format is as...

685: The use of Oracle database to store and analyze the performance of Unix operating system
I. Preface UNIX system as Oracle database administrator at all times to monitor the performance of the operating system is very important, it is fortunate that a large number of UNIX system control commands, such as vmstat, iostat, sar, top, etc., ...

686: oracle trunc () function usage
TRUNC () function at the two 1.TRUNC (for dates) TRUNC function for a specific element and the date value truncated. Its concrete syntax is as follows: TRUNC (date [, fmt]) Of which: a date value of date fmt date format, the date format will ...

687: On the database name (db_name), instance name (instance_name), ORACLE_SID
The Forum was recently asked to see things in this area, coupled with his understanding of the relevant data are available, if incomplete or improper place, hope its correction and completion. Database name (DB_NAME), instance name (Instance_name),...

688: oracle date function introduced
There are a lot of the oracle on the date of the function, such as: 1, add_months () for a date value from the increase or decrease in number of the month date_value: = add_months (date_value, number_of_months) For example: SQL> select add_mo...

689: Type of Oracle database operations (c #)
OracleConnection connection with Oracle Configuration in the Web.config in <add key="Oracle" value="Data Source=xxx;User ID=xxx;Password=xxx"/> public System.Data.OracleClient.OracleConnection cnn; / / / <summary> ...

690: . NET access to Oracle database-related
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...

691: ORACLE data conversion issues SERVER
We do system updates or upgrades are likely to touch data conversion. ORACLE for the data conversion can be used to write stored procedure to put the cursor to the data you want to convert an article. As for the SERVER Although you can switch to i...

692: Firewall is to blame - Oracle to connect the old broken
nearly two weeks, finally get. Suspected from the very beginning, the problem of the network, then do not think so, the question of the application may be found that the database is likely to be the problem, and finally back to square one truth that...

693: Paging a DataGrid control in ASP.Net
Not write well, for informational purposes only. GridPager.ascx: <% @ Control Language = "c #" AutoEventWireup = "false" Codebehind = "GridPager.ascx.cs" Inherits = "Test.BaseClass.GridPager" TargetSchema...

694: Export oracle database objects --- synonyms, series, view
Script can be divided into two: Synonyms 1: synonym.cmd: sqlplus dxsq / teledoone @ jnnew@synonym.sql 2.synonym.sql: create table tmp_user_synonym as select 'create synonym' | | synonym_name | | chr (13) | | 'for' | | chr (13) |...

695: Oracle training materials
1. SQL Language Introduction 1. SQL Overview SQL is a database-oriented general-purpose data processing language specification, to complete the following types of functions: data extraction query, insert the modified data to delete, modify, and de...

696: Mobile process of Oracle 9i database
Database for mobile, in the project implementation process, often occur, for an experienced DBA, the database is very easy to move. But only for some understanding of the system, the database of persons who are not speaking, oracle is not so mobile ...

697: Oracle 9i installation on the AIX
Operating Environment: RS6000 / Aix 4.3.3 / shell: Korn (ksh) / virtual X-Window Installation media: CD-ROM, a total of four documents named AIX64_901_Disk (1-5). CPIO Installation mode: the hard disk installation Installation steps: 1, the prep...

698: Oracle use of temporary tables in the summary
Note: some of the below description and sample code from CSDN, 11 not specified in the source, in this and related author thanks! If there is objection to the author, please contact us Note 1 syntax in Oracle, you can create the following two tempo...

699: Hot oracle method
A request to create Standby Database 1, Primary and standby database on the host where the oracle server and * must be the same for the system version, and have the same patch; 2, primary database must archive mode; Standby Database is also the ne...

700: ASP call ORACLE stored procedure and return result set
Read online a lot of ASP method called ORACLE, but no special direct special good things, so summing up various things and came to the conclusion that they need a way to feel more so the public is hereby released ###################################...


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