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

oracle ¼òµ¥µÄ×Ö·û´®²ð·Öº¯Êý

д´æ´¢¹ý³Ìʱ£¬Óõ½²ð·Ö×Ö·û´®£¬µÚÒ»¸ö´«Èë²ÎÊýΪ´ø·Ö¸î·ûµÄ×Ö·û´®£¬µÚ¶þ¸öΪ·Ö¸ô·ûµÄ¸öÊý£¬ÏÂÃæÊǵ¥Ìá³öÀ´µÄ·Ö¸î×Ö·û´®·½·¨£¬
create or replace procedure split(                              
                                i_PageIds in varchar2,             --Ô­Ò³ÃæpageId×飬ÒÔ×Ö·û´®ÐÎʽ´«Èë,È磺1001,1511,
                                i_PageIdsCount in number          --pageId¸öÊý   £¨Ò²ÊÇ·Ö¸ô·û¶ººÅµÄ¸öÊý£¬¼ÇµÃ×Ö·û´®µÄĩβҲ¼Ó¶ººÅ£©                           
                                )
is
v_pageId number(20);           --±£´æ²ð·Ö×Ö·û´®ÖеÄÖµ
v_i number(20);                      --Ñ­»·ÖеÄË÷Òý
v_strlength number(20);         --½ØÈ¡×Ö·û´®³¤¶È
v_startIndex number(20);        --½ØÈ¡×Ö·û´®¿ªÊ¼Î»ÖÃ
v_tempIndex number(20);       --ÉÏÒ»´Î½ØÈ¡×Ö·û´®¿ªÊ¼Î»Ö


Ïà¹ØÎĵµ£º

Oracle ÖеÄto_date()º¯Êý


to_date()Óë24Ð¡Ê±ÖÆ±íʾ·¨¼°mm·ÖÖÓµÄÏÔʾ£º
Ò»¡¢ÔÚʹÓÃOracleµÄto_dateº¯ÊýÀ´×öÈÕÆÚת»»Ê±£¬ºÜ¶àJava³ÌÐòÔ±Ò²Ðí»áÖ±½ÓµÄ²ÉÓÓyyyy-MM-dd
HH:mm:ss”µÄ¸ñʽ×÷Ϊ¸ñʽ½øÐÐת»»£¬µ«ÊÇÔÚOracleÖлáÒýÆð´íÎ󣺓ORA 01810 ¸ñʽ´úÂë³öÏÖÁ½´Î”¡£
È磺select to_date('2005-01-01 13:14:20','yyyy-MM-d ......

oracle´´½¨ÊÓͼÖÐÉæ¼°µ½ÁíÍâÒ»¸öÓû§µÄ±íȨÏÞ²»×ãÎÊÌâ

    ÔÚoracleÖд洢¹ý³Ì»òÕßÊÓͼµÈ¶ÔÏó´´½¨Ê±£¬Èç¹ûÉæ¼°µ½ÁíÍâÒ»¸öÓû§µÄ±í£¬¼´Ê¹ÄãÒѾ­grant dbaÁË£¬Ò²²»ÐУ¬±ØÐëÏÔʽµØ¸³Óè²éѯȨÏÞ¡£·ñÔò£¬Äã»á·¢ÏÖÔÚpl/sqlÖпÉÒÔÖ´ÐÐÓï¾ä£¬µ«ÊÇÒ»µ©·Åµ½create Öо͸æËßÄãȨÏÞ²»×ã¡£
grant   select   any     table   to   user ......

oracle»ù±¾ÃüÁî

һЩ»ù±¾µÄOracleÃüÁî
»ù±¾ÃüÁî
Á¬½ÓÊý¾Ý¿â
C:>SQLPLUS /NOLOG
SQL>CONN / AS SYSDBA
1.Oracle ¹Ø±Õ
SQL>SHUTDOWN (ABORT|IMMEDIATE|NORMAL)
2.Oracle Æô¶¯
SQL>STARTUP (REMOUNT|MOUNT|OPENT)
3.SQL> HELP SHOW
SHOW
----
Shows the value of a SQL*Plus system variable, or the ......

Oracle ±í¿Õ¼ä»ù±¾²Ù×÷

1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M;
3.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING CONTENTS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ