| Home : Databases : Oracle |
| Click "Subscribe" if you want to be notified of new or updated links in this category. | Subscribe |
|
|
Oracle Listings
|
|
Total:
95 | Displaying: 1 - 10 | Pages: 1 2 3 4 5 6 7 8 9 10 >> |
|
|
|
Solix Enterprise Database Archiving restores application performance up to 50% by relocating inactive data from your production database to a secure online data archive. Database Archiving automates the archive and purge process by offloading underutilized data from the production environment, ensuring good operational performance during heavy load times such as quarter end. By deploying enterprise archiving, organizations maintain performance and can reduce the IT burden of large data sets.
Updated: 10/06/2008
|
|
|
Flip a table on the side (SQL Trick)
Updated: 12/22/2006
|
|
|
Kill all sessions of a specified user name
Updated: 12/22/2006
|
|
|
Rebuild all unusable indexes (and partitioned indexes)
Updated: 12/22/2006
|
|
|
Move Tables of user PROD_USER like this:
Tables + indexes of tables EMP,PRODUCTS,CUSTOMERS into tablespace TBS1.All the other tables + indexes of this user into tablespace TBS2.
Updated: 12/22/2006
|
|
|
After installing Oracle Database Version 8.1.7 and above it is possible to change the Character set of the database.
Assuming that the Database does not contain Important Data or Contains only English Language Characters It is possible to use the following script in order to change the Character set and National Character set.The word internal_use in the script is essential only when changeing between sets that dont belong to the same familliy.By writting internal_use it is possible to switch between Any Character set to Any Other.
Updated: 12/22/2006
|
|
|
This tutorial explains the ways and steps of creating and managing database accounts, Creating Users through Sql Plus, Creating User through iSQL*PLUS, Creating Users through EM, Manager Users, Managing Users through sqlplus and Managing Users through EM along with screen shots, step by step Instructions and frequently asked questions.
Updated: 05/24/2005
|
|
|
Course Description: This course introduces students to data server technology, and explores the concepts of relational databases and the powerful SQL and PL/SQL programming languages. Students will learn and practice how to create and maintain database objects. You will also learn to store, retrieve, and manipulate data. Finally, you will learn how to create PL/SQL blocks of application code that can be used in Oracle forms, reports, and other Oracle applications
Updated: 04/29/2005
|
|
|
This reference contains a complete description of the Structured Query Language (SQL) used to manage information in an Oracle Database. Oracle SQL is a superset of the American National Standards Institute (ANSI) and the International Standards Organization (ISO) SQL:1999 standard.
Updated: 04/05/2005
|
|
|
PL/SQL, Oracle's procedural extension of SQL, is an advanced fourth-generation programming language (4GL). It offers software-engineering features such as data encapsulation, overloading, collection types, exceptions, and information hiding. PL/SQL also supports rapid prototyping and development through tight integration with SQL and the Oracle database
Updated: 04/05/2005
|
|
|
Oracle Listings
|
|
Total:
95 | Displaying: 1 - 10 | Pages: 1 2 3 4 5 6 7 8 9 10 >> |
|
|
