Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ô¶³ÌÁ¬½Óµ¼Èëµ¼³öÊý¾Ý¿â

·½Ê½Ò».
Ö´ÐÐÒÔÏÂsqlÓï¾ä´´½¨database link
create database link test_link  --Á´½ÓÃû
  connect to   Óû§Ãû   identified by ÃÜÂë
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Êý¾Ý¿â·þÎ ......

Oracle RACÐÔÄÜ Oracle sequence ÐÔÄܲâÊÔ

ÔÚOracle RAC»·¾³ÖУ¬ÏµÍ³ÐÔÄÜ»áÊܵ½Ó°Ï죬Ö÷Òª¼¯ÖÐÔÚBlockÔÚinstanceÖ®¼äµÄ´«Ê䣬¾¡¹Üoracle 10g ÖвÉÓÃÁËCache FusionÀ´¸ÄÉÆÒÔÇ°ÖØdiskÖжÁÈ¡Êý¾Ý¡£ÆäÖеÄÒ»¸ö²¿·Ö¾ÍÊǹØÓÚoracle sequenceµÄÐÔÄÜÎÊÌâ
ÏÂÃæÊǹØÓÚsequence µÄcacheºÍorder¶Ôrac ÐÔÄܵÄÓ°Ï죬´Ó²âÊÔÖп´µ½Ôö´ócacheºÍ²ÉÓÃnon-orderedµÄsequenceÐÔÄÜÊܵ½µÄÓ° ......

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

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

oracleÖÐpro*cµÄѧϰ


oracleÖÐpro*cµÄѧϰ
¡¡Ò» Pro*C ³ÌÐò¸ÅÊö£º
1£®Ê²Ã´ÊÇPro*C³ÌÐò
ÔÚORACLEÊý¾Ý¿â¹ÜÀíºÍϵͳÖУ¬ ÓÐÈýÖÖ·ÃÎÊÊý¾Ý¿âµÄ·½·¨£»
£¨1£© ÓÃSQL*Plus£¬ ËüÓÐSQLÃüÁîÒÔ½»»¥µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£»
£¨2£© ÓõÚËÄ´úÓïÑÔÓ¦Óÿª·¢¹¤¾ß¿ª·¢µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£¬ÕâЩ¹¤¾ßÓÐSQL*froms£¬QL*Reportwriter,SQL*MenuµÈ£»
£¨3£© ÀûÓÃÔÚ ......

Oracle 1z0 047 Exam


Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-04-15
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns th ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ