Advanced SQL And  PL

Advanced SQL And PL PowerPoint PPT Presentation


  • 79 Views
  • Uploaded on
  • Presentation posted in: General

A Guide to Oracle9i. 2. Lesson A Objectives. Learn how to create and use indexesBecome familiar with PL/SQL stored program unitsLearn how to create server-side stored program units in SQL*PlusLearn how to use Forms Builder to create stored program units. A Guide to Oracle9i. 3. Database Indexes.

Download Presentation

Advanced SQL And PL

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


1. A Guide to Oracle9i 1 Advanced SQL And PL/SQL Topics Chapter 9

2. A Guide to Oracle9i 2 Lesson A Objectives Learn how to create and use indexes Become familiar with PL/SQL stored program units Learn how to create server-side stored program units in SQL*Plus Learn how to use Forms Builder to create stored program units

3. A Guide to Oracle9i 3 Database Indexes Similar to an index in a book Table with list of sorted data values and corresponding physical location Used to speed searches Uses ROWID column to represent physical location Primary key indexed automatically Unlimited number allowed, but more indexes means more processing time for action queries (insert, update, delete)

4. A Guide to Oracle9i 4 Creating an Index Create index after table data is loaded CREATE INDEX index_name ON tablename (index_fieldname); Convention for naming index: tablename_fieldname.

  • Login