Oracle±í¿Õ¼äµÄ½¨Á¢
CREATE TABLESPACE mySpace
datafile
'd:\data\data1.dbf' size 1M reuse
autoextend on next 100k maxsize 2M
'd:\data\data2.dbf' size 1M reuse
online
permanent;
ÆäÖÐonline±íÁª»ú¡£
Áª»úºÍÍÑ»úµÄÇø±ðºÍʹÓÃ
Áª»ú£º ORACLE·þÎñ½ø³Ì¹ØÁªÎļþ¡£¿É¹©oracle¿Í»§¶Ë·ÃÎÊ.Èç¹ûÔÚϵͳÖÐÖ±½Óɾ³ýʱ»áµ¯³öÒì³£¡£
ÍÑ»ú: ²»ÓëORACLE·þÎñÆ÷¹ØÁª,ORACLE¿Í»§¶ËÒ²ÎÞ·¨·ÃÎÊ¡£ÔÚϵͳÖпÉÒÔÖ±½Óɾ³ý¡£ ʹÓó¡ºÏ: ±ÈÈç˵ij¸öÎļþÏÖÔÚ²»ÏëʹÓÃÁË£¬¿ÉÒÔÉèÖÃΪÍÑ»ú¡£µ±ÔÚÐèҪʱÔÚÉè»ØÀ´¡£
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
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 ......
1.´´½¨±í£º
a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......
author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......
oracle×Ö·û´®·Ö¸îºÍÌáÈ¡
·Ö¸î
create or replace function Get_StrArrayLength
(
av_str varchar2, --Òª·Ö¸îµÄ×Ö·û´®
av_split varchar2 --·Ö¸ô·ûºÅ
)
return number
is
lv_str varchar2(1000);
lv_length number;
begin
lv_str:=ltrim(rtrim(av_str));
&nb ......