¹ØÓÚORACLE PLSQL¶ÁÎļþ
ת×Ô£ºhttp://www.oracle.com/technology/obe/obe9ir2/obe-cnt/plsql/plsql.htm
¶¼Ëµ¶ÁÊé²»ÇóÉõ½âº¦ËÀÈË£¬Ò»µãÒ²²»´í£¬×î½üÎÒ´ÓÍøÉÏÌÔµ½¹ØÓÚORACLEÈçºÎ´ÓÊý¾Ý¿âĿ¼Ï¶ÁÎļþ£¬ÓÚÊǾÍÓÃÓÚÉú²úÁË£¬½á¹ûÉÏÁËÉú²ú£¬³ÌÐòËÀ»î¾ÍÊÇÅܲ»³öÀ´£¬ÔÒòÊÇÎÒÃǵķþÎñÆ÷×öÁËREC£¬Èç¹ûÔÚÁ½Ì¨»úÆ÷ÉÏÕÒÒ»¸öÄ¿Â¼ÄØ£¬ÒÔÇ°ÄØÔÚ×Ô¼ºµÄ³ÌÐòÀï°Ñ·¾¶Ð´ËÀÁË£¬ÔÚÒ»°ã·þÎñÆ÷ÉÏÑé֤ҲûÓÐÎÊÌ⣬¿ÉÊÇÈç¹ûÊÇË«»úÄØ£¿¾Í²»ÐÐÁË£¬ÄÇÎÒÃÇÖ»ºÃͨ¹ý¹²ÏíĿ¼À´ÊµÏÖ£¬¿ÉÊÇÓÐÁËĿ¼£¬³ÌÐò»¹ÊÇÕÒ²»µ½¾ø¶Ô·¾¶£¬Ôõô°ìÄØ£¬¿´ÏÂÃæµÄ³ÌÐò£¬Ëü¶¼ÊÇÔÚÊý¾Ý¿âÀï´´½¨ÁËÒ»¸öDIRECTORY£¬Ð޸ijÉËü£¬ÎÊÌâÓÈжø½â¡£
ͨ¹ýÏÂÃæµÄÀý×Ó£¬ºÃºÃÑо¿Ò»ÏÂORACLEÌṩ¸øÎÒÃǵŦÄܰɣ¡
Using New PL/SQL Features to Enhance Applications
Module Objectives
Purpose
This module describes how to utilize some of the latest PL/SQL capabilities to optimize performance and increase the efficiency of your PL/SQL applications..
Objectives
Upon completion of this module, you should be able to:
Use an Associative Array
Use the UTL_FILE package to manage access to directories, handle raw data, and copy, rename and delete files
Use Bulk binding in native dynamic SQL
Use PL/SQL RECORDs to access and manipulate changes to the database
Prerequisites
The prerequisites for this lesson are:
Completed the Preinstallation Tasks module
Completed the Installing the Oracle9i Database module
Download and unzip plsql.zip into your working directory
Reference Material
The following list represents some useful reference material should you need additional information on the topics in this module:
Documentation: PL/SQL User's Guide and Reference
Documentation: Supplied PL/SQL Packages and Types Reference
PL/SQL Whitepapers and Code Examples on OTN
Overview
The features you will explore in this lesson are:
1.
Using Associative Arrays
2.
Using the UTL_FILE Package
3.
Using Bulk Binding in Native Dynamic SQL
4.
Using PL/SQL Records
Using Associative Arrays
Back to List
In Oracle9i Database Release 2, PL/SQL index-by tables, now known as associative arrays, have been extended to allo
Ïà¹ØÎĵµ£º
author:skate
tiime:2009-11-18
ORACLEµÈ´ýʼþÀàÐÍ¡¾Classes of Wait Events¡¿
ÿһ¸öµÈ´ýʼþ¶¼ÊôÓÚijһÀ࣬ÏÂÃæ¸ø³öÁËÿһÀàµÈ´ýʼþµÄÃèÊö¡£¡¾Every wait event belongs to a class of wait event.
The following list describes each of the wait classes.¡¿
1. ¹ÜÀíÀࣺAdministrative
´ËÀàµÈ´ýʼþÊÇÓÉÓÚDBAµÄ ......
ʵÏÖ·½·¨£º
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñÍ£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾Oracle Installation Products££¾Universal Installer
жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
&nb ......
Oracle´æ´¢¹ý³Ì¹¦ÄÜÇ¿´ó£¬ËûÖ÷ÒªµÄ×÷ÓÃÓÐÒÔϼ¸µã:
1.¿ÉÒÔÅúÁ¿Ö´ÐÐsqlÓï¾ä£¬ÌṩÄÚÖõÄÊÂÎñÖ§³Ö£¬Í¬Ê±Äܹ»Ìá¸ßÊý¾Ý¿â²Ù×÷µÄЧÂÊ¡£
2.¿Í»§¶Ë³ÌÐòÒÀ¾Ý´æ´¢¹ý³ÌÃûÀ´µ÷Óã¬Ìṩ³ÌÐòµÄ¿ÉÒÆÖ²ÐÔ¡£
3.Ìṩ¸´ÔÓµÄSQLÓï¾äÂß¼Ö§³Ö¡£
Óï·¨½á¹¹°üÀ¨¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£
1£©²»´ø²ÎÊý£º
Create or replace ......
ÔÎÄ´«ËÍÃÅ£ºhttp://topic.csdn.net/u/20091019/11/67cd55a3-3f42-4db7-a3f8-91dd52a913cd.html?24122
¾³£Óöµ½·¢ÌûÇóÐÐÁÐת»»µÄ´úÂ룬ÓÃmax(decode(..))»Ø¸´ºó£¬Ê®Óа˾ŻáÔÙÎÊÒ»¾ä£ºÈç¹ûÁÐÃû²»¹Ì¶¨£¬»òÕßÁÐÊý²»¹Ì¶¨Ôõô°ì¡£¾ÍÒªÓô洢¹ý³ÌÀ´Ð´£¬ÕâЩ´æ´¢¹ý³ÌµÄ´úÂë¶¼´óͬСÒ죬ÎÒ¾ÍÏëÄܲ»ÄÜд¸öͨÓõãµÄ¹ý³Ì
ÊÔÁ ......
1.´´½¨±í¿Õ¼ä
create tablespace test datafile'c:\test.dbf' size 10m; //Ãû×Ö²»ÒªÎªÊý×Ö
2.´´½¨Óû§
create user userName identified by password; //²»ÒªÎªÊý×Ö
3.¸øÓû§ÊÚȨ
grant dba to userName; --ÊÚÓèDBAȨÏÞ
grant unlimited tablespace to userName;--ÊÚÓè²»ÏÞÖÆµÄ±í¿Õ¼ä
grant sele ......