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

db2ºÍoracleÖеÄÊ÷²éѯ£¨µÝ¹é²éѯ£©Óï¾ä

ÔÚdb2ºÍoracleÖеĶÔÊ÷µÄµÝ¹é²éѯÓï¾ä¡£
±í½á¹¹£º
create table  MAIN_NODE (
MLA_ID               INTEGER     not null        ,   //½ÚµãID
MLA_ROOTID          INTEGER,                      //¸ù½ÚµãID
MLA_PARENTID        INTEGER,                      //¸¸½ÚµãID
MLA_NAME            VARCHAR2(50),                //½ÚµãÃû³Æ
constraint P_mlaid primary key (MLA_ID) );
MLA_ID   MLA_PARENTID  MLA_ROOTID   MLA_NAME
1           0                   0             ¸¸½Úµã1     
2           1                   0            £¨¸¸½Úµã1µÄ/£©×Ó½Úµã1   
3            2                   0            £¨¸¸½Úµã1µÄ/×Ó½Úµã1µÄ/£©Ëï×Ó½Úµã1
4           0                   0   


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Exam : Oracle 1Z0 051

Exam : Oracle 1Z0-051
Title : Oracle Database: SQL Fundamentals I
1. View the Exhibit to examine the description for the SALES table.
Which views can have all DML operations performed on it? (Choose all that apply.)
A. CREATE VIEW v3
AS SELECT * from SALES
WHERE cust_id = 2034
WITH CHECK OPTI ......

Oracle 11g Íü¼ÇÓû§ÃûÃÜÂë½â¾ö°ì·¨(ת)

Çé¿öÃèÊö£º°²×°Ê±Ñ¡ÔñµÄ×Ô¶¯°²×°£¬ÓÉÓÚʱ¼ä¾ÃÔ¶Íü¼ÇÓû§Ãû¡¢ÃÜÂëÁË£¬µ¼ÖÂÏÖÔÚÊÔÁ˼¸¸öĬÈϵÄÓû§ÃûÃÜÂëºó£¬¶¼ÌáʾÎÞЧµÄÓû§Ãû¡¢ÃÜÂë¡£
½â¾ö·½·¨£ºÆô¶¯SQLPLUS£¬ÌáʾÊäÈëÓû§Ãû£¬È»ºóÊäÈësqlplus/as sysdba£¬ÃÜÂëΪ¿Õ¡£ÌáʾÁ¬½Óµ½ÐÅÏ¢£¬Á¬½Ó³É¹¦£¡
Ö´ÐÐalter user sys identified by ÃÜÂë;
ÉèÖóɹ¦£¡
ÏÖÔÚ¿ÉÒÔ´ÓEnterp ......

Oracle DBAÊÖ¼ÇÖ®Eygleƪ

±¾ÎĽÚÑ¡×Ô¡¶Oracle DBAÊּǗ—Êý¾Ý¿âÕï¶Ï°¸ÀýÓëÐÔÄÜÓÅ»¯Êµ¼ù¡·µÚ1Õ“EygleµÄDBA¹¤×÷Êּǔ£¨×÷Õߣº¸Ç¹úÇ¿£©
DBAÈÕ³£¹¤×÷Ö°Ôð——ÎÒ¶ÔDBAµÄ7µã½¨Òé
DBAµÄ¹¤×÷Ö°ÔðÊÇʲô£¿Ã¿ÌìDBAÓ¦¸Ã×öÄÄЩ¹¤×÷£¿Îȶ¨»·¾³ÖеÄDBA¸ÃÈçºÎ³É³¤ÓëÓÅ»¯£¿ÕâÊǺܶàÈ˶¼Ôø¾­Ìá³ö¹ýµÄÎÊÌ⣬ÏÂÃæÊÇÎҵĹ۵ãºÍ½¨Òé£ ......

oracleȨÏÞÎÊÌ⼯ºÏ

1.oracleÉèÖò»Í¬È¨ÏÞµÄÓû§È¥·ÃÎÊͬһ±í¿Õ¼ä
1.create user testa identified by testa;
2.alter user testa default tablespace users temporary tablespace temp;
3.grant connect to testa;
4.grant select any table to testa;
2.ORACLEÖÐÉèÖÃͬһ¸öÓû§¶ÔÁ½¸ö±í¿Õ¼äµÄȨÏ޵ĴúÂë
alter user Óû§ quota unlimi ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ