Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle ²Ù×÷±íʾÀý

1.´´½¨±í£º
       a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
           Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
       b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test (xm char(20) not null,zy varchar(30) default (‘¼ÆËã»ú’));
                -- Create table
                create table DEPT
                                (
                                    DEPTNO NUMBER(2) not null,
                                    DNAME VARCHAR2(14),
                                    LOC    VARCHAR2(13)
                                  )
                                tablespace USERS
                


Ïà¹ØÎĵµ£º

Oracle´æ´¢¹ý³Ì×ܽá

1¡¢´´½¨´æ´¢¹ý³Ì
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--ÉùÃ÷±äÁ¿(±äÁ¿Ãû ±äÁ¿ÀàÐÍ)
begin
--´æ´¢¹ý³ÌµÄÖ´ÐÐÌå
end test;
´òÓ¡³öÊäÈëµÄʱ¼äÐÅÏ¢
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date is: ......

Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö

Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£ 
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
 
1 create or replace procedure NoParPro
2 as  ;
3 begin
4 ;
5 exception  &nb ......

Oracle²é¿´·ÖÇø±íÐÅÏ¢


ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢
ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÐÅÏ¢£ºDBA_PART_TABLES
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íÐÅÏ¢£ºALL_PART_TABLES
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄÐÅÏ¢£ºUSER_PART_TABLES
ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºDBA_TAB_PARTITIONS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ ......

ORACLE 9I·þÎñÆ÷Æô¶¯ºÍ¹Ø±Õ

·þÎñÆ÷Æô¶¯µÄ¹ý³Ì
       OracleÊý¾Ý·þÎñÆ÷µÄ³£¹æÆô¶¯¹ý³Ì:
        1¡¢Æô¶¯TNS¼àÌý             C:\Documents and Settings\Administrator>lsnrctl start
     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ