Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


241: On the null value in oracle
Talk of oracle null value in the database, null value to indicate the actual value of the case of unknown or meaningless. In a table, if a line out there is no value, then call it the null value (NULL). Any data type column, as long as there is no u...

242: Two DBA's record
Two DBA's record [b] [color = red] This article discusses: [url] http://www.itpub.net/showthread.php?s=abcf47c1bcb26051a3ed97ad6f45a17a&threadid=168270 [/ url] [/ color] [/ b] Inside in a chat room chat DBA to see the two records, the fe...

243: FORM call from REPORT procedure?
FORM call from REPORT procedure? FORM call from REPORT procedure? Calling the menu REPORT Procedure (non-mass parameters, mass parameters can be used following the procedure below) Run_Product (REPORTS, statements of program name. REP, SYNCHRONOU...

244: How do I view a database of all kinds of data files?
How do I view a database of all kinds of data files? System environment: 1, the operating system: Windows 2000, the machine memory 128M 2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, the installation path: C: ORACLE Method: SQL...

245: How do I view all forms of disk space occupied by the situation?
How do I view all forms of disk space occupied by the situation? Software environment: 1, Windows NT4.0 + ORACLE 8.0.4 2, ORACLE installation path: C: ORANT SQL statement: SQL> col tablespace format a20 SQL> select b.file_id document ID...

246: Nested tables and variable arrays
Nested table of nested tables and variable arrays First, the definition of nested table: Nested table is the table of the table. A nested table is a collection of some firms, it said in the main table for one of them. The main table records each, ...

247: How do you install the Linux machines to run Oracle
How do you install the Linux machines to run Oracle Original author: Uche Ogbuji (uche.ogbuji @ linuxworld.com) Original name: How to get Oracle up and running on your Linux box - A practical guide to basic installation and use Abstract: Oracle a...

248: How to install JSP in Windosws2000 and visit the Oracle?
How to install JSP in Windosws 2000 and visit the Oracle? How to install JSP in Windosws 2000 and visit the Oracle? System environment: 1, the operating system: Windows 2000 2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, the ins...

249: How Oracle using PL / SQL have a random number
How Oracle using PL / SQL random number generated in Oracle to provide the standard Package did not have a random number of the function or procedure. The following example is the use of PL / SQL more of a random number generator. CREATE OR REPLACE...

250: HP-UX10.20 how to correctly configure the system Oracle8.0.5
How HP-UX 10.20 system to correctly configure Oracle 8.0.5 Configure the operating system - HP-UX Version - 10.20 Hardware System - HP9000 System - K580 Subsystem - Oracle 8.0.5 Solution HP-UX 10.20 in the system correctly configured Oracle 8...

251: How to effectively use the data dictionary
How to effectively use the data dictionary ORACLE database's data dictionary is an important part of one, it generated with the database created, with the database changes, Reflected in the number of sys user tables and views. Data Dictionary ...

252: Hematemesis Proc dedication compiler under Linux know-how
Hematemesis Proc dedication compiler under Linux know-how first of all, my system is Redhat Linux9.0 + Oracle9i R2, if different from your own check, I will not be responsible for, but can be discussed: fzbook@vip.sina.com. Oracle9i R2 provides a p...

253: Internet computing technology Oracle8i
Internet computing technology of Oracle 8i Oracle's latest products built with Oracle 8i database management more features, and an extension of the traditional advantage on the Internet, the development of mining resources, to simplify mobile c...

254: internal password
internal password Q: oracle dba studio I changed the password for sys and then later in the sqlplus can be used to enter connect internal / connect to oracle? 8.1.6 Os for oracle for win2kpro A: you connect internal / oracle-go is the OS authentic...

255: InstallingOracle9iDatabaseonRedHat
Installing Oracle9i Database on Red Hat Linux 9 Database Version: Oracle9i R2 (9.2.0.1.0) 1. Creating users and groups: ------------------------- Become root and execute the following commands $ Su -- # Groupadd oinstall # Groupadd dba # Use...

256: FORM, how to use a warning?
FORM, how to use a warning? FORM, how to use a warning? DECLARE I NUMBER; BEGIN SET_ALERT_BUTTON_PROPERTY (warning people, ALERT_BUTTON1, LABEL, prompt 1); SET_ALERT_BUTTON_PROPERTY (warning people, ALERT_BUTTON2, LABEL, prompt 2); SET_ALERT_...

257: Fedora1/rhas3 installed oracle9.2.0, and upgrade to 9.
Fedora 1 / rh as 3 to install oracle 9.2.0, and 9.2.0.4 detail the process of upgrading to this article in the installation of Fedora 1 after completion of the write. I successfully installed n times, has always had a problem can not be resolved. O...

258: 3 minutes to create oracle database
3 minutes to create oracle database Add the following fields / etc / system file, restart * Start Oracle Parameters set shmsys: shminfo_shmmax = 4294967295 set shmsys: shminfo_shmmin = 1 set shmsys: shminfo_shmmni = 128 set shmsys: shminfo_shm...

259: 2000 under the use of OEM (oracleenterprisemanager)
2000 under the use of OEM (oracle enterprise manager) 1. Using Configuration Assistant to create a new database. 2. ManagementServer services to ensure that the open (in the service for Oracle??? ManagementServer). 3. Oem open the console, the fi...

260: 10g does not support the Linux distribution to install 10g solution
10g does not support the Linux distribution to install 10g solution 1). Run runInstaller-ignoreSysPrereqs, it will skip the check. 2). From www.puschitz.com modify / etc / redhat-release file: # su - root # cp / etc / redhat-release / etc / redh...


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