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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
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 ......
Çé¿öÃèÊö£º°²×°Ê±Ñ¡ÔñµÄ×Ô¶¯°²×°£¬ÓÉÓÚʱ¼ä¾ÃÔ¶Íü¼ÇÓû§Ãû¡¢ÃÜÂëÁË£¬µ¼ÖÂÏÖÔÚÊÔÁ˼¸¸öĬÈϵÄÓû§ÃûÃÜÂëºó£¬¶¼ÌáʾÎÞЧµÄÓû§Ãû¡¢ÃÜÂë¡£
½â¾ö·½·¨£ºÆô¶¯SQLPLUS£¬ÌáʾÊäÈëÓû§Ãû£¬È»ºóÊäÈësqlplus/as sysdba£¬ÃÜÂëΪ¿Õ¡£ÌáʾÁ¬½Óµ½ÐÅÏ¢£¬Á¬½Ó³É¹¦£¡
Ö´ÐÐalter user sys identified by ÃÜÂë;
ÉèÖóɹ¦£¡
ÏÖÔÚ¿ÉÒÔ´ÓEnterp ......
±¾ÎĽÚÑ¡×Ô¡¶Oracle DBAÊּǗ—Êý¾Ý¿âÕï¶Ï°¸ÀýÓëÐÔÄÜÓÅ»¯Êµ¼ù¡·µÚ1Õ“EygleµÄDBA¹¤×÷Êּǔ£¨×÷Õߣº¸Ç¹úÇ¿£©
DBAÈÕ³£¹¤×÷Ö°Ôð——ÎÒ¶ÔDBAµÄ7µã½¨Òé
DBAµÄ¹¤×÷Ö°ÔðÊÇʲô£¿Ã¿ÌìDBAÓ¦¸Ã×öÄÄЩ¹¤×÷£¿Îȶ¨»·¾³ÖеÄDBA¸ÃÈçºÎ³É³¤ÓëÓÅ»¯£¿ÕâÊǺܶàÈ˶¼Ôø¾Ìá³ö¹ýµÄÎÊÌ⣬ÏÂÃæÊÇÎҵĹ۵ãºÍ½¨Òé£ ......
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 ......