Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


581: Oracle access to the internal information memory section (b)
Bucket 3 size = 140 Bucket 4 size = 236 Bucket 5 size = 268 Bucket 6 size = 524 Bucket 7 size = 1036 Bucket 8 size = 2060 Bucket 9 size = 4108 Bucket 10 size = 8204 Bucket 11 size = 16396 Bucket 12 size = 32780 Bucket 13 size = 65548 Buck...

582: Oracle access to the internal information memory section (a)
Taking HeapDumps: Heapdumps in the current session by using the command alter system set events or oradebug events command. Heapdumps will be written to process a trace file directory dump below (udump), its corresponding information contained in t...

583: Interpretation of the control file Oracle 9201 (b)
363. ************************************************ ****************** 372. ************************************************ ****************** 440. ************************************************ ****************** 444. **********************...

584: Interpretation of the control file Oracle 9201 (a)
Line 1 to the first line of the contents of 22 documents for the control of the header information, this part of the explanation, see "dump control file header." 1. Dump file e: \ oracle \ admin \ test \ udump \ test_ora_376.trc 23 .****...

585: Oracle9i New Features: iSQLPLUS
Its client, middle, server can be located on the same machine can also be located in different machines. iSqlPlus do not need a separate installation, visit iSqlPlus You only need to know the middle-tier server's address and port, or can be a s...

586: Oracle Data Sheet binding with DataGrid
, finally found how to bind data table to the DateGrid way. However, the empirical error committed in the beginning is to Google to find and look for a long time did not find, or later found CSDN community. Oh,. This is the version of Oracle. ( st...

587: Oracle date format on knowledge
oracle date format in general and are based on dd-Mon-yyyy, ie 10 - Aug -2004 this format, and we extract the general format is the format of such 2004-8-11, taken in the sql statement ...

588: Oracle operations (JOB) update of next_date
Abstract: Through experiments and analysis of events to track the implementation of Oracle Job process of amending the mechanism of the next execution time. p_jobno number; P_nextdate date; begin - To call this stored procedure next_date the job...

589: Oracle's problem
Meeting this morning, would have to use services IIMS result, Oracle will not start again, and carry out most of the day, I have to study this problem. Now finally launched, as to why I could not find. Oralce 10G is not used. The question of sympto...

590: Fedora Core 3 to install Oracle 10.1.0.3 Summary Process
Spent time this morning completed the first installation of a Linux platform (: P, a bit of a shame that the first time), primarily in the light of http://www.oracle.com/technology/global/cn/pub/articles / smiley_10gdb_install.html the installation ...

591: SQLServer and Oracle Comparison of commonly used functions
Mathematical functions 1. Absolute S: select abs (-1) value O: select abs (-1) value from dual S: select ceiling (-1.001) value O: select ceil (-1.001) value from dual S: select floor (-1.001) value O: select floor (-1.001) value from dual S...

592: In redhat install oracle 10g
This article will guide you to install the following: - Oracle 10g (10.1.0) on Red Hat Enterprise Linux Advanced Server 3 (RHELAS3) - Oracle 10g (10.1.0) on Red Hat Enterprise Linux Advanced Server 2.1 (RHELAS2.1) - Oracle 10g (10.1.0) on Red Hat...

593: Oracle9i New Features - Index of surveillance and attention to matters
1. From Oracle9i started, Oracle allows you to monitor the use of index: SQL> connect scott / tiger @ conner Connected to Oracle9i Enterprise Edition Release 9.2.0.4.0 Connected as scott SQL> select index_name from user_indexes; INDEX_NAME --...

594: Unable to connect oracle 10g error to exclude
F: \ WINNT \ system32 \ drivers \ etc> sqlplus scott / tiger @ testdb SQL * Plus: Release 8.1.7.0.0 - Production on Monday, December 6 11:09:34 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-12514: TNS: listener i...

595: JDBC + Hibernate will Blob data into Oracle
Oracle's Blob special field, he long field performance than the much better, such as the picture can be used to save the binary data type. Write into the Blob field and other types of fields is very different, because there is a Blob own cursor...

596: UNIX oracle 10g can be used to read file data packets utl_file you
WINDOW I use ORACLE 8i under utl_file can read data from text files, I test, UNIX oracle 10g but not in it! Error! begin loadfiledata ( 'd: \ ora','1. txt '); end; ORA-06512: at "SYS.UTL_FILE", line 33 ORA-06512: at &qu...

597: Table for the database automatically generated line number - to lay a solid foundation for the paging
It is a pity that Oracle is not SQL Server2000 corresponding attribute ROWNUM can be used, Boy with "triggers" to generate a ROWNUM column] I can barely use, of course, use the following SQL statement can also generate the first i pages,...

598: Oracle If "gender" fields such indexing
As a result of "gender" in this field rarely changes in value, the establishment of different Normal index is useless. But we will still be in the query often search "for the male sex more than 30-year-old" such a condition, if i...

599: Find a date in Oracle errors
Often have to retrieve the data that occurred nearly a month of data, so using the following statement select * from eventtable where eventdate> sysdate-30, when the small amount of data also fail to see the amount of data you will find large num...

600: Descending index on the Oracle and retrospective determination
Index is essentially a descending FBI, through its specific definition of query user_ind_expressions or dba_ind_expressions. Well, the same way, descending index can only be used under the CBO. Connected as eygle ------------------------------ --...


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