Oracle substr ºÍ instr µÄÓ÷¨
INSTR·½·¨µÄ¸ñʽΪ
INSTR(Ô´×Ö·û´®, Ä¿±ê×Ö·û´®, ÆðʼλÖÃ, Æ¥ÅäÐòºÅ)
ÀýÈ磺INSTR('CORPORATE FLOOR','OR', 3, 2)ÖУ¬Ô´×Ö·û´®Îª'CORPORATE FLOOR', Ä¿±ê×Ö·û´®Îª'OR'£¬ÆðʼλÖÃΪ3£¬È¡µÚ2¸öÆ¥ÅäÏîµÄλÖá£
ĬÈϲéÕÒ˳ÐòΪ´Ó×óµ½ÓÒ¡£µ±ÆðʼλÖÃΪ¸ºÊýµÄʱºò£¬´ÓÓұ߿ªÊ¼²éÕÒ¡£
ËùÒÔSELECT INSTR('CORPORATE FLOOR', 'OR', -1, 1) "Instring" from DUALµÄÏÔʾ½á¹ûÊÇ
Instring
——————
14
oracleµÄsubstrº¯ÊýµÄÓ÷¨
È¡µÃ×Ö·û´®ÖÐÖ¸¶¨ÆðʼλÖúͳ¤¶ÈµÄ×Ö·û´® substr( string, start_position, [ length ] )
Èç:
substr('This is a test', 6, 2) would return 'is'
substr('This is a test', 6) would return 'is a test'
substr('TechOnTheNet', -3, 3) would return 'Net'
substr('TechOnTheNet', -6, 3) would return 'The'select substr('Thisisatest', -4, 2) value from
Ïà¹ØÎĵµ£º
×î½üÒ»¶Îʱ¼äһֱûд²©¿Í£¬²»ÊÇÀÁ£¬ÊÇѧÁËÌ«¶à¶«Î÷¡£ÒÔºóÂýÂý²¹ÉÏ¡£ 1. odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´ odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´Ê×ÒªÌõ¼þ£º°²×°oracle client¡£°²×°ÍêÖ®ºóÌí¼Ó£¬µ«ÊÇ»¹±ØÐëÔÚ°²×°Ä¿Â¼ÏÂͨ³£ÊÇC:\oracle\ora90\network\ADMIN\tnsnames.oraÖÐÌí¼ÓÒ»¸öÁ¬½Ó£¬Èçϸñʽ£º DXS =
(DESCRIPTION =
......
HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øϽµ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......
±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌرðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ ......
-½¨Á¢±í¿Õ¼ä(oracleÖеÄtablespace(±í¿Õ¼ä)¾ÍÏ൱ÓÚsqlserverµÄdatabase)
CREATE TABLESPACE data01
DATAFILE 'D:\oracle\ora92\oradata\db\DATA01.dbf' SIZE 200M
UNIFORM SIZE 128k;
#Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏΪ64k
--½¨Á¢ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE temp_data
TEMPFILE 'D:\TEMP_DA ......