| Home : Databases : Oracle |
| Click "Subscribe" if you want to be notified of new or updated links in this category. | Subscribe |
|
|
Oracle Listings
|
|
Total:
94 | Displaying: 1 - 10 | Pages: 1 2 3 4 5 6 7 8 9 10 >> |
|
|
|
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 Database Performance Tuning Guide is an aid for people responsible for the operation, maintenance, and performance of Oracle. This book describes detailed ways to enhance Oracle performance by writing and tuning SQL properly, using performance tools, and optimizing instance performance. It also explains how to create an initial database for good performance and includes performance-related reference information. This book could be useful for database administrators, application designers, and programmers.
Updated: 04/05/2005
|
|
|
Oracle Listings
|
|
Total:
94 | Displaying: 1 - 10 | Pages: 1 2 3 4 5 6 7 8 9 10 >> |
|
|
