Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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רÓк͹²Ïí·þÎñģʽ

רÓÐģʽ£º
ÔÚרÓзþÎñÆ÷ÅäÖÃÖУ¬OracleΪÿ¸öÁ¬½Óµ½·þÎñÆ÷µÃ¿Í»§»úÆô¶¯Ò»¸öרÓ÷þÎñÆ÷½ø³Ì¡£Ò»¸ö¿Í»§»úµÄרÓ÷þÎñÆ÷½ø³ÌֻΪ´Ë¿Í»§»ú¹¤×÷¡£¸÷רÓ÷þÎñÆ÷½ø³ÌÍêÈ«¶ÀÁ¢£¬ÎÞÐè¹²ÏíÊý¾Ý¡£ÔÚÓû§»á»°´æÔÚµÄÕû¸ö¹ý³ÌÖУ¬ÏàÓ¦µÄרÓ÷þÎñÆ÷½ø³ÌÒ»Ö±´æÔÚ£¬²»ÂÛÓû§ÊÇ·ñ»î¶¯¡£Ö±µ½Óû§»á»°ÖÕÖ¹ºó£¬¸ÃÓ¦ÓõÄרÓ÷þÎñÆ÷½ø³Ì²ÅÖÕÖ¹¡£ÔÚ ......

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 impÃüÁîÐеÄʹÓÃ

   ÒÔǰ¾­³£Ê¹ÓÃoracleµÄ¿Í»§¶Ë¹¤¾ßtoadÀ´½øÐÐÊý¾Ý¿âµÄµ¼ÈëºÍµ¼³ö£¬Æäʵ¸öÈ˵¹²»Ï²»¶ÓÃÕâ¸ö¿Í»§¶Ë¹¤¾ß£¬¸Ð¾õ¹¦ÄܺÜÇ¿´óµÄÒ»¸ö¹¤¾ß£¬dbaÊÊÓ᣿ª·¢»¹ÊÇÓÃpl/sql±È½ÏºÃ£¬¼ò½àµÄ½çÃæ¡£
  C:\Users\Administrator>imp nwgis/pass file=e:/nwgis20100529.DMP log=dible_db full=y ignore=y
Æô¶¯ÃüÁîÐУ¬ÐÞ¸Ä ......

OracleÖ®º¯ÊýÓë´¥·¢Æ÷

½ñÌìдÓйØOracleÖк¯ÊýÓë´¥·¢Æ÷µÄÄÚÈÝ£¬ÔÚÊý¾Ý¿âÖж¨Ò岢ʹÓô洢¹ý³Ì¡¢º¯Êý¡¢´¥·¢Æ÷£¬¿ÉÒÔÌá¸ßÓû§·ÃÎÊÊý¾Ý¿âµÄЧÂÊ¡£
    Êý¾Ý¿âÖк¯Êý°üº¬Ëĸö²¿·Ö£ºÉùÃ÷¡¢·µ»ØÖµ¡¢º¯ÊýÌåºÍÒì³£´¦Àí¡£
 1 create or replace function getname(sno varchar2 )
 2 &nbs ......

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


ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢
ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÐÅÏ¢£ºDBA_PART_TABLES
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íÐÅÏ¢£ºALL_PART_TABLES
ÏÔʾµ±Ç°Óû§ËùÓзÖÇø±íµÄÐÅÏ¢£ºUSER_PART_TABLES
ÏÔʾOracle²é¿´·ÖÇø±íÐÅÏ¢ ÏÔʾÊý¾Ý¿âËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ºDBA_TAB_PARTITIONS
ÏÔʾµ±Ç°Óû§¿É·ÃÎʵÄËùÓзÖÇø±íµÄÏêϸ·ÖÇøÐÅÏ¢£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ