Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


621: BCB rewritten with the preparation of a date format oracle procedure
# include <vcl.h> # pragma hdrstop # include <Registry.hpp> # include "Unit1.h" //------------------------------------------------ --------------------------- # pragma package (smart_init) # pragma resource "*. dfm&q...

622: ORACLE paging a process, very useful
<! DOCTYPE HTML PUBLIC "- / / W3C / / DTD HTML 3.2 Final / / EN"> <HTML> <HEAD> <TITLE> Paging Test </ TITLE> <META NAME="Generator" CONTENT="TextPad 4.0"> <META NAME="Au...

623: Oracle user's password to generate a universal applet
As a Unix system administrators, Oracle database administrator, Oracle ERP application system administrator, need to volatile A view to make changes to the system user's password important to ensure system and data security. However, due to th...

624: On the oracle database modeling and design
To develop a database-based application system, which is the most critical step of the whole system is based on a database built Mold design, from logical to physical, one of negligent design, the application of the whole system built on the danger...

625: oracle temporary table inside the table to resolve a case conflict
Platform: windows 2000 server sp3 Database: Oracle 9.0.1.1.1 Field Description: User can not complain about a number of units of data processing, the implementation of the error message appeared as follows: SQL> exec sp_hyb_da_ryxx_dwbh_test (...

626: ORACLE database to improve speed of query statistics
Large-scale database systems are often used to query statistics, but a large amount of data systems, the complexity of user queries in statistics is often very slow and could not meet the application requirements, which requires us to design a datab...

627: Oracle to optimize the principles of SQL
1. Statements have been tested and the statement in the shared pool should be exactly the same as between 2. The variable name as far as possible consistent 3. Rational use of outside connection 4. The use of multi-nested 5. More complicated Op...

628: optimize windows system to connect the failure of local oracle9i
We use the system is windows2000, after optimized, oracle database problems, the local client can not connect. However, remote access is no problem. After inspection, it was the oracle did not start TNSListener services. With "services" s...

629: Oracle acquired in the use of disk space
Select Distinct SysDate, s.user # As UserID, u.name As UserName, s.ts # As TableSpaceID, d.tablespace_name As TableSpaceName, s.FILE # As DataFileID, d.file_name As DataFileName, d.bytes As Bytes, d.maxbytes As MaxBytes, d.user_bytes As Us...

630: See all of the Oracle table, table space the size of space
Show the current user for each table space size: Select Segment_Name, Sum (bytes) / 1024/1024 From User_Extents Group By Segment_Name View the space occupied by each table space: Select Tablespace_Name, Sum (bytes) / 1024/1024 From Dba_Segments G...

631: Oracle in the Decode () function to use skills
FONT face = Song> decode () function to use skills Software environment: 1, Windows NT4.0 + ORACLE 8.0.4 2, ORACLE installation path: C: \ ORANT Explain the meaning of: decode (conditions, the value of 1, the translation value of 1, the valu...

632: Oracle to connect the left and right connections
In Oracle PL-SQL, the left and right connections to connect to the following manner to achieve See the following statement: SELECT emp_name, dept_name FORM Employee, Department WHERE Employee.emp_deptid (+) = Department.deptid this SQL text usin...

633: Oracle 9i isqlplus in the use of the replacement of variables
By replacing variables can easily create a generic script to achieve the purpose, see the following code: INSERT INTO Employees (emp_name, emp_age, emp_dept) VALUES ( '& empname', & empage, & empdept) Through the "&&qu...

634: Oracle sqlplus command statement editing
First of all, we enter such a command: SELECT emp_id, emp_name FROM Employees Then input the command to add a directive statement, such as in the above statement is running enter: input WHERE emp_age> 30 Instructions can be as follows: SELE...

635: ORACLE-line log file is missing or damaged approach
Lessons Learned: Log into the current line-line logs and online logs of non-current, non-current damage to the log-line is relatively simple, clear commands in general can be adopted to solve the problem. Damage to non-current-line log: 1, start ...

636: oracle database operations: intersect, and minus operator
 intersect operator Return query results in the same part  exp: What are the various departments of the same type of work  select  job  from  account  intersect  select  job  from  research  intersect  ...

637: Study the use of oracle sql loader
A: sql loader characteristics oracle with a lot of their tools can be used for data migration, backup and recovery and so on. But each tool has its own characteristics. For example, exp and imp in the database can be exported and export data from ...

638: ORACLE analysis of common error codes and solutions
Process in the use of ORACLE, we will often encounter some errors ORACLE, for beginners, these errors may be a bit fuzzy, but also I do not know how to time have to deal with these errors, I use more frequently appear in the analysis of error code ...

639: oracle log was written to stop
There are practices here in ORACLE, refer to stop writing log: alter database noarchiverlog Write to restore log: alter database archiverlog Are directed at the current database. ...

640: ORACLE PL / SQL based on 2 (cursor learning)
Cursor learning A> What is a cursor: Literal understanding of the cursor is the cursor swimming. Database language used to describe: the cursor is focused on mapping the results of his data on the location of entities, with the cursor the user...


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