ewtoc.html
来自「Oracle资料大集合」· HTML 代码 · 共 606 行 · 第 1/3 页
HTML
606 行
<A HREF="chap5_6.html">5.6 Enforce uniqueness via an index?</A><br> <A HREF="chap5_7.html">5.7 Partition an index?</A><br> <A HREF="chap5_8.html">5.8 Create a bitmapped index?</A><br><p><A HREF="chap6.html">Chapter 6: Constraints</A><P> <A HREF="chap6_1.html">6.1 Create a primary key constraint?</A><br> <A HREF="chap6_2.html">6.2 Add a foreign key constraint?</A><br> <A HREF="chap6_3.html">6.3 Add a column check constraint?</A><br> <A HREF="chap6_4.html">6.4 Create a table constraint?</A><br> <A HREF="chap6_5.html">6.5 Determine foreign key dependencies?</A><br> <A HREF="chap6_6.html">6.6 Enable, disable, and enforce constraints?</A><br> <A HREF="chap6_7.html">6.7 Add cascading delete functionality?</A><br> <A HREF="chap6_8.html">6.8 Create a sequence to generate a unique number?</A><br> <A HREF="chap6_9.html">6.9 Determine integrity violations?</A><br> <A HREF="chap6_10.html">6.10 Create a deferred constraint?</A><br><p><A HREF="chap7.html">Chapter 7: Views </A><p> <A HREF="chap7_1.html">7.1 Create a view?</A><br> <A HREF="chap7_2.html">7.2 Determine all of the views owned by a particular user?</A><br> <A HREF="chap7_3.html">7.3 Determine if a view can be updated?</A><br> <A HREF="chap7_4.html">7.4 Create an updatable join view?</A><br> <A HREF="chap7_5.html">7.5 Simulate a cross-tab query using a view?</A><br> <A HREF="chap7_6.html">7.6 Re-create CREATE VIEW statements?</A><br> <A HREF="chap7_7.html">7.7 Implement record level security using views?</A><br><p><A HREF="chap8.html">Chapter 8: Security</A><p> <A HREF="chap8_1.html">8.1 Grant system and object privileges?</A><br> <A HREF="chap8_2.html">8.2 Create a role?</A><br> <A HREF="chap8_3.html">8.3 Grant roles to users?</A><br> <A HREF="chap8_4.html">8.4 Enable and disable roles at runtime?</A><br> <A HREF="chap8_5.html">8.5 Determine the privileges associated with a role?</A><br>  <A HREF="chap8_6.html">;8.6 Determine a user抯 access to a particular object?</A><br> <A HREF="chap8_7.html">8.7 Determine which users have access to a object?</A><br> <A HREF="chap8_8.html">8.8 Enable database auditing?</A><br> <A HREF="chap8_9.html">8.9 View audit information?</A><br> <A HREF="chap8_10.html">8.10 Delete audit information?</A><br> <A HREF="chap8_11.html">8.11 Manage passwords?</A><br><p><A HREF="chap9.html">Chapter 9: Space Management</A><p> <A HREF="chap9_1.html">9.1 Detect objects close to maximum extents?</A><br> <A HREF="chap9_2.html">9.2 Detect row chaining and migration in tables?</A><br> <A HREF="chap9_3.html">9.3 Correct row migration in tables?</A><br> <A HREF="chap9_4.html">9.4 Determine and coalesce the free space in a tablespace?</A><br> <A HREF="chap9_5.html">9.5 Allocate unlimited extents for a database object?</A><br> <A HREF="chap9_6.html">9.6 Deallocate unused space in a segment?</A><br> <A HREF="chap9_7.html">9.7 Configure database files to extend automatically?</A><br><p><A HREF="chap10.html">Chapter 10: PL/SQL</A><p> <A HREF="chap10_1.html">10.1 Create anonymous PL/SQL blocks?</A><br> <A HREF="chap10_2.html">10.2 Achieve conditional and looping control?</A><br> <A HREF="chap10_3.html">10.3 Create a stored procedure?</A><br> <A HREF="chap10_4.html">10.4 Create a stored function?</A><br> <A HREF="chap10_5.html">10.5 Create a stored package?</A><br> <A HREF="chap10_6.html">10.6 List information about stored objects in the database?</A><br> <A HREF="chap10_7.html">10.7 Overload procedures and functions in packages?</A><br> <A HREF="chap10_8.html">10.8 Create variables to represent database records and columns?</A><br> <A HREF="chap10_9.html">10.9 Achieve array functionality with PL/SQL Index-By tables?</A><br> <A HREF="chap10_10.html">10.10 Handle predefined exceptions and system errors?</A><br> <A HREF="chap10_11.html">10.11 Handle user-defined exceptions and user-defined errors?</A><br> <A HREF="chap10_12.html">10.12 Rebuild statements to create stored modules?</A><br><p><A HREF="chap11.html">Chapter 11: Querying Data</A><p> <A HREF="chap11_1.html">11.1 Issue single record queries with implicit cursors?</A><br> <A HREF="chap11_2.html">11.2 Issue multiple record queries with explicit cursors?</A><br> <A HREF="chap11_3.html">11.3 Use cursor attributes to monitor cursor state?</A><br> <A HREF="chap11_4.html">11.4 Use cursor parameters to enhance cursor reusability?</A><br> <A HREF="chap11_5.html">11.5 Use cursor variables for more flexibility?</A><br> <A HREF="chap11_6.html">11.6 Use wildcards in a query?</A><br> <A HREF="chap11_7.html">11.7 Lock rows when I query them?</A><br> <A HREF="chap11_8.html">11.8 Prevent the selection of duplicate rows?</A><br> <A HREF="chap11_9.html">11.9 Traverse a tree structure?</A><br><p><A HREF="chap12.html">Chapter 12: Built-In Packages</A><p> <A HREF="chap12_1.html">12.1 Execute dynamic SQL with DBMS_SQL?</A><br> <A HREF="chap12_2.html">12.2 Submit scheduled jobs with DBMS_JOB?</A><br> <A HREF="chap12_3.html">12.3 Communicate between sessions with DBMS_PIPE?</A><br> <A HREF="chap12_4.html">12.4 Monitor the database asynchronously with DBMS_ALERT?</A> <br> <A HREF="chap12_5.html">12.5 Read and write operating system files with UTL_FILE?</A> <br> <A HREF="chap12_6.html">12.6 Use comma separated lists with DBMS_UTILITY?</A><br> <A HREF="chap12_7.html">12.7 Manage large objects with DBMS_LOB?</A><br><p><A HREF="chap13.html">Chapter 13: Triggers</A><p> <A HREF="chap13_1.html">13.1 Create a database trigger?</A><br> <A HREF="chap13_2.html">13.2 Use column values within database triggers?</A><br> <A HREF="chap13_3.html">13.3 Fire triggers selectively using trigger predicates?</A> <br> <A HREF="chap13_4.html">13.4 Perform cascading deletes with database triggers?</A><br> <A HREF="chap13_5.html">13.5 Disable and enable triggers ?</A><br> <A HREF="chap13_6.html">13.6 List information about triggers?</A><br> <A HREF="chap13_7.html">13.7 Rebuild CREATE TRIGGER statements?</A><br><p><A HREF="chap14.html">Chapter 14: SQL Statement Tuning</A><p> <A HREF="chap14_1.html">14.1 Identify potentially inefficient queries with the V$SQLAREA view?</A><br> <A HREF="chap14_2.html">14.2 Use EXPLAIN PLAN to analyze query execution paths?</A><br>  <A HREF="chap14_3.html">;14.3 Use the AUTOTRACE system variable to analyze query execution paths?</A><br> <A HREF="chap14_4.html">14.4 Determine elapsed execution time in SQL*Plus?</A><br> <A HREF="chap14_5.html">14.5 Analyze SQL statements with SQL*Trace and the TKPROF utility?</A><br> <A HREF="chap14_6.html">14.6 Set the optimizer mode?</A><br> <A HREF="chap14_7.html">14.7 Pass hints to the optimizer?</A><br> <A HREF="chap14_8.html">14.8 Suppress indexes in a query?</A><br> <A HREF="chap14_9.html">14.9 Structure data warehouses for star query optimization?</A><br> <A HREF="chap14_10.html">14.10 Register applications to simplify performance tracking?</A><br><p><A HREF="chap15.html">Chapter 15 Database Tuning</A><p> <A HREF="chap15_1.html">15.1 Run the UTLBSTAT and UTLESTAT scripts ?</A><br> <A HREF="chap15_2.html">15.2 Identify unbalanced I/O and I/0 contention?</A><br> <A HREF="chap15_3.html">15.3 Stripe a tablespace across multiple devices?</A><br> <A HREF="chap15_4.html">15.4 Determine shared pool performance?</A><br> <A HREF="chap15_5.html">15.5 Determine the buffer cache hit ratio?</A><br> <A HREF="chap15_6.html">15.6 Assess the impact of adding database buffers?</A><br> <A HREF="chap15_7.html">15.7 Record and save performance statistics over time?</A><br> <A HREF="chap15_8.html">15.8 Identify rollback segment contention?</A><br> <A HREF="chap15_9.html">15.9 Determine the best size for the redo log buffer?</A><br> <A HREF="chap15_10.html">15.10 Measure and improve checkpoint performance?</A><br> <A HREF="chap15_11.html">15.11 Determine and improve overall sort performance?</A> <br> <A HREF="chap15_12.html">15.12 Detect contention for the database buffer cache?</A><br> <A HREF="chap15_13.html">15.13 Detect and resolve lock contention?</A><br><p><A HREF="chap16.html">Chapter 16: Create an Object Relational Database</A><p> <A HREF="chap16_1.html">16.1 Create object types and use them in relational tables?</A><br> <A HREF="chap16_2.html">16.2 Use constructor methods to populate object relational tables?</A><br> <A HREF="chap16_3.html">16.3 Create and use object tables?</A><br> <A HREF="chap16_4.html">16.4 Create and use the VARRAY collection type? </A><br> <A HREF="chap16_5.html">16.5 Create and use the nested table collection type?</A><br> <A HREF="chap16_6.html">16.6 Create and use object views?</A><br> <A HREF="chap16_7.html">16.7 Issue DML commands on object views and use INSTEAD OF triggers?</A><br> <A HREF="chap16_8.html">16.8 Use MAP and ORDER methods to compare objects?</A><br><p><A HREF="chap17.html">Chapter 17: Oracle Web Application Server</A><p> <A HREF="chap17_1.html">17.1 Administer Database Access Descriptors (DADs) and Cartridges?</A><br> <A HREF="chap17_2.html">17.2 Return the results of a query to a web document?</A><br> <A HREF="chap17_3.html">17.3 Create an HTML form?</A><br> <A HREF="chap17_4.html">17.4 Use multi-valued form fields?</A><br> <A HREF="chap17_5.html">17.5 Use HTML tables in my web documents?</A><br> <A HREF="chap17_6.html">17.6 Use JavaScript to handle events?</A><br> <A HREF="chap17_7.html">17.7 Access and use CGI environment variables?</A><br> <A HREF="chap17_8.html">17.8 Maintain persistent states with cookies?</A><br></blockquote><!-- </td></td></tr></table> --></td></td></tr></table><!-- begin footer information --><MAP NAME="footer"><AREA SHAPE=RECT COORDS="0,0,62,26" HREF="http://www.itlibrary.com/"><AREA SHAPE=RECT COORDS="62,0,135,26" HREF="http://www.developer.com/about/"><AREA SHAPE=RECT COORDS="135,0,199,26" HREF="http://www.itlibrary.com/search/"><AREA SHAPE=RECT COORDS="200,0,274,26" HREF="http://www.itlibrary.com/subscribe/"><AREA SHAPE=RECT COORDS="275,0,335,25" HREF="http://www.developer.com/contact/adinfo.html"><AREA SHAPE=RECT COORDS="335,0,417,25" HREF="http://www.developer.com/contact/"><AREA SHAPE=RECT COORDS="418,0,467,26" HREF="http://www.developer.com/about/faq.html"></MAP><P><table width="640" cellpadding="0" cellspacing="0" border="0"><tr><TD WIDTH="130"></TD><td width="468"><IMG SRC="../../../images/footer/footerfile.gif" ALT="footer nav" width="467" height="26" BORDER="0" usemap="#footer" ismap></td></tr><tr><TD WIDTH="130"></TD><td width="468"> <font face=arial,helvetica size="1"> Use of this site is subject certain <a href="http://www.developer.com/legal/">Terms & Conditions.</a><br>Copyright (c) 1996-1999 <A HREF="http://www.earthweb.com/">EarthWeb, Inc.</A>. All rights reserved. Reproduction in whole or in part in any form or medium without express written permission of EarthWeb is prohibited.<a href="http://www.earthweb.com/corporate/privacy.html">Please read our privacy policy for details.</a></td></tr></table></BODY></HTML>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?